PREVIEW / stock_30min / 2008-02-05

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-05.parquet
  size:    1.2 MB
  rows:    69,570
  symbols: 3,235

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-02-05 05:00:00	AAPL	Stock	4.71	4.71	4.71	4.71	2800.0
2008-02-05 05:30:00	AAPL	Stock	4.7107	4.7107	4.7036	4.7036	11200.0
2008-02-05 06:00:00	AAPL	Stock	4.7168	4.7168	4.6957	4.7168	66500.0
2008-02-05 06:30:00	AAPL	Stock	4.7132	4.7132	4.7132	4.7132	5600.0
2008-02-05 07:00:00	AAPL	Stock	4.6532	4.7179	4.6532	4.7143	106232.0
2008-02-05 07:30:00	AAPL	Stock	4.6929	4.6929	4.6857	4.6857	94136.0
2008-02-05 08:00:00	AAPL	Stock	4.6839	4.7218	4.6836	4.7218	1259664.0
2008-02-05 08:30:00	AAPL	Stock	4.7246	4.7743	4.6625	4.6732	11238472.0
2008-02-05 09:00:00	AAPL	Stock	4.6732	4.6829	4.6486	4.6582	4746672.0
2008-02-05 09:30:00	AAPL	Stock	4.6582	4.7571	4.6557	4.7479	175168252.0
2008-02-05 10:00:00	AAPL	Stock	4.7475	4.7857	4.7143	4.7636	115813992.0
2008-02-05 10:30:00	AAPL	Stock	4.7636	4.7675	4.6957	4.7168	90272672.0
2008-02-05 11:00:00	AAPL	Stock	4.7171	4.7211	4.6982	4.6982	53151280.0
2008-02-05 11:30:00	AAPL	Stock	4.6982	4.7014	4.6636	4.6696	72144044.0
2008-02-05 12:00:00	AAPL	Stock	4.6689	4.6743	4.6504	4.6743	52871504.0
2008-02-05 12:30:00	AAPL	Stock	4.6739	4.6818	4.6464	4.655	46543252.0
2008-02-05 13:00:00	AAPL	Stock	4.655	4.6668	4.6189	4.6375	85148756.0
2008-02-05 13:30:00	AAPL	Stock	4.6379	4.6486	4.6096	4.6221	65709448.0
2008-02-05 14:00:00	AAPL	Stock	4.6225	4.6536	4.6036	4.645	79306920.0
2008-02-05 14:30:00	AAPL	Stock	4.645	4.6754	4.6382	4.6411	80028984.0
2008-02-05 15:00:00	AAPL	Stock	4.6407	4.6568	4.6179	4.6336	77880852.0
2008-02-05 15:30:00	AAPL	Stock	4.6336	4.6629	4.6168	4.6221	109031832.0
2008-02-05 16:00:00	AAPL	Stock	4.6207	4.6767	4.6154	4.625	18121712.0
2008-02-05 16:30:00	AAPL	Stock	4.6236	4.6321	4.62	4.6282	572292.0
2008-02-05 17:00:00	AAPL	Stock	4.6286	4.6379	4.62	4.6339	362460.0
2008-02-05 17:30:00	AAPL	Stock	4.6321	4.6428	4.6289	4.6428	467152.0
2008-02-05 18:00:00	AAPL	Stock	4.6339	4.6339	4.6286	4.6321	140280.0
2008-02-05 18:30:00	AAPL	Stock	4.6304	4.6318	4.6257	4.6289	179116.0
2008-02-05 19:00:00	AAPL	Stock	4.6304	4.6361	4.63	4.6354	293048.0
2008-02-05 19:30:00	AAPL	Stock	4.6371	4.6425	4.6339	4.6339	308364.0
2008-02-05 07:30:00	MSFT	Stock	30.16	30.19	30.15	30.19	6200.0
2008-02-05 08:00:00	MSFT	Stock	30.19	30.2	30.11	30.12	1070209.0
2008-02-05 08:30:00	MSFT	Stock	30.13	30.18	29.95	29.95	94494.0
2008-02-05 09:00:00	MSFT	Stock	29.94	29.99	29.84	29.88	269885.0
2008-02-05 09:30:00	MSFT	Stock	29.88	29.94	28.89	29.74	17296520.0
2008-02-05 10:00:00	MSFT	Stock	29.73	29.86	29.64	29.852	11571151.0
2008-02-05 10:30:00	MSFT	Stock	29.86	29.92	29.75	29.84	7619609.0
2008-02-05 11:00:00	MSFT	Stock	29.84	29.9	29.72	29.75	11849850.0
2008-02-05 11:30:00	MSFT	Stock	29.75	29.92	29.71	29.83	8008971.0
2008-02-05 12:00:00	MSFT	Stock	29.829	29.83	29.67	29.71	6185428.0
2008-02-05 12:30:00	MSFT	Stock	29.71	29.73	29.6	29.64	4551567.0
2008-02-05 13:00:00	MSFT	Stock	29.639	29.65	29.43	29.448	7314220.0
2008-02-05 13:30:00	MSFT	Stock	29.44	29.53	29.32	29.37	8917624.0
2008-02-05 14:00:00	MSFT	Stock	29.37	29.42	29.27	29.36	8115066.0
2008-02-05 14:30:00	MSFT	Stock	29.36	29.42	29.2	29.21	9091017.0
2008-02-05 15:00:00	MSFT	Stock	29.209	29.34	29.15	29.3	10632612.0
2008-02-05 15:30:00	MSFT	Stock	29.31	29.39	29.01	29.07	20956064.0
2008-02-05 16:00:00	MSFT	Stock	29.1	29.545	29.03	29.452	3749329.0
2008-02-05 16:30:00	MSFT	Stock	29.576	29.576	29.07	29.17	90872.0
2008-02-05 17:00:00	MSFT	Stock	29.03	29.22	29.03	29.21	112511.0

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

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