PREVIEW / etf_30min / 2013-11-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-22.parquet
  size:    326 KB
  rows:    11,051

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
2013-11-22 04:00:00	SPY	ETF	180.01	180.01	179.86	179.96	8764.0
2013-11-22 04:30:00	SPY	ETF	179.99	180.02	179.82	179.85	25235.0
2013-11-22 05:00:00	SPY	ETF	179.81	179.95	179.8	179.95	40500.0
2013-11-22 05:30:00	SPY	ETF	179.95	179.98	179.76	179.76	18412.0
2013-11-22 06:00:00	SPY	ETF	179.81	179.89	179.8	179.86	31346.0
2013-11-22 06:30:00	SPY	ETF	179.86	179.89	179.75	179.8	27100.0
2013-11-22 07:00:00	SPY	ETF	179.79	179.91	179.76	179.89	46780.0
2013-11-22 07:30:00	SPY	ETF	179.9	179.93	179.81	179.89	64797.0
2013-11-22 08:00:00	SPY	ETF	179.88	180.16	179.79	180.11	348278.0
2013-11-22 08:30:00	SPY	ETF	180.13	180.13	179.94	179.95	291598.0
2013-11-22 09:00:00	SPY	ETF	179.94	180.08	179.93	179.95	585250.0
2013-11-22 09:30:00	SPY	ETF	179.98	180.08	179.77	180.0	9095429.0
2013-11-22 10:00:00	SPY	ETF	180.0	180.24	179.82	180.11	7599420.0
2013-11-22 10:30:00	SPY	ETF	180.1	180.24	180.05	180.155	3447964.0
2013-11-22 11:00:00	SPY	ETF	180.16	180.28	180.09	180.21	3061627.0
2013-11-22 11:30:00	SPY	ETF	180.21	180.55	180.16	180.49	6221993.0
2013-11-22 12:00:00	SPY	ETF	180.49	180.56	180.41	180.47	4859828.0
2013-11-22 12:30:00	SPY	ETF	180.46	180.52	180.43	180.5	1966335.0
2013-11-22 13:00:00	SPY	ETF	180.495	180.56	180.46	180.5	2394266.0
2013-11-22 13:30:00	SPY	ETF	180.5	180.51	180.33	180.3748	3069081.0
2013-11-22 14:00:00	SPY	ETF	180.37	180.62	180.35	180.6199	3669893.0
2013-11-22 14:30:00	SPY	ETF	180.62	180.68	180.56	180.665	3697785.0
2013-11-22 15:00:00	SPY	ETF	180.67	180.79	180.65	180.681	4596326.0
2013-11-22 15:30:00	SPY	ETF	180.68	180.83	180.65	180.76	12394175.0
2013-11-22 16:00:00	SPY	ETF	180.77	180.82	179.9152	180.63	7166305.0
2013-11-22 16:30:00	SPY	ETF	180.62	180.66	180.58	180.63	1020675.0
2013-11-22 17:00:00	SPY	ETF	180.63	180.66	180.58	180.66	79450.0
2013-11-22 17:30:00	SPY	ETF	180.64	180.81	180.62	180.62	1402300.0
2013-11-22 18:00:00	SPY	ETF	180.66	180.66	180.57	180.59	11924.0
2013-11-22 18:30:00	SPY	ETF	180.59	180.59	180.59	180.59	3170.0
2013-11-22 19:00:00	SPY	ETF	180.59	180.59	180.59	180.59	7760.0
2013-11-22 19:30:00	SPY	ETF	180.59	180.59	180.56	180.58	19884.0
2013-11-22 04:30:00	QQQ	ETF	83.62	83.62	83.56	83.56	7800.0
2013-11-22 05:00:00	QQQ	ETF	83.57	83.57	83.56	83.56	1548.0
2013-11-22 05:30:00	QQQ	ETF	83.6	83.6	83.48	83.48	8300.0
2013-11-22 06:00:00	QQQ	ETF	83.51	83.54	83.51	83.54	4900.0
2013-11-22 06:30:00	QQQ	ETF	83.51	83.51	83.51	83.51	300.0
2013-11-22 07:00:00	QQQ	ETF	83.5	83.56	83.5	83.56	8175.0
2013-11-22 07:30:00	QQQ	ETF	83.56	83.57	83.51	83.51	6665.0
2013-11-22 08:00:00	QQQ	ETF	83.53	83.65	83.5	83.61	50300.0
2013-11-22 08:30:00	QQQ	ETF	83.6	83.7	83.59	83.64	30769.0
2013-11-22 09:00:00	QQQ	ETF	83.64	83.69	83.55	83.69	121596.0
2013-11-22 09:30:00	QQQ	ETF	83.69	83.85	83.62	83.8	2832581.0
2013-11-22 10:00:00	QQQ	ETF	83.8	83.929	83.7	83.82	2098918.0
2013-11-22 10:30:00	QQQ	ETF	83.82	83.91	83.77	83.8	1130378.0
2013-11-22 11:00:00	QQQ	ETF	83.7999	83.88	83.77	83.83	1016640.0
2013-11-22 11:30:00	QQQ	ETF	83.84	83.9901	83.815	83.985	2808145.0
2013-11-22 12:00:00	QQQ	ETF	83.985	84.02	83.93	83.9651	1662139.0
2013-11-22 12:30:00	QQQ	ETF	83.96	83.99	83.94	83.97	496458.0
2013-11-22 13:00:00	QQQ	ETF	83.97	83.97	83.91	83.94	589499.0

> showing 50 of 11,051 rows — these rows as CSV

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