PREVIEW / stock_30min / 2007-10-10

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-10.parquet
  size:    1.2 MB
  rows:    66,676
  symbols: 3,146

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-10 05:00:00	AAPL	Stock	5.985	5.985	5.985	5.985	14000.0
2007-10-10 07:00:00	AAPL	Stock	5.9946	5.9946	5.9679	5.9689	156800.0
2007-10-10 07:30:00	AAPL	Stock	5.9768	5.9818	5.9768	5.9818	8400.0
2007-10-10 08:00:00	AAPL	Stock	5.9768	5.9946	5.9696	5.9843	965524.0
2007-10-10 08:30:00	AAPL	Stock	5.9846	6.0104	5.9804	5.9964	1992312.0
2007-10-10 09:00:00	AAPL	Stock	5.9964	6.0071	5.9832	5.9889	1132320.0
2007-10-10 09:30:00	AAPL	Stock	5.985	5.9957	5.92	5.9343	109174240.0
2007-10-10 10:00:00	AAPL	Stock	5.9339	5.9511	5.9143	5.9354	65770516.0
2007-10-10 10:30:00	AAPL	Stock	5.9354	5.9521	5.9325	5.9425	42374668.0
2007-10-10 11:00:00	AAPL	Stock	5.9425	5.9792	5.94	5.9668	63657328.0
2007-10-10 11:30:00	AAPL	Stock	5.9671	5.9754	5.9375	5.9486	47749744.0
2007-10-10 12:00:00	AAPL	Stock	5.9486	5.9582	5.9286	5.9386	38765972.0
2007-10-10 12:30:00	AAPL	Stock	5.9389	5.9657	5.9387	5.9579	28733712.0
2007-10-10 13:00:00	AAPL	Stock	5.9578	5.9586	5.9286	5.93	35628768.0
2007-10-10 13:30:00	AAPL	Stock	5.9306	5.9464	5.9296	5.9414	26549572.0
2007-10-10 14:00:00	AAPL	Stock	5.9414	5.9525	5.9321	5.9514	37307900.0
2007-10-10 14:30:00	AAPL	Stock	5.9514	5.9671	5.9375	5.9607	51029636.0
2007-10-10 15:00:00	AAPL	Stock	5.9611	5.9739	5.9582	5.9614	44901640.0
2007-10-10 15:30:00	AAPL	Stock	5.9607	5.9675	5.95	5.955	55337436.0
2007-10-10 16:00:00	AAPL	Stock	5.9539	5.9568	5.9386	5.9507	13795348.0
2007-10-10 16:30:00	AAPL	Stock	5.9504	5.9568	5.9411	5.9411	394352.0
2007-10-10 17:00:00	AAPL	Stock	5.9429	5.9568	5.9418	5.9464	328860.0
2007-10-10 17:30:00	AAPL	Stock	5.9468	5.95	5.9454	5.9489	204708.0
2007-10-10 18:00:00	AAPL	Stock	5.9518	5.9643	5.9464	5.9571	1257368.0
2007-10-10 18:30:00	AAPL	Stock	5.9521	5.9571	5.9518	5.9571	66808.0
2007-10-10 19:00:00	AAPL	Stock	5.9571	5.9571	5.9521	5.9564	60536.0
2007-10-10 19:30:00	AAPL	Stock	5.9564	5.9596	5.9464	5.9596	250348.0
2007-10-10 08:00:00	MSFT	Stock	30.08	30.12	30.08	30.12	4100.0
2007-10-10 08:30:00	MSFT	Stock	30.1	30.13	30.08	30.13	49784.0
2007-10-10 09:00:00	MSFT	Stock	30.13	30.15	30.0	30.15	101750.0
2007-10-10 09:30:00	MSFT	Stock	30.05	30.37	30.03	30.32	4304277.0
2007-10-10 10:00:00	MSFT	Stock	30.31	30.34	30.2	30.27	2734709.0
2007-10-10 10:30:00	MSFT	Stock	30.269	30.29	30.16	30.2	1766213.0
2007-10-10 11:00:00	MSFT	Stock	30.2	30.27	30.195	30.25	1486258.0
2007-10-10 11:30:00	MSFT	Stock	30.25	30.29	30.22	30.22	1581431.0
2007-10-10 12:00:00	MSFT	Stock	30.23	30.3	30.229	30.3	1576422.0
2007-10-10 12:30:00	MSFT	Stock	30.29	30.331	30.24	30.25	1539578.0
2007-10-10 13:00:00	MSFT	Stock	30.25	30.26	30.181	30.22	2267943.0
2007-10-10 13:30:00	MSFT	Stock	30.23	30.26	30.2	30.215	1937655.0
2007-10-10 14:00:00	MSFT	Stock	30.22	30.24	30.18	30.23	1460387.0
2007-10-10 14:30:00	MSFT	Stock	30.233	30.28	30.12	30.27	2842272.0
2007-10-10 15:00:00	MSFT	Stock	30.26	30.31	30.21	30.282	2605330.0
2007-10-10 15:30:00	MSFT	Stock	30.29	30.32	30.2	30.23	4427461.0
2007-10-10 16:00:00	MSFT	Stock	30.23	30.267	30.2	30.237	1474121.0
2007-10-10 16:30:00	MSFT	Stock	30.23	30.248	30.22	30.22	12835.0
2007-10-10 17:00:00	MSFT	Stock	30.23	30.23	30.2	30.23	60824.0
2007-10-10 17:30:00	MSFT	Stock	30.25	30.34	30.2	30.34	7863.0
2007-10-10 18:00:00	MSFT	Stock	30.28	30.29	30.23	30.23	10090.0
2007-10-10 18:30:00	MSFT	Stock	30.22	30.22	30.22	30.22	200.0
2007-10-10 19:00:00	MSFT	Stock	30.23	30.23	30.23	30.23	300.0

> showing 50 of 66,676 rows — these rows as CSV

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