PREVIEW / stock_1hour / 2009-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-10.parquet
  size:    870 KB
  rows:    41,736
  symbols: 3,381

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-09-10 05:00:00	AAPL	Stock	6.1429	6.1432	6.1429	6.1429	67200.0
2009-09-10 06:00:00	AAPL	Stock	6.1329	6.1429	6.1329	6.1429	42000.0
2009-09-10 07:00:00	AAPL	Stock	6.1339	6.145	6.0986	6.1436	435512.0
2009-09-10 08:00:00	AAPL	Stock	6.1393	6.1482	6.1286	6.1411	1928584.0
2009-09-10 09:00:00	AAPL	Stock	6.1439	6.1875	6.1221	6.1686	104300616.0
2009-09-10 10:00:00	AAPL	Stock	6.1693	6.1786	6.1018	6.1439	102697476.0
2009-09-10 11:00:00	AAPL	Stock	6.1449	6.155	6.1129	6.1189	56892584.0
2009-09-10 12:00:00	AAPL	Stock	6.1189	6.1304	6.1107	6.1218	22490776.0
2009-09-10 13:00:00	AAPL	Stock	6.1225	6.1636	6.1004	6.1607	55576388.0
2009-09-10 14:00:00	AAPL	Stock	6.1614	6.1671	6.1479	6.1518	42282800.0
2009-09-10 15:00:00	AAPL	Stock	6.1521	6.1786	6.1261	6.1646	84933016.0
2009-09-10 16:00:00	AAPL	Stock	6.1646	6.1714	6.143	6.1618	16072028.0
2009-09-10 17:00:00	AAPL	Stock	6.1657	6.1657	6.1593	6.1643	141400.0
2009-09-10 18:00:00	AAPL	Stock	6.1643	6.1707	6.1625	6.1625	462000.0
2009-09-10 19:00:00	AAPL	Stock	6.1625	6.1661	6.1571	6.1629	159208.0
2009-09-10 08:00:00	MSFT	Stock	24.78	24.84	24.78	24.83	7151.0
2009-09-10 09:00:00	MSFT	Stock	24.83	24.93	24.65	24.85	5541382.0
2009-09-10 10:00:00	MSFT	Stock	24.85	24.95	24.8	24.914	5600089.0
2009-09-10 11:00:00	MSFT	Stock	24.91	25.02	24.9	24.925	6126399.0
2009-09-10 12:00:00	MSFT	Stock	24.925	24.96	24.88	24.95	2867795.0
2009-09-10 13:00:00	MSFT	Stock	24.95	25.01	24.9	25.0	4292523.0
2009-09-10 14:00:00	MSFT	Stock	25.0	25.05	24.95	24.955	5010574.0
2009-09-10 15:00:00	MSFT	Stock	24.95	25.0	24.88	24.99	8129023.0
2009-09-10 16:00:00	MSFT	Stock	24.99	25.01	24.91	24.94	5365353.0
2009-09-10 17:00:00	MSFT	Stock	24.96	24.96	24.91	24.91	1616.0
2009-09-10 18:00:00	MSFT	Stock	24.94	24.94	24.92	24.92	600.0
2009-09-10 19:00:00	MSFT	Stock	24.91	24.95	24.88	24.88	2840.0
2009-09-10 08:00:00	NVDA	Stock	0.4125	0.4125	0.4025	0.4038	112000.0
2009-09-10 09:00:00	NVDA	Stock	0.403	0.403	0.3958	0.3973	67250040.0
2009-09-10 10:00:00	NVDA	Stock	0.3973	0.4015	0.3973	0.3994	61256880.0
2009-09-10 11:00:00	NVDA	Stock	0.3993	0.4022	0.3988	0.4005	52479280.0
2009-09-10 12:00:00	NVDA	Stock	0.4005	0.404	0.3993	0.4035	57179360.0
2009-09-10 13:00:00	NVDA	Stock	0.4035	0.4072	0.403	0.4072	62586160.0
2009-09-10 14:00:00	NVDA	Stock	0.4072	0.4085	0.4053	0.408	76584600.0
2009-09-10 15:00:00	NVDA	Stock	0.408	0.4122	0.4062	0.4118	195857480.0
2009-09-10 16:00:00	NVDA	Stock	0.4108	0.4118	0.4049	0.4108	12785160.0
2009-09-10 17:00:00	NVDA	Stock	0.4108	0.4108	0.4108	0.4108	12000.0
2009-09-10 18:00:00	NVDA	Stock	0.4112	0.4112	0.4112	0.4112	12000.0
2009-09-10 19:00:00	NVDA	Stock	0.4098	0.4098	0.4088	0.4088	36000.0
2009-09-10 09:00:00	AMZN	Stock	4.0945	4.1745	4.091	4.173	18390440.0
2009-09-10 10:00:00	AMZN	Stock	4.173	4.1935	4.129	4.1705	30302200.0
2009-09-10 11:00:00	AMZN	Stock	4.171	4.174	4.1355	4.1535	16876940.0
2009-09-10 12:00:00	AMZN	Stock	4.1545	4.1665	4.15	4.1502	8059140.0
2009-09-10 13:00:00	AMZN	Stock	4.15	4.1975	4.1405	4.193	16317100.0
2009-09-10 14:00:00	AMZN	Stock	4.1935	4.2035	4.169	4.1765	11519100.0
2009-09-10 15:00:00	AMZN	Stock	4.177	4.195	4.1595	4.192	26114280.0
2009-09-10 16:00:00	AMZN	Stock	4.188	4.1975	4.1649	4.195	9214980.0
2009-09-10 17:00:00	AMZN	Stock	4.1855	4.195	4.185	4.185	19000.0
2009-09-10 18:00:00	AMZN	Stock	4.1925	4.1925	4.1925	4.1925	123300.0
2009-09-10 19:00:00	AMZN	Stock	4.186	4.186	4.186	4.186	36980.0

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

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