PREVIEW / stock_30min / 2007-10-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-17.parquet
  size:    1.2 MB
  rows:    68,185
  symbols: 3,160

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-10-17 04:00:00	AAPL	Stock	6.0729	6.1375	6.0729	6.1375	5600.0
2007-10-17 04:30:00	AAPL	Stock	6.1218	6.1218	6.1218	6.1218	8400.0
2007-10-17 06:30:00	AAPL	Stock	6.1143	6.1143	6.1143	6.1143	12600.0
2007-10-17 07:00:00	AAPL	Stock	6.1071	6.1607	6.1071	6.1607	293916.0
2007-10-17 07:30:00	AAPL	Stock	6.1686	6.1964	6.1589	6.1779	1702568.0
2007-10-17 08:00:00	AAPL	Stock	6.1739	6.1964	6.1304	6.1571	5486572.0
2007-10-17 08:30:00	AAPL	Stock	6.1568	6.1704	6.1411	6.1554	5151720.0
2007-10-17 09:00:00	AAPL	Stock	6.155	6.17	6.1475	6.1675	4321072.0
2007-10-17 09:30:00	AAPL	Stock	6.1675	6.18	6.125	6.1328	144733428.0
2007-10-17 10:00:00	AAPL	Stock	6.1336	6.1479	6.1196	6.135	79373784.0
2007-10-17 10:30:00	AAPL	Stock	6.1339	6.1411	6.0946	6.1225	84490784.0
2007-10-17 11:00:00	AAPL	Stock	6.1229	6.135	6.1143	6.1243	59508596.0
2007-10-17 11:30:00	AAPL	Stock	6.1254	6.1568	6.1246	6.1554	63550088.0
2007-10-17 12:00:00	AAPL	Stock	6.155	6.1579	6.125	6.1254	47212452.0
2007-10-17 12:30:00	AAPL	Stock	6.1254	6.1339	6.1071	6.1093	61355308.0
2007-10-17 13:00:00	AAPL	Stock	6.1092	6.1196	6.0761	6.0893	85127168.0
2007-10-17 13:30:00	AAPL	Stock	6.0893	6.1207	6.0582	6.0688	84189728.0
2007-10-17 14:00:00	AAPL	Stock	6.0686	6.0882	6.0421	6.0714	97665680.0
2007-10-17 14:30:00	AAPL	Stock	6.0711	6.1154	6.0554	6.1045	71536108.0
2007-10-17 15:00:00	AAPL	Stock	6.1061	6.1268	6.0996	6.1211	79578744.0
2007-10-17 15:30:00	AAPL	Stock	6.1211	6.1696	6.115	6.1696	120061144.0
2007-10-17 16:00:00	AAPL	Stock	6.1682	6.1964	6.1156	6.1739	21222292.0
2007-10-17 16:30:00	AAPL	Stock	6.175	6.1782	6.119	6.1454	2973516.0
2007-10-17 17:00:00	AAPL	Stock	6.1457	6.1571	6.1059	6.1464	1697192.0
2007-10-17 17:30:00	AAPL	Stock	6.1221	6.1518	6.1221	6.1404	5557664.0
2007-10-17 18:00:00	AAPL	Stock	6.1411	6.15	6.1411	6.1471	142380.0
2007-10-17 18:30:00	AAPL	Stock	6.15	6.1546	6.1471	6.15	228452.0
2007-10-17 19:00:00	AAPL	Stock	6.1518	6.1536	6.15	6.1518	95760.0
2007-10-17 19:30:00	AAPL	Stock	6.1518	6.1607	6.1421	6.1446	329420.0
2007-10-17 07:30:00	MSFT	Stock	30.68	30.82	30.68	30.8	14600.0
2007-10-17 08:00:00	MSFT	Stock	30.81	30.84	30.8	30.8	33370.0
2007-10-17 08:30:00	MSFT	Stock	30.83	30.83	30.75	30.78	16646.0
2007-10-17 09:00:00	MSFT	Stock	30.78	30.8	30.31	30.75	1069866.0
2007-10-17 09:30:00	MSFT	Stock	30.75	30.98	30.74	30.89	8026183.0
2007-10-17 10:00:00	MSFT	Stock	30.89	30.96	30.852	30.931	4386857.0
2007-10-17 10:30:00	MSFT	Stock	30.94	31.0	30.92	30.985	6908976.0
2007-10-17 11:00:00	MSFT	Stock	30.99	31.17	30.98	31.13	10889549.0
2007-10-17 11:30:00	MSFT	Stock	31.13	31.23	31.07	31.21	5575025.0
2007-10-17 12:00:00	MSFT	Stock	31.21	31.211	31.045	31.081	5210108.0
2007-10-17 12:30:00	MSFT	Stock	31.08	31.1	30.94	30.94	5761597.0
2007-10-17 13:00:00	MSFT	Stock	30.95	31.0	30.75	30.78	6346309.0
2007-10-17 13:30:00	MSFT	Stock	30.78	30.96	30.65	30.71	4928746.0
2007-10-17 14:00:00	MSFT	Stock	30.7	30.87	30.67	30.74	3892752.0
2007-10-17 14:30:00	MSFT	Stock	30.75	31.025	30.7	30.82	3670411.0
2007-10-17 15:00:00	MSFT	Stock	30.82	31.0	30.8	30.99	5848435.0
2007-10-17 15:30:00	MSFT	Stock	30.99	31.09	30.96	31.08	9522567.0
2007-10-17 16:00:00	MSFT	Stock	31.06	31.16	30.942	31.14	2398552.0
2007-10-17 16:30:00	MSFT	Stock	31.12	31.15	30.964	31.12	649959.0
2007-10-17 17:00:00	MSFT	Stock	31.15	31.15	30.899	31.06	887711.0
2007-10-17 17:30:00	MSFT	Stock	30.755	31.08	30.755	31.08	67750.0

> showing 50 of 68,185 rows — these rows as CSV

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