PREVIEW / etf_30min / 2015-10-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-26.parquet
  size:    372 KB
  rows:    12,705

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-10-26 04:00:00	SPY	ETF	206.9	206.9	206.42	206.47	10026.0
2015-10-26 04:30:00	SPY	ETF	206.42	206.77	206.4	206.77	16746.0
2015-10-26 05:00:00	SPY	ETF	206.78	206.91	206.63	206.91	6503.0
2015-10-26 05:30:00	SPY	ETF	206.85	206.86	206.83	206.83	635.0
2015-10-26 06:00:00	SPY	ETF	206.88	207.05	206.87	206.97	3676.0
2015-10-26 06:30:00	SPY	ETF	206.92	207.0	206.84	206.98	35397.0
2015-10-26 07:00:00	SPY	ETF	206.92	206.98	206.79	206.9	29944.0
2015-10-26 07:30:00	SPY	ETF	206.87	206.91	206.8	206.9	483049.0
2015-10-26 08:00:00	SPY	ETF	206.87	207.06	206.8	206.93	239364.0
2015-10-26 08:30:00	SPY	ETF	206.96	207.27	206.91	207.21	319114.0
2015-10-26 09:00:00	SPY	ETF	207.2	207.39	207.16	207.29	737738.0
2015-10-26 09:30:00	SPY	ETF	207.3	207.34	206.72	206.79	9247992.0
2015-10-26 10:00:00	SPY	ETF	206.8	207.305	206.56	206.91	9190554.0
2015-10-26 10:30:00	SPY	ETF	206.9	207.2	206.79	207.11	4952242.0
2015-10-26 11:00:00	SPY	ETF	207.11	207.2	206.84	206.85	2407781.0
2015-10-26 11:30:00	SPY	ETF	206.84	207.0967	206.83	206.88	2580383.0
2015-10-26 12:00:00	SPY	ETF	206.87	207.09	206.73	207.04	2271246.0
2015-10-26 12:30:00	SPY	ETF	207.03	207.3623	206.95	207.1925	5987569.0
2015-10-26 13:00:00	SPY	ETF	207.19	207.26	207.052	207.2199	2070298.0
2015-10-26 13:30:00	SPY	ETF	207.22	207.37	206.96	206.975	4966329.0
2015-10-26 14:00:00	SPY	ETF	206.98	207.225	206.88	206.92	3752635.0
2015-10-26 14:30:00	SPY	ETF	206.92	207.19	206.89	207.1	2796353.0
2015-10-26 15:00:00	SPY	ETF	207.1	207.18	206.98	207.0899	3425890.0
2015-10-26 15:30:00	SPY	ETF	207.09	207.18	206.93	206.97	7804833.0
2015-10-26 16:00:00	SPY	ETF	206.97	207.0574	206.8	206.8	4192434.0
2015-10-26 16:30:00	SPY	ETF	206.85	207.0	206.85	206.94	189311.0
2015-10-26 17:00:00	SPY	ETF	206.94	206.94	206.92	206.93	5588.0
2015-10-26 17:30:00	SPY	ETF	206.92	207.0	206.92	206.99	9932.0
2015-10-26 18:00:00	SPY	ETF	206.96	207.0	206.91	207.0	528682.0
2015-10-26 18:30:00	SPY	ETF	206.96	207.0	206.96	207.0	872.0
2015-10-26 19:00:00	SPY	ETF	206.95	206.99	206.95	206.99	7895.0
2015-10-26 19:30:00	SPY	ETF	206.98	206.98	206.91	206.97	14833.0
2015-10-26 04:30:00	QQQ	ETF	112.29	112.29	112.29	112.29	100.0
2015-10-26 05:00:00	QQQ	ETF	112.36	112.42	112.29	112.42	9500.0
2015-10-26 05:30:00	QQQ	ETF	112.41	112.41	112.36	112.39	5899.0
2015-10-26 06:00:00	QQQ	ETF	112.4	112.43	112.4	112.43	2000.0
2015-10-26 06:30:00	QQQ	ETF	112.43	112.43	112.43	112.43	300.0
2015-10-26 07:00:00	QQQ	ETF	112.43	112.43	112.39	112.4	42759.0
2015-10-26 07:30:00	QQQ	ETF	112.42	112.43	112.36	112.41	15213.0
2015-10-26 08:00:00	QQQ	ETF	112.42	112.5	112.41	112.47	61294.0
2015-10-26 08:30:00	QQQ	ETF	112.46	112.7	112.45	112.64	279337.0
2015-10-26 09:00:00	QQQ	ETF	112.65	112.77	112.63	112.7	429263.0
2015-10-26 09:30:00	QQQ	ETF	112.7	112.72	112.31	112.37	5301481.0
2015-10-26 10:00:00	QQQ	ETF	112.37	112.61	112.27	112.55	2405364.0
2015-10-26 10:30:00	QQQ	ETF	112.55	113.01	112.49	112.94	2307314.0
2015-10-26 11:00:00	QQQ	ETF	112.95	112.98	112.6838	112.71	2079065.0
2015-10-26 11:30:00	QQQ	ETF	112.7	112.89	112.59	112.625	910253.0
2015-10-26 12:00:00	QQQ	ETF	112.62	112.865	112.56	112.8269	638951.0
2015-10-26 12:30:00	QQQ	ETF	112.845	113.045	112.7738	112.9	1114240.0
2015-10-26 13:00:00	QQQ	ETF	112.89	113.07	112.8204	112.97	2271411.0

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

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