PREVIEW / stock_30min / 2010-04-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-16.parquet
  size:    1.4 MB
  rows:    74,888
  symbols: 3,476

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
2010-04-16 04:30:00	AAPL	Stock	8.8639	8.8639	8.8639	8.8639	25760.0
2010-04-16 05:00:00	AAPL	Stock	8.8639	8.8639	8.8639	8.8639	7084.0
2010-04-16 06:00:00	AAPL	Stock	8.8714	8.8714	8.8607	8.8607	5600.0
2010-04-16 06:30:00	AAPL	Stock	8.8607	8.8607	8.8607	8.8607	2800.0
2010-04-16 07:00:00	AAPL	Stock	8.8607	8.875	8.8571	8.8571	84980.0
2010-04-16 07:30:00	AAPL	Stock	8.8632	8.8632	8.8536	8.8571	103600.0
2010-04-16 08:00:00	AAPL	Stock	8.8611	8.8754	8.8571	8.8654	1048684.0
2010-04-16 08:30:00	AAPL	Stock	8.8654	8.8714	8.8536	8.8625	584472.0
2010-04-16 09:00:00	AAPL	Stock	8.8607	8.8786	8.8414	8.8775	1401736.0
2010-04-16 09:30:00	AAPL	Stock	8.8775	8.9136	8.875	8.905	97156556.0
2010-04-16 10:00:00	AAPL	Stock	8.9046	8.9693	8.8979	8.9396	92842540.0
2010-04-16 10:30:00	AAPL	Stock	8.9396	8.955	8.8514	8.8861	74897984.0
2010-04-16 11:00:00	AAPL	Stock	8.8854	8.9121	8.8396	8.865	58396128.0
2010-04-16 11:30:00	AAPL	Stock	8.865	8.8921	8.7964	8.8344	56684432.0
2010-04-16 12:00:00	AAPL	Stock	8.8354	8.8354	8.7554	8.7871	55761608.0
2010-04-16 12:30:00	AAPL	Stock	8.7857	8.7957	8.7339	8.7925	43653484.0
2010-04-16 13:00:00	AAPL	Stock	8.7925	8.8332	8.7864	8.8044	27997368.0
2010-04-16 13:30:00	AAPL	Stock	8.805	8.8064	8.7743	8.8039	23962036.0
2010-04-16 14:00:00	AAPL	Stock	8.8025	8.8725	8.7957	8.8457	37395988.0
2010-04-16 14:30:00	AAPL	Stock	8.8461	8.8632	8.8107	8.8121	28698040.0
2010-04-16 15:00:00	AAPL	Stock	8.8125	8.8264	8.8036	8.8102	26557328.0
2010-04-16 15:30:00	AAPL	Stock	8.8089	8.8496	8.7961	8.8371	58394392.0
2010-04-16 16:00:00	AAPL	Stock	8.8429	8.8605	8.8261	8.8357	15162196.0
2010-04-16 16:30:00	AAPL	Stock	8.8022	8.8446	8.8022	8.8411	1054536.0
2010-04-16 17:00:00	AAPL	Stock	8.8034	8.8429	8.8034	8.8393	492408.0
2010-04-16 17:30:00	AAPL	Stock	8.8393	8.8393	8.8325	8.8357	86996.0
2010-04-16 18:00:00	AAPL	Stock	8.8311	8.8368	8.8307	8.8368	85568.0
2010-04-16 18:30:00	AAPL	Stock	8.835	8.8404	8.835	8.8393	161420.0
2010-04-16 19:00:00	AAPL	Stock	8.8429	8.8429	8.8393	8.8393	80052.0
2010-04-16 19:30:00	AAPL	Stock	8.8396	8.8396	8.8325	8.8354	73976.0
2010-04-16 08:00:00	MSFT	Stock	30.75	30.816	30.7	30.77	1585.0
2010-04-16 08:30:00	MSFT	Stock	30.77	30.78	30.7	30.75	11601.0
2010-04-16 09:00:00	MSFT	Stock	30.74	30.8	30.7	30.79	28370.0
2010-04-16 09:30:00	MSFT	Stock	30.79	30.89	30.75	30.88	10523684.0
2010-04-16 10:00:00	MSFT	Stock	30.88	30.98	30.86	30.95	6268953.0
2010-04-16 10:30:00	MSFT	Stock	30.95	30.98	30.85	30.94	11195857.0
2010-04-16 11:00:00	MSFT	Stock	30.94	30.98	30.9	30.91	7117452.0
2010-04-16 11:30:00	MSFT	Stock	30.912	30.93	30.79	30.86	6402756.0
2010-04-16 12:00:00	MSFT	Stock	30.86	30.9	30.75	30.84	4016585.0
2010-04-16 12:30:00	MSFT	Stock	30.85	30.86	30.69	30.732	6528106.0
2010-04-16 13:00:00	MSFT	Stock	30.73	30.79	30.65	30.68	3595119.0
2010-04-16 13:30:00	MSFT	Stock	30.68	30.73	30.64	30.68	3479503.0
2010-04-16 14:00:00	MSFT	Stock	30.69	30.72	30.6	30.62	5592078.0
2010-04-16 14:30:00	MSFT	Stock	30.63	30.7	30.61	30.65	3027493.0
2010-04-16 15:00:00	MSFT	Stock	30.64	30.71	30.61	30.7	4182592.0
2010-04-16 15:30:00	MSFT	Stock	30.696	30.78	30.65	30.67	8572157.0
2010-04-16 16:00:00	MSFT	Stock	30.68	30.89	30.664	30.72	7265155.0
2010-04-16 16:30:00	MSFT	Stock	30.68	30.7	30.67	30.67	159994.0
2010-04-16 17:00:00	MSFT	Stock	30.66	30.66	30.66	30.66	710.0
2010-04-16 17:30:00	MSFT	Stock	30.7	30.7	30.67	30.67	3800.0

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

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