PREVIEW / etf_30min / 2015-06-18

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-18.parquet
  size:    376 KB
  rows:    12,697

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-06-18 04:00:00	SPY	ETF	210.6	210.66	210.24	210.46	4200.0
2015-06-18 04:30:00	SPY	ETF	210.5	210.55	210.39	210.5	6700.0
2015-06-18 05:00:00	SPY	ETF	210.38	210.45	210.0	210.27	26222.0
2015-06-18 05:30:00	SPY	ETF	210.18	210.71	210.03	210.63	76009.0
2015-06-18 06:00:00	SPY	ETF	210.66	210.91	210.54	210.91	52438.0
2015-06-18 06:30:00	SPY	ETF	210.88	211.1	210.85	210.98	90648.0
2015-06-18 07:00:00	SPY	ETF	210.96	211.0	210.88	210.96	61883.0
2015-06-18 07:30:00	SPY	ETF	210.95	210.99	210.76	210.92	54881.0
2015-06-18 08:00:00	SPY	ETF	210.91	211.04	210.84	210.88	270266.0
2015-06-18 08:30:00	SPY	ETF	211.03	211.18	210.9	210.98	501024.0
2015-06-18 09:00:00	SPY	ETF	210.97	211.36	210.88	211.31	594480.0
2015-06-18 09:30:00	SPY	ETF	211.31	212.02	211.17	211.86	16195289.0
2015-06-18 10:00:00	SPY	ETF	211.865	212.39	211.86	212.27	15133221.0
2015-06-18 10:30:00	SPY	ETF	212.28	212.59	212.15	212.56	10486515.0
2015-06-18 11:00:00	SPY	ETF	212.56	212.85	212.54	212.76	10377993.0
2015-06-18 11:30:00	SPY	ETF	212.76	212.94	212.71	212.76	10031686.0
2015-06-18 12:00:00	SPY	ETF	212.75	213.12	212.69	212.97	14153013.0
2015-06-18 12:30:00	SPY	ETF	212.975	213.34	212.78	212.81	12084007.0
2015-06-18 13:00:00	SPY	ETF	212.81	212.95	212.44	212.57	7839604.0
2015-06-18 13:30:00	SPY	ETF	212.57	212.69	212.5	212.56	5599395.0
2015-06-18 14:00:00	SPY	ETF	212.57	212.81	212.51	212.701	6433469.0
2015-06-18 14:30:00	SPY	ETF	212.705	212.99	212.68	212.96	6330516.0
2015-06-18 15:00:00	SPY	ETF	212.96	213.05	212.74	213.05	11573752.0
2015-06-18 15:30:00	SPY	ETF	213.04	213.1	212.66	212.75	21785526.0
2015-06-18 16:00:00	SPY	ETF	212.74	212.92	212.71	212.85	6817901.0
2015-06-18 16:30:00	SPY	ETF	212.85	212.91	210.67	212.84	2633363.0
2015-06-18 17:00:00	SPY	ETF	212.86	212.94	212.86	212.93	133503.0
2015-06-18 17:30:00	SPY	ETF	212.93	212.94	212.9	212.92	19692.0
2015-06-18 18:00:00	SPY	ETF	212.9	212.9	212.67	212.78	908308.0
2015-06-18 18:30:00	SPY	ETF	212.73	212.75	212.62	212.66	30799.0
2015-06-18 19:00:00	SPY	ETF	212.68	212.71	212.67	212.68	10270.0
2015-06-18 19:30:00	SPY	ETF	212.72	212.78	212.72	212.77	5341.0
2015-06-18 05:30:00	QQQ	ETF	109.0	109.09	109.0	109.09	2200.0
2015-06-18 06:00:00	QQQ	ETF	109.13	109.21	109.13	109.2	10300.0
2015-06-18 06:30:00	QQQ	ETF	109.18	109.29	109.18	109.21	23000.0
2015-06-18 07:00:00	QQQ	ETF	109.28	109.29	109.26	109.26	5300.0
2015-06-18 07:30:00	QQQ	ETF	109.27	109.27	109.15	109.15	52500.0
2015-06-18 08:00:00	QQQ	ETF	109.23	109.31	109.2	109.27	15383.0
2015-06-18 08:30:00	QQQ	ETF	109.29	109.43	109.29	109.29	190720.0
2015-06-18 09:00:00	QQQ	ETF	109.29	109.51	109.26	109.5	222264.0
2015-06-18 09:30:00	QQQ	ETF	109.5	110.12	109.44	110.06	4129288.0
2015-06-18 10:00:00	QQQ	ETF	110.07	110.41	110.04	110.31	2877263.0
2015-06-18 10:30:00	QQQ	ETF	110.31	110.57	110.2501	110.53	2869004.0
2015-06-18 11:00:00	QQQ	ETF	110.53	110.66	110.53	110.645	2139224.0
2015-06-18 11:30:00	QQQ	ETF	110.65	110.77	110.62	110.66	1807415.0
2015-06-18 12:00:00	QQQ	ETF	110.65	110.8	110.6	110.75	2165018.0
2015-06-18 12:30:00	QQQ	ETF	110.76	110.88	110.611	110.62	2104942.0
2015-06-18 13:00:00	QQQ	ETF	110.63	110.71	110.44	110.52	1246593.0
2015-06-18 13:30:00	QQQ	ETF	110.51	110.55	110.43	110.47	721687.0
2015-06-18 14:00:00	QQQ	ETF	110.465	110.57	110.44	110.5	736449.0

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

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