PREVIEW / stock_30min / 2010-06-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-17.parquet
  size:    1.3 MB
  rows:    72,334
  symbols: 3,445

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-06-17 04:30:00	AAPL	Stock	9.5789	9.5789	9.5789	9.5789	2800.0
2010-06-17 05:30:00	AAPL	Stock	9.6054	9.6054	9.6054	9.6054	8400.0
2010-06-17 07:00:00	AAPL	Stock	9.5896	9.625	9.5893	9.6118	354508.0
2010-06-17 07:30:00	AAPL	Stock	9.6071	9.6304	9.6071	9.6143	747936.0
2010-06-17 08:00:00	AAPL	Stock	9.6143	9.6232	9.5446	9.6068	2293312.0
2010-06-17 08:30:00	AAPL	Stock	9.6071	9.6479	9.5786	9.6379	6042820.0
2010-06-17 09:00:00	AAPL	Stock	9.6379	9.6943	9.6325	9.6661	9781884.0
2010-06-17 09:30:00	AAPL	Stock	9.6661	9.7282	9.65	9.7275	179686416.0
2010-06-17 10:00:00	AAPL	Stock	9.7271	9.7464	9.6325	9.6511	159956888.0
2010-06-17 10:30:00	AAPL	Stock	9.6514	9.7357	9.625	9.6786	71344224.0
2010-06-17 11:00:00	AAPL	Stock	9.6791	9.6936	9.6443	9.6839	48199368.0
2010-06-17 11:30:00	AAPL	Stock	9.6843	9.7114	9.6836	9.7026	42681940.0
2010-06-17 12:00:00	AAPL	Stock	9.7026	9.7071	9.6696	9.674	29585556.0
2010-06-17 12:30:00	AAPL	Stock	9.6739	9.6846	9.6611	9.6779	19763968.0
2010-06-17 13:00:00	AAPL	Stock	9.6779	9.7007	9.6643	9.6895	22138648.0
2010-06-17 13:30:00	AAPL	Stock	9.6907	9.7214	9.6826	9.7182	28451836.0
2010-06-17 14:00:00	AAPL	Stock	9.7193	9.7268	9.6964	9.7012	35452676.0
2010-06-17 14:30:00	AAPL	Stock	9.6996	9.7136	9.6721	9.7007	36739808.0
2010-06-17 15:00:00	AAPL	Stock	9.6996	9.7011	9.6393	9.6471	51248792.0
2010-06-17 15:30:00	AAPL	Stock	9.6471	9.7193	9.6432	9.7079	102069408.0
2010-06-17 16:00:00	AAPL	Stock	9.7096	9.7161	9.6554	9.7111	11480084.0
2010-06-17 16:30:00	AAPL	Stock	9.7089	9.7132	9.6713	9.7125	348236.0
2010-06-17 17:00:00	AAPL	Stock	9.7125	9.7154	9.7107	9.7118	364336.0
2010-06-17 17:30:00	AAPL	Stock	9.7118	9.7139	9.7114	9.7125	47040.0
2010-06-17 18:00:00	AAPL	Stock	9.7107	9.7232	9.7082	9.7179	1141420.0
2010-06-17 18:30:00	AAPL	Stock	9.7179	9.7214	9.7143	9.7211	304724.0
2010-06-17 19:00:00	AAPL	Stock	9.7211	9.7232	9.7186	9.7214	190120.0
2010-06-17 19:30:00	AAPL	Stock	9.7214	9.7261	9.7179	9.7179	269416.0
2010-06-17 05:00:00	MSFT	Stock	26.38	26.38	26.38	26.38	1000.0
2010-06-17 07:00:00	MSFT	Stock	26.31	26.36	26.31	26.36	700.0
2010-06-17 08:00:00	MSFT	Stock	26.5	26.5	26.32	26.45	28741.0
2010-06-17 08:30:00	MSFT	Stock	26.47	26.47	26.41	26.42	14734.0
2010-06-17 09:00:00	MSFT	Stock	26.43	26.59	26.43	26.56	27699.0
2010-06-17 09:30:00	MSFT	Stock	26.56	26.67	26.38	26.41	6062710.0
2010-06-17 10:00:00	MSFT	Stock	26.41	26.41	26.25	26.25	5358567.0
2010-06-17 10:30:00	MSFT	Stock	26.255	26.29	26.18	26.241	3998604.0
2010-06-17 11:00:00	MSFT	Stock	26.24	26.31	26.15	26.26	2710469.0
2010-06-17 11:30:00	MSFT	Stock	26.268	26.29	26.22	26.23	2166986.0
2010-06-17 12:00:00	MSFT	Stock	26.235	26.24	26.13	26.15	2407236.0
2010-06-17 12:30:00	MSFT	Stock	26.149	26.17	26.08	26.15	2127081.0
2010-06-17 13:00:00	MSFT	Stock	26.155	26.155	26.04	26.13	1842207.0
2010-06-17 13:30:00	MSFT	Stock	26.13	26.28	26.12	26.27	1694843.0
2010-06-17 14:00:00	MSFT	Stock	26.28	26.33	26.15	26.15	1732169.0
2010-06-17 14:30:00	MSFT	Stock	26.15	26.2	26.11	26.13	1884362.0
2010-06-17 15:00:00	MSFT	Stock	26.14	26.17	26.06	26.1	3180976.0
2010-06-17 15:30:00	MSFT	Stock	26.1	26.38	26.09	26.37	8747691.0
2010-06-17 16:00:00	MSFT	Stock	26.37	26.373	26.178	26.267	3034246.0
2010-06-17 16:30:00	MSFT	Stock	26.225	26.38	26.138	26.38	32700.0
2010-06-17 17:00:00	MSFT	Stock	26.36	26.36	26.35	26.35	1000.0
2010-06-17 17:30:00	MSFT	Stock	26.35	26.4	26.35	26.4	7000.0

> showing 50 of 72,334 rows — these rows as CSV

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