PREVIEW / stock_1hour / 2007-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-20.parquet
  size:    761 KB
  rows:    37,707
  symbols: 3,123

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2007-09-20 09:00:00	AAPL	Stock	5.0054	5.0154	4.9757	4.9939	94325924.0
2007-09-20 10:00:00	AAPL	Stock	4.9943	5.0357	4.9896	5.0279	126510552.0
2007-09-20 11:00:00	AAPL	Stock	5.0282	5.0639	5.0179	5.0357	97719412.0
2007-09-20 12:00:00	AAPL	Stock	5.0361	5.0479	5.025	5.0357	56162176.0
2007-09-20 13:00:00	AAPL	Stock	5.0354	5.0371	5.0111	5.0201	47003992.0
2007-09-20 14:00:00	AAPL	Stock	5.02	5.0282	4.9989	5.0079	78965264.0
2007-09-20 15:00:00	AAPL	Stock	5.0082	5.0168	4.9961	5.0093	84113260.0
2007-09-20 16:00:00	AAPL	Stock	5.01	5.0111	5.009	5.0111	8662892.0
2007-09-20 09:00:00	MSFT	Stock	28.44	28.58	28.42	28.47	5993974.0
2007-09-20 10:00:00	MSFT	Stock	28.46	28.52	28.4	28.43	8587916.0
2007-09-20 11:00:00	MSFT	Stock	28.43	28.44	28.35	28.4	8469837.0
2007-09-20 12:00:00	MSFT	Stock	28.4	28.46	28.35	28.36	6265570.0
2007-09-20 13:00:00	MSFT	Stock	28.37	28.41	28.34	28.4	5942386.0
2007-09-20 14:00:00	MSFT	Stock	28.395	28.45	28.38	28.43	7069614.0
2007-09-20 15:00:00	MSFT	Stock	28.43	28.5	28.4	28.42	10528586.0
2007-09-20 16:00:00	MSFT	Stock	28.42	28.44	28.42	28.42	1248656.0
2007-09-20 08:00:00	NVDA	Stock	0.8512	0.8588	0.85	0.8588	105800.0
2007-09-20 09:00:00	NVDA	Stock	0.8592	0.8688	0.8445	0.8515	52701800.0
2007-09-20 10:00:00	NVDA	Stock	0.8515	0.8592	0.8482	0.8525	46328000.0
2007-09-20 11:00:00	NVDA	Stock	0.8523	0.8552	0.846	0.85	35146520.0
2007-09-20 12:00:00	NVDA	Stock	0.85	0.8562	0.8485	0.8548	36476000.0
2007-09-20 13:00:00	NVDA	Stock	0.8548	0.8562	0.8518	0.8545	26567240.0
2007-09-20 14:00:00	NVDA	Stock	0.8548	0.8562	0.853	0.855	34558080.0
2007-09-20 15:00:00	NVDA	Stock	0.855	0.8585	0.853	0.854	58912400.0
2007-09-20 16:00:00	NVDA	Stock	0.854	0.8565	0.854	0.8562	7278080.0
2007-09-20 17:00:00	NVDA	Stock	0.8562	0.8562	0.8562	0.8562	48000.0
2007-09-20 18:00:00	NVDA	Stock	0.8565	0.8565	0.8565	0.8565	7080.0
2007-09-20 19:00:00	NVDA	Stock	0.8538	0.8538	0.8538	0.8538	43040.0
2007-09-20 06:00:00	AMZN	Stock	4.4725	4.4725	4.47	4.47	10000.0
2007-09-20 07:00:00	AMZN	Stock	4.475	4.475	4.45	4.45	50000.0
2007-09-20 08:00:00	AMZN	Stock	4.4475	4.45	4.4375	4.4425	261760.0
2007-09-20 09:00:00	AMZN	Stock	4.4425	4.5	4.4355	4.4945	17973180.0
2007-09-20 10:00:00	AMZN	Stock	4.494	4.5208	4.4755	4.501	24305720.0
2007-09-20 11:00:00	AMZN	Stock	4.5005	4.5135	4.4825	4.5	17907240.0
2007-09-20 12:00:00	AMZN	Stock	4.501	4.504	4.484	4.4875	7559340.0
2007-09-20 13:00:00	AMZN	Stock	4.4884	4.4995	4.478	4.4912	6891820.0
2007-09-20 14:00:00	AMZN	Stock	4.4905	4.4975	4.463	4.4745	14344640.0
2007-09-20 15:00:00	AMZN	Stock	4.475	4.505	4.465	4.4825	18100720.0
2007-09-20 16:00:00	AMZN	Stock	4.4825	4.487	4.48	4.4865	245560.0
2007-09-20 17:00:00	AMZN	Stock	4.483	4.483	4.483	4.483	8000.0
2007-09-20 18:00:00	AMZN	Stock	4.4835	4.4835	4.4815	4.4815	14400.0
2007-09-20 19:00:00	AMZN	Stock	4.477	4.477	4.477	4.477	4600.0
2007-09-20 09:00:00	TLT	Stock	88.18	88.21	88.09	88.18	332600.0
2007-09-20 10:00:00	TLT	Stock	88.18	88.29	88.0	88.23	827300.0
2007-09-20 11:00:00	TLT	Stock	88.24	88.27	87.91	88.01	899000.0
2007-09-20 12:00:00	TLT	Stock	88.0	88.01	87.61	87.61	745900.0
2007-09-20 13:00:00	TLT	Stock	87.61	87.75	87.56	87.58	429200.0
2007-09-20 14:00:00	TLT	Stock	87.58	87.58	87.35	87.43	478400.0
2007-09-20 15:00:00	TLT	Stock	87.43	87.43	87.1	87.24	1901700.0
2007-09-20 16:00:00	TLT	Stock	87.22	87.27	87.15	87.15	10700.0

> showing 50 of 37,707 rows — these rows as CSV

> unlock the full archive -- $79 one-time