PREVIEW / stock_1hour / 2009-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-08.parquet
  size:    842 KB
  rows:    41,344
  symbols: 3,356

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
2009-06-08 04:00:00	AAPL	Stock	5.1429	5.1429	5.1429	5.1429	19600.0
2009-06-08 05:00:00	AAPL	Stock	5.1114	5.1114	5.1114	5.1114	28000.0
2009-06-08 06:00:00	AAPL	Stock	5.1368	5.1368	5.1368	5.1368	8400.0
2009-06-08 07:00:00	AAPL	Stock	5.1311	5.1311	5.1118	5.1271	334936.0
2009-06-08 08:00:00	AAPL	Stock	5.125	5.1368	5.1021	5.1136	1767332.0
2009-06-08 09:00:00	AAPL	Stock	5.1125	5.1507	5.0407	5.0507	100216312.0
2009-06-08 10:00:00	AAPL	Stock	5.0507	5.0671	5.0382	5.0557	79150120.0
2009-06-08 11:00:00	AAPL	Stock	5.0546	5.0764	5.0464	5.0486	54259744.0
2009-06-08 12:00:00	AAPL	Stock	5.0486	5.0589	5.0296	5.0304	58515576.0
2009-06-08 13:00:00	AAPL	Stock	5.0314	5.0518	4.9796	5.0258	164619308.0
2009-06-08 14:00:00	AAPL	Stock	5.0264	5.0518	5.0086	5.0361	113117760.0
2009-06-08 15:00:00	AAPL	Stock	5.0357	5.1511	5.0225	5.1332	334874036.0
2009-06-08 16:00:00	AAPL	Stock	5.1425	5.1446	5.0495	5.1386	17135944.0
2009-06-08 17:00:00	AAPL	Stock	5.1386	5.1536	5.047	5.1446	1625736.0
2009-06-08 18:00:00	AAPL	Stock	5.1439	5.1532	5.1375	5.1475	1189776.0
2009-06-08 19:00:00	AAPL	Stock	5.1429	5.1432	5.1375	5.1411	291956.0
2009-06-08 04:00:00	MSFT	Stock	21.95	21.95	21.95	21.95	100.0
2009-06-08 07:00:00	MSFT	Stock	21.76	21.9	21.76	21.9	200.0
2009-06-08 08:00:00	MSFT	Stock	21.95	21.95	21.91	21.93	8091.0
2009-06-08 09:00:00	MSFT	Stock	21.93	22.0	21.68	21.69	7327948.0
2009-06-08 10:00:00	MSFT	Stock	21.69	21.78	21.63	21.7	6207389.0
2009-06-08 11:00:00	MSFT	Stock	21.698	21.76	21.63	21.7	4894005.0
2009-06-08 12:00:00	MSFT	Stock	21.7	21.74	21.65	21.71	2210505.0
2009-06-08 13:00:00	MSFT	Stock	21.72	21.8	21.7	21.77	2229707.0
2009-06-08 14:00:00	MSFT	Stock	21.78	21.87	21.73	21.852	5056774.0
2009-06-08 15:00:00	MSFT	Stock	21.85	22.32	21.83	22.06	17213994.0
2009-06-08 16:00:00	MSFT	Stock	22.05	22.123	21.691	22.05	2199256.0
2009-06-08 17:00:00	MSFT	Stock	22.12	22.19	22.08	22.08	2595.0
2009-06-08 18:00:00	MSFT	Stock	22.05	22.17	22.02	22.11	14494.0
2009-06-08 19:00:00	MSFT	Stock	22.06	22.13	22.06	22.13	2859.0
2009-06-08 08:00:00	NVDA	Stock	0.27	0.27	0.265	0.2663	234160.0
2009-06-08 09:00:00	NVDA	Stock	0.2663	0.2725	0.2645	0.2665	61391600.0
2009-06-08 10:00:00	NVDA	Stock	0.2665	0.2665	0.2625	0.265	93322840.0
2009-06-08 11:00:00	NVDA	Stock	0.265	0.2658	0.2625	0.2632	44196320.0
2009-06-08 12:00:00	NVDA	Stock	0.2632	0.2663	0.2632	0.265	35115360.0
2009-06-08 13:00:00	NVDA	Stock	0.2648	0.268	0.2648	0.2665	35529400.0
2009-06-08 14:00:00	NVDA	Stock	0.2663	0.2678	0.2658	0.2675	39554160.0
2009-06-08 15:00:00	NVDA	Stock	0.2675	0.273	0.267	0.2692	149195960.0
2009-06-08 16:00:00	NVDA	Stock	0.269	0.2718	0.2665	0.2695	6222960.0
2009-06-08 17:00:00	NVDA	Stock	0.2698	0.2698	0.2698	0.2698	12000.0
2009-06-08 18:00:00	NVDA	Stock	0.2698	0.2718	0.2698	0.2698	193000.0
2009-06-08 19:00:00	NVDA	Stock	0.2688	0.2688	0.2688	0.2688	180000.0
2009-06-08 07:00:00	AMZN	Stock	4.34	4.34	4.34	4.34	4000.0
2009-06-08 08:00:00	AMZN	Stock	4.348	4.352	4.325	4.3405	123120.0
2009-06-08 09:00:00	AMZN	Stock	4.3325	4.353	4.2785	4.285	15832600.0
2009-06-08 10:00:00	AMZN	Stock	4.2825	4.3125	4.256	4.283	20603920.0
2009-06-08 11:00:00	AMZN	Stock	4.2835	4.298	4.2605	4.2725	13357460.0
2009-06-08 12:00:00	AMZN	Stock	4.272	4.2785	4.2555	4.27	8013840.0
2009-06-08 13:00:00	AMZN	Stock	4.27	4.304	4.2645	4.293	8217420.0
2009-06-08 14:00:00	AMZN	Stock	4.292	4.2965	4.263	4.2935	10225780.0

> showing 50 of 41,344 rows — these rows as CSV

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