PREVIEW / stock_30min / 2009-09-10

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-10.parquet
  size:    1.3 MB
  rows:    73,081
  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:30:00	AAPL	Stock	6.1429	6.1432	6.1429	6.1429	67200.0
2009-09-10 06:30:00	AAPL	Stock	6.1329	6.1429	6.1329	6.1429	42000.0
2009-09-10 07:00:00	AAPL	Stock	6.1339	6.1429	6.0986	6.0986	98000.0
2009-09-10 07:30:00	AAPL	Stock	6.1246	6.145	6.1196	6.1436	337512.0
2009-09-10 08:00:00	AAPL	Stock	6.1393	6.1454	6.1286	6.1325	837816.0
2009-09-10 08:30:00	AAPL	Stock	6.1354	6.1482	6.1339	6.1411	1090768.0
2009-09-10 09:00:00	AAPL	Stock	6.1439	6.1514	6.1375	6.1429	3157532.0
2009-09-10 09:30:00	AAPL	Stock	6.1446	6.1875	6.1221	6.1686	101143084.0
2009-09-10 10:00:00	AAPL	Stock	6.1693	6.1786	6.1018	6.1186	63040236.0
2009-09-10 10:30:00	AAPL	Stock	6.1185	6.1561	6.1086	6.1439	39657240.0
2009-09-10 11:00:00	AAPL	Stock	6.1449	6.155	6.1129	6.1225	34697320.0
2009-09-10 11:30:00	AAPL	Stock	6.1225	6.1364	6.1136	6.1189	22195264.0
2009-09-10 12:00:00	AAPL	Stock	6.1189	6.1239	6.1107	6.1206	11063276.0
2009-09-10 12:30:00	AAPL	Stock	6.12	6.1304	6.1139	6.1218	11427500.0
2009-09-10 13:00:00	AAPL	Stock	6.1225	6.1275	6.1004	6.1082	22667820.0
2009-09-10 13:30:00	AAPL	Stock	6.1093	6.1636	6.1071	6.1607	32908568.0
2009-09-10 14:00:00	AAPL	Stock	6.1614	6.1668	6.1486	6.1568	24052392.0
2009-09-10 14:30:00	AAPL	Stock	6.1579	6.1671	6.1479	6.1518	18230408.0
2009-09-10 15:00:00	AAPL	Stock	6.1521	6.155	6.1261	6.1436	29667512.0
2009-09-10 15:30:00	AAPL	Stock	6.1443	6.1786	6.1443	6.1646	55265504.0
2009-09-10 16:00:00	AAPL	Stock	6.1646	6.1714	6.143	6.1643	13348244.0
2009-09-10 16:30:00	AAPL	Stock	6.1643	6.1661	6.1618	6.1618	2723784.0
2009-09-10 17:00:00	AAPL	Stock	6.1657	6.1657	6.1593	6.1607	89152.0
2009-09-10 17:30:00	AAPL	Stock	6.1593	6.1657	6.1593	6.1643	52248.0
2009-09-10 18:00:00	AAPL	Stock	6.1643	6.1643	6.1629	6.1632	291760.0
2009-09-10 18:30:00	AAPL	Stock	6.1643	6.1707	6.1625	6.1625	170240.0
2009-09-10 19:00:00	AAPL	Stock	6.1625	6.1661	6.1625	6.1629	54992.0
2009-09-10 19:30:00	AAPL	Stock	6.1629	6.165	6.1571	6.1629	104216.0
2009-09-10 08:30:00	MSFT	Stock	24.78	24.84	24.78	24.83	7151.0
2009-09-10 09:00:00	MSFT	Stock	24.83	24.84	24.75	24.81	10300.0
2009-09-10 09:30:00	MSFT	Stock	24.8	24.93	24.65	24.85	5531082.0
2009-09-10 10:00:00	MSFT	Stock	24.85	24.95	24.8	24.89	3584241.0
2009-09-10 10:30:00	MSFT	Stock	24.89	24.95	24.85	24.914	2015848.0
2009-09-10 11:00:00	MSFT	Stock	24.91	24.98	24.9	24.942	2445569.0
2009-09-10 11:30:00	MSFT	Stock	24.94	25.02	24.91	24.925	3680830.0
2009-09-10 12:00:00	MSFT	Stock	24.925	24.96	24.89	24.94	1629733.0
2009-09-10 12:30:00	MSFT	Stock	24.93	24.96	24.88	24.95	1238062.0
2009-09-10 13:00:00	MSFT	Stock	24.95	24.99	24.92	24.94	2008251.0
2009-09-10 13:30:00	MSFT	Stock	24.93	25.01	24.9	25.0	2284272.0
2009-09-10 14:00:00	MSFT	Stock	25.0	25.05	24.995	25.01	3219869.0
2009-09-10 14:30:00	MSFT	Stock	25.013	25.03	24.95	24.955	1790705.0
2009-09-10 15:00:00	MSFT	Stock	24.95	24.96	24.88	24.94	2619795.0
2009-09-10 15:30:00	MSFT	Stock	24.94	25.0	24.93	24.99	5509228.0
2009-09-10 16:00:00	MSFT	Stock	24.99	25.01	24.91	25.0	4835127.0
2009-09-10 16:30:00	MSFT	Stock	24.95	25.0	24.94	24.94	530226.0
2009-09-10 17:00:00	MSFT	Stock	24.96	24.96	24.96	24.96	100.0
2009-09-10 17:30:00	MSFT	Stock	24.95	24.95	24.91	24.91	1516.0
2009-09-10 18:00:00	MSFT	Stock	24.94	24.94	24.92	24.92	600.0
2009-09-10 19:30: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.403	100000.0

> showing 50 of 73,081 rows — these rows as CSV

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