PREVIEW / stock_30min / 2009-05-11

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-11.parquet
  size:    1.3 MB
  rows:    74,283
  symbols: 3,348

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
2009-05-11 04:00:00	AAPL	Stock	4.67	4.67	4.67	4.67	2800.0
2009-05-11 07:30:00	AAPL	Stock	4.5714	4.5714	4.5554	4.5554	32116.0
2009-05-11 08:00:00	AAPL	Stock	4.5804	4.5804	4.5571	4.5643	196336.0
2009-05-11 08:30:00	AAPL	Stock	4.5607	4.5786	4.5607	4.5696	337204.0
2009-05-11 09:00:00	AAPL	Stock	4.5679	4.5714	4.5475	4.5482	559636.0
2009-05-11 09:30:00	AAPL	Stock	4.5489	4.5964	4.54	4.5657	54868716.0
2009-05-11 10:00:00	AAPL	Stock	4.5661	4.6325	4.5554	4.625	48244812.0
2009-05-11 10:30:00	AAPL	Stock	4.6254	4.6707	4.6071	4.63	47076848.0
2009-05-11 11:00:00	AAPL	Stock	4.63	4.6564	4.6214	4.625	24531892.0
2009-05-11 11:30:00	AAPL	Stock	4.6254	4.6464	4.6182	4.6304	20971972.0
2009-05-11 12:00:00	AAPL	Stock	4.6304	4.655	4.6196	4.6494	19555368.0
2009-05-11 12:30:00	AAPL	Stock	4.6493	4.6507	4.6261	4.6289	16127664.0
2009-05-11 13:00:00	AAPL	Stock	4.6293	4.6675	4.6287	4.6582	22694924.0
2009-05-11 13:30:00	AAPL	Stock	4.6582	4.6771	4.6518	4.6636	21621488.0
2009-05-11 14:00:00	AAPL	Stock	4.6636	4.6654	4.6479	4.6589	19943896.0
2009-05-11 14:30:00	AAPL	Stock	4.6596	4.6654	4.6429	4.6554	21713608.0
2009-05-11 15:00:00	AAPL	Stock	4.6564	4.6571	4.6339	4.645	26355000.0
2009-05-11 15:30:00	AAPL	Stock	4.6446	4.6486	4.6071	4.6257	37176692.0
2009-05-11 16:00:00	AAPL	Stock	4.6239	4.64	4.6071	4.6296	15183672.0
2009-05-11 16:30:00	AAPL	Stock	4.6254	4.6275	4.6245	4.625	258804.0
2009-05-11 17:00:00	AAPL	Stock	4.6214	4.6275	4.6214	4.625	184968.0
2009-05-11 17:30:00	AAPL	Stock	4.6204	4.6204	4.6196	4.6196	14000.0
2009-05-11 18:00:00	AAPL	Stock	4.6275	4.6275	4.6125	4.6125	143248.0
2009-05-11 18:30:00	AAPL	Stock	4.6132	4.6132	4.6075	4.6075	50400.0
2009-05-11 19:00:00	AAPL	Stock	4.6143	4.6143	4.6111	4.6111	8400.0
2009-05-11 19:30:00	AAPL	Stock	4.6114	4.6143	4.6107	4.6107	65800.0
2009-05-11 07:00:00	MSFT	Stock	19.4	19.4	19.4	19.4	200.0
2009-05-11 07:30:00	MSFT	Stock	19.36	19.37	19.26	19.36	9400.0
2009-05-11 08:00:00	MSFT	Stock	19.31	19.34	19.27	19.29	5764.0
2009-05-11 08:30:00	MSFT	Stock	19.29	19.3	19.27	19.27	7399.0
2009-05-11 09:00:00	MSFT	Stock	19.27	19.35	19.13	19.17	51888.0
2009-05-11 09:30:00	MSFT	Stock	19.17	19.25	19.01	19.24	7264491.0
2009-05-11 10:00:00	MSFT	Stock	19.23	19.51	19.18	19.475	7217288.0
2009-05-11 10:30:00	MSFT	Stock	19.47	19.73	19.44	19.64	7107311.0
2009-05-11 11:00:00	MSFT	Stock	19.641	19.7	19.55	19.57	4121874.0
2009-05-11 11:30:00	MSFT	Stock	19.56	19.58	19.32	19.338	5742246.0
2009-05-11 12:00:00	MSFT	Stock	19.33	19.49	19.31	19.45	2268431.0
2009-05-11 12:30:00	MSFT	Stock	19.45	19.5	19.43	19.43	1429326.0
2009-05-11 13:00:00	MSFT	Stock	19.44	19.53	19.41	19.51	2723742.0
2009-05-11 13:30:00	MSFT	Stock	19.51	19.67	19.48	19.652	2813907.0
2009-05-11 14:00:00	MSFT	Stock	19.66	19.67	19.56	19.598	2884837.0
2009-05-11 14:30:00	MSFT	Stock	19.6	19.61	19.44	19.442	4812904.0
2009-05-11 15:00:00	MSFT	Stock	19.44	19.5	19.41	19.488	3817266.0
2009-05-11 15:30:00	MSFT	Stock	19.48	19.55	19.33	19.33	7702056.0
2009-05-11 16:00:00	MSFT	Stock	19.33	19.48	19.05	19.32	2358913.0
2009-05-11 16:30:00	MSFT	Stock	19.32	19.455	19.32	19.37	18825.0
2009-05-11 17:00:00	MSFT	Stock	19.38	19.42	19.32	19.38	61313.0
2009-05-11 17:30:00	MSFT	Stock	19.36	19.4	19.36	19.38	5705.0
2009-05-11 18:00:00	MSFT	Stock	19.37	19.38	19.34	19.37	8835.0
2009-05-11 18:30:00	MSFT	Stock	19.34	19.37	19.34	19.34	3300.0

> showing 50 of 74,283 rows — these rows as CSV

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