PREVIEW / stock_30min / 2007-10-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-24.parquet
  size:    1.2 MB
  rows:    67,934
  symbols: 3,164

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-24 05:00:00	AAPL	Stock	6.5821	6.5821	6.5821	6.5821	14000.0
2007-10-24 05:30:00	AAPL	Stock	6.5982	6.5982	6.5954	6.5982	42000.0
2007-10-24 06:00:00	AAPL	Stock	6.5982	6.5982	6.5961	6.5964	94864.0
2007-10-24 06:30:00	AAPL	Stock	6.5825	6.5964	6.5825	6.5854	75376.0
2007-10-24 07:00:00	AAPL	Stock	6.6018	6.6018	6.5721	6.5768	182616.0
2007-10-24 07:30:00	AAPL	Stock	6.5807	6.5907	6.5721	6.5857	209776.0
2007-10-24 08:00:00	AAPL	Stock	6.5893	6.6486	6.5714	6.6486	2408196.0
2007-10-24 08:30:00	AAPL	Stock	6.5893	6.6143	6.5714	6.6125	2429868.0
2007-10-24 09:00:00	AAPL	Stock	6.6129	6.6471	6.6129	6.6357	7697340.0
2007-10-24 09:30:00	AAPL	Stock	6.6357	6.6861	6.5914	6.6575	151624536.0
2007-10-24 10:00:00	AAPL	Stock	6.6575	6.6589	6.5929	6.625	101124324.0
2007-10-24 10:30:00	AAPL	Stock	6.625	6.6254	6.5014	6.5425	132920144.0
2007-10-24 11:00:00	AAPL	Stock	6.5429	6.5436	6.4014	6.4693	155265544.0
2007-10-24 11:30:00	AAPL	Stock	6.4696	6.5436	6.4625	6.5304	92306704.0
2007-10-24 12:00:00	AAPL	Stock	6.5307	6.5675	6.5179	6.5546	64035048.0
2007-10-24 12:30:00	AAPL	Stock	6.5568	6.5779	6.5093	6.5314	57373344.0
2007-10-24 13:00:00	AAPL	Stock	6.5314	6.5371	6.4932	6.5154	42247240.0
2007-10-24 13:30:00	AAPL	Stock	6.515	6.5264	6.4718	6.4939	50212680.0
2007-10-24 14:00:00	AAPL	Stock	6.4929	6.5429	6.4396	6.5268	82050836.0
2007-10-24 14:30:00	AAPL	Stock	6.5279	6.5664	6.4679	6.5589	89476268.0
2007-10-24 15:00:00	AAPL	Stock	6.5586	6.6429	6.5468	6.6414	126130172.0
2007-10-24 15:30:00	AAPL	Stock	6.6418	6.6511	6.5996	6.6393	110403776.0
2007-10-24 16:00:00	AAPL	Stock	6.6393	6.6511	6.5023	6.65	14491680.0
2007-10-24 16:30:00	AAPL	Stock	6.6507	6.6571	6.5362	6.6568	2237228.0
2007-10-24 17:00:00	AAPL	Stock	6.6554	6.6571	6.6404	6.6446	913780.0
2007-10-24 17:30:00	AAPL	Stock	6.6454	6.6504	6.6425	6.6461	1057392.0
2007-10-24 18:00:00	AAPL	Stock	6.6464	6.6482	6.6286	6.6339	468916.0
2007-10-24 18:30:00	AAPL	Stock	6.6354	6.6393	6.6286	6.6393	478128.0
2007-10-24 19:00:00	AAPL	Stock	6.6386	6.6393	6.6296	6.6304	265272.0
2007-10-24 19:30:00	AAPL	Stock	6.6339	6.6339	6.625	6.6254	267848.0
2007-10-24 07:30:00	MSFT	Stock	30.75	30.82	30.75	30.82	4000.0
2007-10-24 08:00:00	MSFT	Stock	30.85	30.92	30.82	30.84	46505.0
2007-10-24 08:30:00	MSFT	Stock	30.82	30.85	30.81	30.83	7100.0
2007-10-24 09:00:00	MSFT	Stock	30.83	30.87	30.81	30.85	14886.0
2007-10-24 09:30:00	MSFT	Stock	30.85	31.15	30.81	31.15	6838188.0
2007-10-24 10:00:00	MSFT	Stock	31.15	31.2	31.01	31.13	5786960.0
2007-10-24 10:30:00	MSFT	Stock	31.127	31.14	30.82	30.9	6035426.0
2007-10-24 11:00:00	MSFT	Stock	30.899	30.93	30.5	30.73	7343605.0
2007-10-24 11:30:00	MSFT	Stock	30.73	30.87	30.67	30.72	4865800.0
2007-10-24 12:00:00	MSFT	Stock	30.725	30.9	30.64	30.73	4234204.0
2007-10-24 12:30:00	MSFT	Stock	30.73	30.9	30.71	30.83	2998614.0
2007-10-24 13:00:00	MSFT	Stock	30.82	30.9	30.8	30.88	2451668.0
2007-10-24 13:30:00	MSFT	Stock	30.88	30.89	30.75	30.79	3001451.0
2007-10-24 14:00:00	MSFT	Stock	30.78	30.87	30.69	30.82	4310444.0
2007-10-24 14:30:00	MSFT	Stock	30.82	30.95	30.72	30.93	6804888.0
2007-10-24 15:00:00	MSFT	Stock	30.92	31.24	30.86	31.23	7745599.0
2007-10-24 15:30:00	MSFT	Stock	31.23	31.3	31.1	31.28	10700734.0
2007-10-24 16:00:00	MSFT	Stock	31.28	31.55	30.744	31.41	3357426.0
2007-10-24 16:30:00	MSFT	Stock	31.45	31.46	30.9	31.45	1324926.0
2007-10-24 17:00:00	MSFT	Stock	31.44	31.5	31.25	31.5	114569.0

> showing 50 of 67,934 rows — these rows as CSV

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