PREVIEW / stock_1hour / 2008-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-28.parquet
  size:    794 KB
  rows:    39,564
  symbols: 3,262

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
2008-02-28 04:00:00	AAPL	Stock	4.5586	4.5586	4.5486	4.5486	11200.0
2008-02-28 05:00:00	AAPL	Stock	4.5468	4.5468	4.5296	4.5296	8400.0
2008-02-28 06:00:00	AAPL	Stock	4.5389	4.5536	4.5321	4.5357	74620.0
2008-02-28 07:00:00	AAPL	Stock	4.5357	4.5411	4.5	4.5086	3531248.0
2008-02-28 08:00:00	AAPL	Stock	4.5082	4.5464	4.4843	4.535	15397844.0
2008-02-28 09:00:00	AAPL	Stock	4.5343	4.5864	4.4918	4.5675	294707616.0
2008-02-28 10:00:00	AAPL	Stock	4.5671	4.6146	4.5404	4.6107	271431440.0
2008-02-28 11:00:00	AAPL	Stock	4.61	4.6107	4.5714	4.6089	178414292.0
2008-02-28 12:00:00	AAPL	Stock	4.609	4.6421	4.5975	4.6304	146280792.0
2008-02-28 13:00:00	AAPL	Stock	4.6304	4.6396	4.6096	4.6386	116910920.0
2008-02-28 14:00:00	AAPL	Stock	4.6382	4.7143	4.6289	4.7136	249797968.0
2008-02-28 15:00:00	AAPL	Stock	4.7139	4.7214	4.6346	4.6421	317088632.0
2008-02-28 16:00:00	AAPL	Stock	4.6393	4.6469	4.6025	4.6268	21340452.0
2008-02-28 17:00:00	AAPL	Stock	4.6307	4.6496	4.6268	4.6429	1674260.0
2008-02-28 18:00:00	AAPL	Stock	4.6429	4.6479	4.6254	4.6289	541996.0
2008-02-28 19:00:00	AAPL	Stock	4.6314	4.6321	4.6161	4.6214	1066632.0
2008-02-28 08:00:00	MSFT	Stock	28.26	28.26	28.15	28.16	9118.0
2008-02-28 09:00:00	MSFT	Stock	28.17	28.17	27.96	28.0	8472582.0
2008-02-28 10:00:00	MSFT	Stock	28.0	28.27	27.98	28.19	15024892.0
2008-02-28 11:00:00	MSFT	Stock	28.19	28.2	27.97	28.01	10453863.0
2008-02-28 12:00:00	MSFT	Stock	28.003	28.07	27.93	28.0	4825459.0
2008-02-28 13:00:00	MSFT	Stock	28.0	28.05	27.94	28.02	7344173.0
2008-02-28 14:00:00	MSFT	Stock	28.03	28.07	27.9	27.91	11937826.0
2008-02-28 15:00:00	MSFT	Stock	27.905	27.95	27.8	27.92	20375872.0
2008-02-28 16:00:00	MSFT	Stock	27.91	28.007	27.7	27.96	4519537.0
2008-02-28 17:00:00	MSFT	Stock	27.82	27.95	27.82	27.95	61133.0
2008-02-28 18:00:00	MSFT	Stock	27.9	27.92	27.86	27.92	6350.0
2008-02-28 19:00:00	MSFT	Stock	27.92	27.93	27.85	27.9	5460.0
2008-02-28 08:00:00	NVDA	Stock	0.5725	0.5725	0.5678	0.5678	88000.0
2008-02-28 09:00:00	NVDA	Stock	0.5688	0.5688	0.5582	0.5607	58851440.0
2008-02-28 10:00:00	NVDA	Stock	0.5605	0.5638	0.5565	0.5575	84750440.0
2008-02-28 11:00:00	NVDA	Stock	0.5578	0.5585	0.553	0.5548	58687520.0
2008-02-28 12:00:00	NVDA	Stock	0.5545	0.5552	0.5515	0.5515	39312120.0
2008-02-28 13:00:00	NVDA	Stock	0.5515	0.5542	0.5502	0.5525	45489120.0
2008-02-28 14:00:00	NVDA	Stock	0.5525	0.5558	0.5505	0.5558	60650760.0
2008-02-28 15:00:00	NVDA	Stock	0.5558	0.5562	0.5498	0.5508	85354240.0
2008-02-28 16:00:00	NVDA	Stock	0.5498	0.5558	0.5465	0.5498	57357680.0
2008-02-28 17:00:00	NVDA	Stock	0.5498	0.551	0.5488	0.5488	116000.0
2008-02-28 18:00:00	NVDA	Stock	0.5498	0.5512	0.5498	0.55	52000.0
2008-02-28 19:00:00	NVDA	Stock	0.55	0.551	0.5475	0.548	106000.0
2008-02-28 08:00:00	AMZN	Stock	3.545	3.545	3.515	3.515	50000.0
2008-02-28 09:00:00	AMZN	Stock	3.5175	3.53	3.463	3.4885	29771740.0
2008-02-28 10:00:00	AMZN	Stock	3.489	3.494	3.395	3.418	56659440.0
2008-02-28 11:00:00	AMZN	Stock	3.418	3.429	3.3555	3.399	55651840.0
2008-02-28 12:00:00	AMZN	Stock	3.4	3.439	3.3905	3.428	31653660.0
2008-02-28 13:00:00	AMZN	Stock	3.428	3.444	3.405	3.4255	23451540.0
2008-02-28 14:00:00	AMZN	Stock	3.4255	3.455	3.417	3.437	23048500.0
2008-02-28 15:00:00	AMZN	Stock	3.4375	3.4375	3.3845	3.399	36503420.0
2008-02-28 16:00:00	AMZN	Stock	3.392	3.4306	3.39	3.3975	1863160.0
2008-02-28 17:00:00	AMZN	Stock	3.3915	3.3995	3.39	3.391	40480.0

> showing 50 of 39,564 rows — these rows as CSV

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