PREVIEW / etf_30min / 2017-09-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-26.parquet
  size:    430 KB
  rows:    14,938

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
2017-09-26 04:00:00	SPY	ETF	249.26	249.26	249.05	249.05	11800.0
2017-09-26 04:30:00	SPY	ETF	249.05	249.14	249.05	249.14	6300.0
2017-09-26 05:00:00	SPY	ETF	249.17	249.23	249.17	249.23	500.0
2017-09-26 05:30:00	SPY	ETF	249.2	249.23	249.2	249.23	500.0
2017-09-26 06:00:00	SPY	ETF	249.22	249.27	249.22	249.27	1800.0
2017-09-26 06:30:00	SPY	ETF	249.27	249.27	249.2	249.21	11373.0
2017-09-26 07:00:00	SPY	ETF	249.13	249.21	249.02	249.21	64868.0
2017-09-26 07:30:00	SPY	ETF	249.21	249.23	249.11	249.15	37848.0
2017-09-26 08:00:00	SPY	ETF	249.14	249.19	249.01	249.14	73011.0
2017-09-26 08:30:00	SPY	ETF	249.16	249.39	249.16	249.37	189494.0
2017-09-26 09:00:00	SPY	ETF	249.36	249.46	249.34	249.42	155794.0
2017-09-26 09:30:00	SPY	ETF	249.42	249.7	249.31	249.57	4812227.0
2017-09-26 10:00:00	SPY	ETF	249.58	249.67	249.46	249.46	2621180.0
2017-09-26 10:30:00	SPY	ETF	249.465	249.495	249.11	249.14	3337957.0
2017-09-26 11:00:00	SPY	ETF	249.14	249.195	248.805	248.95	2795965.0
2017-09-26 11:30:00	SPY	ETF	248.945	249.18	248.89	249.15	1928890.0
2017-09-26 12:00:00	SPY	ETF	249.15	249.28	249.015	249.25	1628271.0
2017-09-26 12:30:00	SPY	ETF	249.255	249.3256	248.99	249.19	3929384.0
2017-09-26 13:00:00	SPY	ETF	249.18	249.39	249.16	249.3099	1780734.0
2017-09-26 13:30:00	SPY	ETF	249.31	249.49	249.3	249.42	2121161.0
2017-09-26 14:00:00	SPY	ETF	249.42	249.48	249.21	249.25	2573906.0
2017-09-26 14:30:00	SPY	ETF	249.26	249.32	249.17	249.24	3365309.0
2017-09-26 15:00:00	SPY	ETF	249.24	249.44	249.24	249.43	2122857.0
2017-09-26 15:30:00	SPY	ETF	249.43	249.44	248.9	249.05	8724050.0
2017-09-26 16:00:00	SPY	ETF	249.07	249.12	248.97	249.04	7598765.0
2017-09-26 16:30:00	SPY	ETF	249.07	249.2893	248.97	249.04	779605.0
2017-09-26 17:00:00	SPY	ETF	249.01	249.06	248.98	249.0	35761.0
2017-09-26 17:30:00	SPY	ETF	249.03	249.05	249.01	249.01	10649.0
2017-09-26 18:00:00	SPY	ETF	249.01	249.05	248.97	249.02	28502.0
2017-09-26 18:30:00	SPY	ETF	248.98	249.02	248.96	249.0	2100.0
2017-09-26 19:00:00	SPY	ETF	249.01	249.04	249.01	249.03	2901.0
2017-09-26 19:30:00	SPY	ETF	249.02	249.08	249.02	249.08	14451.0
2017-09-26 04:00:00	QQQ	ETF	141.86	142.93	141.86	142.93	4750.0
2017-09-26 04:30:00	QQQ	ETF	142.92	143.01	142.91	143.01	10700.0
2017-09-26 05:00:00	QQQ	ETF	143.04	143.1	143.03	143.1	4100.0
2017-09-26 05:30:00	QQQ	ETF	143.13	143.14	143.09	143.09	15900.0
2017-09-26 06:00:00	QQQ	ETF	143.2	143.21	143.2	143.21	7700.0
2017-09-26 06:30:00	QQQ	ETF	143.16	143.16	143.12	143.12	8698.0
2017-09-26 07:00:00	QQQ	ETF	143.12	143.25	143.08	143.23	112778.0
2017-09-26 07:30:00	QQQ	ETF	143.24	143.29	143.16	143.2	56993.0
2017-09-26 08:00:00	QQQ	ETF	143.26	143.26	143.19	143.23	79815.0
2017-09-26 08:30:00	QQQ	ETF	143.26	143.51	143.26	143.51	120813.0
2017-09-26 09:00:00	QQQ	ETF	143.5	143.6	143.45	143.51	151276.0
2017-09-26 09:30:00	QQQ	ETF	143.52	143.8	143.37	143.48	4038888.0
2017-09-26 10:00:00	QQQ	ETF	143.49	143.75	143.46	143.46	1944646.0
2017-09-26 10:30:00	QQQ	ETF	143.48	143.54	143.02	143.11	2363801.0
2017-09-26 11:00:00	QQQ	ETF	143.11	143.11	142.67	142.8261	2376573.0
2017-09-26 11:30:00	QQQ	ETF	142.83	143.01	142.77	142.99	1514034.0
2017-09-26 12:00:00	QQQ	ETF	142.99	143.21	142.979	143.13	1308829.0
2017-09-26 12:30:00	QQQ	ETF	143.13	143.29	142.86	143.17	1441378.0

> showing 50 of 14,938 rows — these rows as CSV

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