PREVIEW / stock_30min / 2008-06-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-06.parquet
  size:    1.3 MB
  rows:    69,225
  symbols: 3,290

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
2008-06-06 04:00:00	AAPL	Stock	6.7857	6.7857	6.7857	6.7857	5600.0
2008-06-06 06:30:00	AAPL	Stock	6.7657	6.7657	6.7654	6.7654	5600.0
2008-06-06 07:00:00	AAPL	Stock	6.7857	6.7929	6.7857	6.7857	50120.0
2008-06-06 07:30:00	AAPL	Stock	6.7857	6.7957	6.7664	6.7718	172480.0
2008-06-06 08:00:00	AAPL	Stock	6.7811	6.7964	6.7682	6.7911	2870476.0
2008-06-06 08:30:00	AAPL	Stock	6.7893	6.7929	6.7104	6.7236	8924272.0
2008-06-06 09:00:00	AAPL	Stock	6.7246	6.73	6.7	6.7129	3636668.0
2008-06-06 09:30:00	AAPL	Stock	6.7136	6.7839	6.6968	6.7771	132195168.0
2008-06-06 10:00:00	AAPL	Stock	6.7764	6.7768	6.7261	6.7443	79659328.0
2008-06-06 10:30:00	AAPL	Stock	6.7432	6.7434	6.7011	6.7236	68263468.0
2008-06-06 11:00:00	AAPL	Stock	6.7248	6.7288	6.645	6.6514	71675492.0
2008-06-06 11:30:00	AAPL	Stock	6.6507	6.7017	6.6429	6.6864	58516528.0
2008-06-06 12:00:00	AAPL	Stock	6.6861	6.7143	6.6721	6.6914	42062048.0
2008-06-06 12:30:00	AAPL	Stock	6.6929	6.735	6.6918	6.72	37412172.0
2008-06-06 13:00:00	AAPL	Stock	6.7196	6.7221	6.6768	6.7011	52937052.0
2008-06-06 13:30:00	AAPL	Stock	6.7004	6.7371	6.6932	6.7264	56698964.0
2008-06-06 14:00:00	AAPL	Stock	6.7264	6.7332	6.6604	6.6773	85037484.0
2008-06-06 14:30:00	AAPL	Stock	6.6777	6.6914	6.6429	6.6593	63182896.0
2008-06-06 15:00:00	AAPL	Stock	6.6593	6.7079	6.6579	6.6739	67530176.0
2008-06-06 15:30:00	AAPL	Stock	6.6736	6.6896	6.6268	6.6343	103078444.0
2008-06-06 16:00:00	AAPL	Stock	6.6343	6.7321	6.625	6.6371	18334764.0
2008-06-06 16:30:00	AAPL	Stock	6.6386	6.6429	6.63	6.6421	338464.0
2008-06-06 17:00:00	AAPL	Stock	6.6411	6.6411	6.6379	6.6411	319872.0
2008-06-06 17:30:00	AAPL	Stock	6.6429	6.6882	6.6418	6.6568	1117116.0
2008-06-06 18:00:00	AAPL	Stock	6.6571	6.6604	6.6518	6.6554	221956.0
2008-06-06 18:30:00	AAPL	Stock	6.6561	6.6661	6.65	6.6504	426692.0
2008-06-06 19:00:00	AAPL	Stock	6.6571	6.6579	6.6554	6.6571	105224.0
2008-06-06 19:30:00	AAPL	Stock	6.6554	6.6643	6.6521	6.6554	274400.0
2008-06-06 08:00:00	MSFT	Stock	28.34	28.35	28.21	28.3	4028.0
2008-06-06 08:30:00	MSFT	Stock	28.26	28.3	28.02	28.05	69561.0
2008-06-06 09:00:00	MSFT	Stock	28.05	28.1	27.95	27.95	133609.0
2008-06-06 09:30:00	MSFT	Stock	27.97	28.14	27.85	28.05	8453279.0
2008-06-06 10:00:00	MSFT	Stock	28.05	28.15	27.89	28.12	7016652.0
2008-06-06 10:30:00	MSFT	Stock	28.125	28.17	28.05	28.05	5273307.0
2008-06-06 11:00:00	MSFT	Stock	28.05	28.1	27.98	28.06	4407630.0
2008-06-06 11:30:00	MSFT	Stock	28.06	28.11	28.01	28.03	3450486.0
2008-06-06 12:00:00	MSFT	Stock	28.02	28.05	27.93	27.95	3249296.0
2008-06-06 12:30:00	MSFT	Stock	27.958	28.01	27.93	27.965	2604947.0
2008-06-06 13:00:00	MSFT	Stock	27.97	27.97	27.84	27.89	4616987.0
2008-06-06 13:30:00	MSFT	Stock	27.9	27.98	27.86	27.94	2944024.0
2008-06-06 14:00:00	MSFT	Stock	27.94	27.94	27.7	27.72	6029427.0
2008-06-06 14:30:00	MSFT	Stock	27.72	27.78	27.67	27.7	5242332.0
2008-06-06 15:00:00	MSFT	Stock	27.7	27.9	27.62	27.68	7201412.0
2008-06-06 15:30:00	MSFT	Stock	27.68	27.71	27.5	27.5	13172044.0
2008-06-06 16:00:00	MSFT	Stock	27.49	27.871	27.45	27.48	3896172.0
2008-06-06 16:30:00	MSFT	Stock	27.51	27.851	27.49	27.58	96531.0
2008-06-06 17:00:00	MSFT	Stock	27.59	27.6	27.49	27.6	74981.0
2008-06-06 17:30:00	MSFT	Stock	27.55	27.691	27.55	27.691	23374.0
2008-06-06 18:00:00	MSFT	Stock	27.55	27.61	27.55	27.61	4076.0
2008-06-06 18:30:00	MSFT	Stock	27.6	27.6	27.6	27.6	100.0

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

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