PREVIEW / stock_30min / 2007-10-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-18.parquet
  size:    1.2 MB
  rows:    69,142
  symbols: 3,124

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-18 06:30:00	AAPL	Stock	6.1539	6.1539	6.1539	6.1539	8400.0
2007-10-18 07:00:00	AAPL	Stock	6.1661	6.1875	6.1254	6.1254	110600.0
2007-10-18 07:30:00	AAPL	Stock	6.1296	6.1336	6.1232	6.1232	52500.0
2007-10-18 08:00:00	AAPL	Stock	6.1304	6.1339	6.0957	6.1129	1566068.0
2007-10-18 08:30:00	AAPL	Stock	6.1146	6.1304	6.1021	6.1286	1382472.0
2007-10-18 09:00:00	AAPL	Stock	6.1286	6.1368	6.1161	6.1243	1731744.0
2007-10-18 09:30:00	AAPL	Stock	6.1239	6.1539	6.1089	6.1364	123909968.0
2007-10-18 10:00:00	AAPL	Stock	6.1361	6.1675	6.1146	6.165	83650616.0
2007-10-18 10:30:00	AAPL	Stock	6.1657	6.1661	6.1464	6.1543	44658068.0
2007-10-18 11:00:00	AAPL	Stock	6.1541	6.1625	6.1393	6.1471	52902444.0
2007-10-18 11:30:00	AAPL	Stock	6.1471	6.1557	6.1429	6.1518	28946456.0
2007-10-18 12:00:00	AAPL	Stock	6.1518	6.1568	6.1468	6.1487	28613984.0
2007-10-18 12:30:00	AAPL	Stock	6.1489	6.15	6.1418	6.1489	30379692.0
2007-10-18 13:00:00	AAPL	Stock	6.1493	6.1532	6.1379	6.1514	29343888.0
2007-10-18 13:30:00	AAPL	Stock	6.1518	6.2029	6.1511	6.1971	77337148.0
2007-10-18 14:00:00	AAPL	Stock	6.1971	6.2175	6.1952	6.2066	81436180.0
2007-10-18 14:30:00	AAPL	Stock	6.2061	6.2204	6.1918	6.1975	61956328.0
2007-10-18 15:00:00	AAPL	Stock	6.1979	6.2211	6.1696	6.2107	61807704.0
2007-10-18 15:30:00	AAPL	Stock	6.2104	6.2196	6.1832	6.1964	84220976.0
2007-10-18 16:00:00	AAPL	Stock	6.1964	6.2139	6.1693	6.1982	18299652.0
2007-10-18 16:30:00	AAPL	Stock	6.1982	6.1982	6.1696	6.1868	6750324.0
2007-10-18 17:00:00	AAPL	Stock	6.1868	6.2104	6.1728	6.21	3736012.0
2007-10-18 17:30:00	AAPL	Stock	6.2076	6.2143	6.1664	6.1664	798084.0
2007-10-18 18:00:00	AAPL	Stock	6.2061	6.2143	6.2054	6.2143	428708.0
2007-10-18 18:30:00	AAPL	Stock	6.2143	6.2196	6.1986	6.2057	607936.0
2007-10-18 19:00:00	AAPL	Stock	6.2107	6.2107	6.2004	6.2089	171500.0
2007-10-18 19:30:00	AAPL	Stock	6.2089	6.2129	6.2018	6.2107	185696.0
2007-10-18 08:00:00	MSFT	Stock	31.04	31.04	30.75	30.78	5333.0
2007-10-18 08:30:00	MSFT	Stock	30.8	31.08	30.8	30.89	855065.0
2007-10-18 09:00:00	MSFT	Stock	30.9	31.22	30.85	31.22	33066.0
2007-10-18 09:30:00	MSFT	Stock	31.22	31.23	30.91	30.93	5649306.0
2007-10-18 10:00:00	MSFT	Stock	30.92	31.03	30.81	30.97	3488049.0
2007-10-18 10:30:00	MSFT	Stock	30.979	30.98	30.82	30.825	2814022.0
2007-10-18 11:00:00	MSFT	Stock	30.825	30.83	30.63	30.72	3533621.0
2007-10-18 11:30:00	MSFT	Stock	30.72	30.93	30.7	30.89	4064418.0
2007-10-18 12:00:00	MSFT	Stock	30.89	31.01	30.84	31.0	4147991.0
2007-10-18 12:30:00	MSFT	Stock	31.0	31.09	30.98	30.98	2739563.0
2007-10-18 13:00:00	MSFT	Stock	30.981	30.99	30.9	30.95	1856742.0
2007-10-18 13:30:00	MSFT	Stock	30.95	31.11	30.95	31.09	2587866.0
2007-10-18 14:00:00	MSFT	Stock	31.09	31.19	31.02	31.02	2682591.0
2007-10-18 14:30:00	MSFT	Stock	31.03	31.08	30.97	31.06	3145835.0
2007-10-18 15:00:00	MSFT	Stock	31.07	31.16	31.04	31.11	3004892.0
2007-10-18 15:30:00	MSFT	Stock	31.11	31.2	31.09	31.14	5305113.0
2007-10-18 16:00:00	MSFT	Stock	31.14	31.2	30.94	30.989	1448032.0
2007-10-18 16:30:00	MSFT	Stock	30.985	31.19	30.9	31.05	1040363.0
2007-10-18 17:00:00	MSFT	Stock	31.16	31.16	30.985	31.12	952100.0
2007-10-18 17:30:00	MSFT	Stock	31.12	31.18	30.995	30.995	15850.0
2007-10-18 18:00:00	MSFT	Stock	30.995	31.16	30.985	31.16	1500.0
2007-10-18 18:30:00	MSFT	Stock	31.11	31.11	31.11	31.11	100.0
2007-10-18 19:00:00	MSFT	Stock	31.12	35.2	31.12	31.2	4122.0

> showing 50 of 69,142 rows — these rows as CSV

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