PREVIEW / stock_30min / 2007-01-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-09.parquet
  size:    979 KB
  rows:    52,782
  symbols: 2,492

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-01-09 04:00:00	AAPL	Stock	3.0714	3.0714	3.0714	3.0714	25200.0
2007-01-09 04:30:00	AAPL	Stock	3.0786	3.0786	3.0786	3.0786	5600.0
2007-01-09 05:00:00	AAPL	Stock	3.0782	3.0786	3.0782	3.0786	28000.0
2007-01-09 05:30:00	AAPL	Stock	3.0818	3.0818	3.0818	3.0818	2800.0
2007-01-09 06:00:00	AAPL	Stock	3.0818	3.0818	3.0818	3.0818	8400.0
2007-01-09 07:00:00	AAPL	Stock	3.0854	3.0946	3.0736	3.0821	1092924.0
2007-01-09 07:30:00	AAPL	Stock	3.0818	3.0893	3.0818	3.0857	1635480.0
2007-01-09 08:00:00	AAPL	Stock	3.0857	3.0893	3.0782	3.0857	4112416.0
2007-01-09 08:30:00	AAPL	Stock	3.0839	3.0857	3.0796	3.0839	1244152.0
2007-01-09 09:00:00	AAPL	Stock	3.0829	3.0893	3.0771	3.0889	8444296.0
2007-01-09 09:30:00	AAPL	Stock	3.0875	3.0968	3.0732	3.0879	138437040.0
2007-01-09 10:00:00	AAPL	Stock	3.0867	3.1068	3.0821	3.1043	119149884.0
2007-01-09 10:30:00	AAPL	Stock	3.1046	3.1271	3.1011	3.1132	138399044.0
2007-01-09 11:00:00	AAPL	Stock	3.1136	3.1321	3.1082	3.1318	113328012.0
2007-01-09 11:30:00	AAPL	Stock	3.1318	3.1382	3.1093	3.1193	144348148.0
2007-01-09 12:00:00	AAPL	Stock	3.1196	3.1425	3.0411	3.0639	326959528.0
2007-01-09 12:30:00	AAPL	Stock	3.0639	3.1607	3.0471	3.1314	403362204.0
2007-01-09 13:00:00	AAPL	Stock	3.1311	3.2279	3.125	3.2186	396681376.0
2007-01-09 13:30:00	AAPL	Stock	3.2182	3.3125	3.2171	3.2468	514743068.0
2007-01-09 14:00:00	AAPL	Stock	3.2471	3.275	3.2357	3.2593	252259784.0
2007-01-09 14:30:00	AAPL	Stock	3.2596	3.2893	3.2496	3.2768	194753132.0
2007-01-09 15:00:00	AAPL	Stock	3.2768	3.2964	3.2761	3.2854	218118852.0
2007-01-09 15:30:00	AAPL	Stock	3.2854	3.3207	3.285	3.3054	346066616.0
2007-01-09 16:00:00	AAPL	Stock	3.3054	3.3104	3.3018	3.3064	6569920.0
2007-01-09 16:30:00	AAPL	Stock	3.3064	3.3121	3.3054	3.3096	4511220.0
2007-01-09 17:00:00	AAPL	Stock	3.3096	3.3125	3.3043	3.3104	2224796.0
2007-01-09 17:30:00	AAPL	Stock	3.3107	3.3111	3.3036	3.3071	1533504.0
2007-01-09 18:00:00	AAPL	Stock	3.3071	3.3093	3.3046	3.3086	1154412.0
2007-01-09 18:30:00	AAPL	Stock	3.3082	3.3082	3.3057	3.3071	1510432.0
2007-01-09 19:00:00	AAPL	Stock	3.3068	3.3107	3.3061	3.3107	664300.0
2007-01-09 19:30:00	AAPL	Stock	3.3114	3.3143	3.3093	3.3129	875784.0
2007-01-09 08:00:00	MSFT	Stock	29.95	29.95	29.93	29.93	5287.0
2007-01-09 08:30:00	MSFT	Stock	29.91	29.97	29.91	29.94	14899.0
2007-01-09 09:00:00	MSFT	Stock	29.96	30.0	29.91	30.0	50306.0
2007-01-09 09:30:00	MSFT	Stock	30.0	30.09	29.9	29.96	5181922.0
2007-01-09 10:00:00	MSFT	Stock	29.96	30.15	29.95	30.09	3989954.0
2007-01-09 10:30:00	MSFT	Stock	30.1	30.18	29.98	30.11	3343228.0
2007-01-09 11:00:00	MSFT	Stock	30.12	30.14	29.93	29.953	3806256.0
2007-01-09 11:30:00	MSFT	Stock	29.95	30.01	29.88	29.9	3082461.0
2007-01-09 12:00:00	MSFT	Stock	29.9	29.92	29.79	29.84	3093126.0
2007-01-09 12:30:00	MSFT	Stock	29.85	29.86	29.73	29.79	4150757.0
2007-01-09 13:00:00	MSFT	Stock	29.79	29.872	29.76	29.83	1761024.0
2007-01-09 13:30:00	MSFT	Stock	29.83	29.92	29.82	29.889	1877343.0
2007-01-09 14:00:00	MSFT	Stock	29.89	29.972	29.83	29.9	2208635.0
2007-01-09 14:30:00	MSFT	Stock	29.91	29.95	29.77	29.93	1785755.0
2007-01-09 15:00:00	MSFT	Stock	29.93	29.99	29.84	29.97	3024927.0
2007-01-09 15:30:00	MSFT	Stock	29.98	30.07	29.89	29.96	5151528.0
2007-01-09 16:00:00	MSFT	Stock	29.96	30.038	29.77	29.9	128647.0
2007-01-09 16:30:00	MSFT	Stock	29.92	29.96	29.92	29.96	540.0
2007-01-09 17:00:00	MSFT	Stock	29.91	29.91	29.91	29.91	950.0

> showing 50 of 52,782 rows — these rows as CSV

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