PREVIEW / stock_30min / 2008-01-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-25.parquet
  size:    1.2 MB
  rows:    69,217
  symbols: 3,270

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-01-25 04:30:00	AAPL	Stock	4.9461	4.9464	4.9461	4.9464	11200.0
2008-01-25 05:00:00	AAPL	Stock	4.9718	4.9839	4.9718	4.9839	8540.0
2008-01-25 06:00:00	AAPL	Stock	4.9732	4.9732	4.9732	4.9732	16800.0
2008-01-25 06:30:00	AAPL	Stock	4.9639	4.9639	4.9464	4.9593	88872.0
2008-01-25 07:00:00	AAPL	Stock	4.9471	4.9607	4.9325	4.9375	233408.0
2008-01-25 07:30:00	AAPL	Stock	4.9446	4.9446	4.9196	4.9214	425992.0
2008-01-25 08:00:00	AAPL	Stock	4.9271	4.9354	4.8957	4.92	3673712.0
2008-01-25 08:30:00	AAPL	Stock	4.9229	4.9821	4.9196	4.9557	8030764.0
2008-01-25 09:00:00	AAPL	Stock	4.9571	4.9657	4.9429	4.9643	6596968.0
2008-01-25 09:30:00	AAPL	Stock	4.9643	4.9675	4.8525	4.905	242324208.0
2008-01-25 10:00:00	AAPL	Stock	4.9054	4.9054	4.8286	4.8479	158833080.0
2008-01-25 10:30:00	AAPL	Stock	4.8464	4.8482	4.7564	4.7657	163591428.0
2008-01-25 11:00:00	AAPL	Stock	4.7661	4.79	4.7189	4.7425	126339388.0
2008-01-25 11:30:00	AAPL	Stock	4.7425	4.7946	4.74	4.7925	92225392.0
2008-01-25 12:00:00	AAPL	Stock	4.7929	4.8011	4.7689	4.7911	54639032.0
2008-01-25 12:30:00	AAPL	Stock	4.7911	4.7925	4.7068	4.7096	80328528.0
2008-01-25 13:00:00	AAPL	Stock	4.7097	4.7246	4.6904	4.7043	83104392.0
2008-01-25 13:30:00	AAPL	Stock	4.7021	4.7104	4.6518	4.6729	96205872.0
2008-01-25 14:00:00	AAPL	Stock	4.6729	4.7143	4.65	4.695	99539216.0
2008-01-25 14:30:00	AAPL	Stock	4.695	4.7179	4.6625	4.6876	75852980.0
2008-01-25 15:00:00	AAPL	Stock	4.6868	4.7229	4.6732	4.7046	85877876.0
2008-01-25 15:30:00	AAPL	Stock	4.705	4.7186	4.6289	4.6421	154262584.0
2008-01-25 16:00:00	AAPL	Stock	4.642	4.7687	4.6361	4.6421	20921180.0
2008-01-25 16:30:00	AAPL	Stock	4.6396	4.6439	4.6393	4.6411	1818404.0
2008-01-25 17:00:00	AAPL	Stock	4.6411	4.8429	4.6321	4.6361	2052792.0
2008-01-25 17:30:00	AAPL	Stock	4.6354	4.6432	4.6304	4.6357	386316.0
2008-01-25 18:00:00	AAPL	Stock	4.6432	4.6439	4.6304	4.6386	1856932.0
2008-01-25 18:30:00	AAPL	Stock	4.6439	4.6439	4.6379	4.6393	139608.0
2008-01-25 19:00:00	AAPL	Stock	4.6386	4.6425	4.6364	4.6375	125244.0
2008-01-25 19:30:00	AAPL	Stock	4.6393	4.6425	4.6321	4.6321	257068.0
2008-01-25 07:00:00	MSFT	Stock	34.75	34.89	34.75	34.86	3875.0
2008-01-25 07:30:00	MSFT	Stock	34.81	34.95	34.79	34.95	40547.0
2008-01-25 08:00:00	MSFT	Stock	34.9	35.24	34.84	35.08	558489.0
2008-01-25 08:30:00	MSFT	Stock	35.06	35.15	33.25	34.8	1268101.0
2008-01-25 09:00:00	MSFT	Stock	34.84	34.98	34.78	34.9	1571551.0
2008-01-25 09:30:00	MSFT	Stock	34.91	35.0	34.14	34.19	33389050.0
2008-01-25 10:00:00	MSFT	Stock	34.199	34.25	33.81	33.87	25303714.0
2008-01-25 10:30:00	MSFT	Stock	33.86	33.92	33.56	33.61	17722852.0
2008-01-25 11:00:00	MSFT	Stock	33.61	33.65	33.4	33.42	15215668.0
2008-01-25 11:30:00	MSFT	Stock	33.41	33.62	33.36	33.6	10832965.0
2008-01-25 12:00:00	MSFT	Stock	33.59	33.68	33.4	33.442	7950050.0
2008-01-25 12:30:00	MSFT	Stock	33.442	33.45	33.06	33.2	11256481.0
2008-01-25 13:00:00	MSFT	Stock	33.198	33.34	33.04	33.2	8697869.0
2008-01-25 13:30:00	MSFT	Stock	33.2	33.4	33.12	33.36	8965707.0
2008-01-25 14:00:00	MSFT	Stock	33.36	33.46	33.27	33.38	9545632.0
2008-01-25 14:30:00	MSFT	Stock	33.38	33.43	33.1	33.17	8393620.0
2008-01-25 15:00:00	MSFT	Stock	33.17	33.31	33.12	33.2	11418959.0
2008-01-25 15:30:00	MSFT	Stock	33.2	33.2	32.87	32.95	19198225.0
2008-01-25 16:00:00	MSFT	Stock	32.94	34.46	32.88	32.93	4494725.0
2008-01-25 16:30:00	MSFT	Stock	32.93	33.32	32.85	32.87	464368.0

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

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