PREVIEW / etf_30min / 2015-05-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-20.parquet
  size:    369 KB
  rows:    12,552

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
2015-05-20 04:00:00	SPY	ETF	212.9	212.9	212.76	212.76	600.0
2015-05-20 04:30:00	SPY	ETF	212.81	212.84	212.77	212.77	500.0
2015-05-20 05:00:00	SPY	ETF	212.81	212.93	212.81	212.93	11116.0
2015-05-20 05:30:00	SPY	ETF	212.86	212.92	212.82	212.82	13800.0
2015-05-20 06:00:00	SPY	ETF	212.85	213.05	212.85	213.02	8525.0
2015-05-20 06:30:00	SPY	ETF	212.97	213.12	212.97	213.09	16005.0
2015-05-20 07:00:00	SPY	ETF	213.02	213.14	213.02	213.05	121777.0
2015-05-20 07:30:00	SPY	ETF	213.07	213.1	212.9	212.94	37283.0
2015-05-20 08:00:00	SPY	ETF	212.94	213.2	212.9	213.04	275112.0
2015-05-20 08:30:00	SPY	ETF	213.07	213.14	212.85	213.11	243301.0
2015-05-20 09:00:00	SPY	ETF	213.11	213.24	213.02	213.16	424976.0
2015-05-20 09:30:00	SPY	ETF	213.15	213.2	212.504	212.62	8548146.0
2015-05-20 10:00:00	SPY	ETF	212.62	213.07	212.53	212.935	5803479.0
2015-05-20 10:30:00	SPY	ETF	212.93	213.19	212.91	213.02	3576354.0
2015-05-20 11:00:00	SPY	ETF	213.03	213.13	212.89	212.94	2790245.0
2015-05-20 11:30:00	SPY	ETF	212.94	213.0	212.68	212.813	6192917.0
2015-05-20 12:00:00	SPY	ETF	212.82	213.1	212.78	212.99	3189857.0
2015-05-20 12:30:00	SPY	ETF	212.98	213.02	212.84	212.93	1753112.0
2015-05-20 13:00:00	SPY	ETF	212.925	212.95	212.78	212.905	1319064.0
2015-05-20 13:30:00	SPY	ETF	212.91	212.94	212.74	212.87	1564900.0
2015-05-20 14:00:00	SPY	ETF	212.87	213.74	212.84	213.715	10990683.0
2015-05-20 14:30:00	SPY	ETF	213.711	213.78	213.29	213.43	5768299.0
2015-05-20 15:00:00	SPY	ETF	213.43	213.48	212.72	213.05	8852534.0
2015-05-20 15:30:00	SPY	ETF	213.06	213.12	212.82	212.86	9289837.0
2015-05-20 16:00:00	SPY	ETF	212.86	212.93	212.76	212.769	4015989.0
2015-05-20 16:30:00	SPY	ETF	212.77	212.84	212.7	212.74	210472.0
2015-05-20 17:00:00	SPY	ETF	212.73	212.88	212.59	212.66	1097524.0
2015-05-20 17:30:00	SPY	ETF	212.66	212.67	212.61	212.63	39714.0
2015-05-20 18:00:00	SPY	ETF	212.63	212.63	212.17	212.18	192003.0
2015-05-20 18:30:00	SPY	ETF	212.19	212.37	212.17	212.37	61705.0
2015-05-20 19:00:00	SPY	ETF	212.37	212.39	212.27	212.27	14625.0
2015-05-20 19:30:00	SPY	ETF	212.27	212.37	212.27	212.33	17158.0
2015-05-20 06:30:00	QQQ	ETF	110.0	110.05	110.0	110.04	21100.0
2015-05-20 07:00:00	QQQ	ETF	110.01	110.03	109.98	109.98	18350.0
2015-05-20 07:30:00	QQQ	ETF	109.97	109.97	109.92	109.93	7276.0
2015-05-20 08:00:00	QQQ	ETF	110.02	110.07	109.92	110.01	22080.0
2015-05-20 08:30:00	QQQ	ETF	110.03	110.03	109.93	110.01	14958.0
2015-05-20 09:00:00	QQQ	ETF	110.03	110.07	109.98	110.02	51771.0
2015-05-20 09:30:00	QQQ	ETF	110.02	110.03	109.425	109.54	2535854.0
2015-05-20 10:00:00	QQQ	ETF	109.53	109.84	109.44	109.725	1254244.0
2015-05-20 10:30:00	QQQ	ETF	109.73	110.01	109.73	109.91	953563.0
2015-05-20 11:00:00	QQQ	ETF	109.9	109.97	109.86	109.9	607244.0
2015-05-20 11:30:00	QQQ	ETF	109.92	109.94	109.77	109.87	577074.0
2015-05-20 12:00:00	QQQ	ETF	109.87	110.05	109.86	109.9877	530374.0
2015-05-20 12:30:00	QQQ	ETF	109.98	110.0	109.9	109.96	331872.0
2015-05-20 13:00:00	QQQ	ETF	109.965	109.97	109.88	109.93	254489.0
2015-05-20 13:30:00	QQQ	ETF	109.935	110.02	109.88	110.0	526502.0
2015-05-20 14:00:00	QQQ	ETF	109.98	110.63	109.98	110.62	2590447.0
2015-05-20 14:30:00	QQQ	ETF	110.62	110.67	110.32	110.39	2131693.0
2015-05-20 15:00:00	QQQ	ETF	110.4	110.43	109.82	110.0401	2189390.0

> showing 50 of 12,552 rows — these rows as CSV

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