PREVIEW / etf_30min / 2018-04-24

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-24.parquet
  size:    475 KB
  rows:    16,236

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
2018-04-24 04:00:00	SPY	ETF	267.45	267.88	267.45	267.88	10439.0
2018-04-24 04:30:00	SPY	ETF	267.78	268.13	267.75	268.0	27862.0
2018-04-24 05:00:00	SPY	ETF	268.06	268.06	267.81	267.9	28892.0
2018-04-24 05:30:00	SPY	ETF	268.0	268.03	267.94	267.94	9875.0
2018-04-24 06:00:00	SPY	ETF	267.97	268.37	267.96	268.34	21250.0
2018-04-24 06:30:00	SPY	ETF	268.32	268.4	268.21	268.3	39220.0
2018-04-24 07:00:00	SPY	ETF	268.29	268.32	268.14	268.18	59076.0
2018-04-24 07:30:00	SPY	ETF	268.16	268.45	268.13	268.3	117949.0
2018-04-24 08:00:00	SPY	ETF	268.29	268.44	267.23	268.27	207813.0
2018-04-24 08:30:00	SPY	ETF	268.27	268.27	267.94	268.03	209076.0
2018-04-24 09:00:00	SPY	ETF	268.02	268.05	267.72	267.75	451502.0
2018-04-24 09:30:00	SPY	ETF	267.73	267.9762	266.92	267.2702	6290160.0
2018-04-24 10:00:00	SPY	ETF	267.27	267.78	266.32	266.62	6044876.0
2018-04-24 10:30:00	SPY	ETF	266.62	267.07	266.19	266.38	5139741.0
2018-04-24 11:00:00	SPY	ETF	266.38	266.66	265.68	266.59	6828920.0
2018-04-24 11:30:00	SPY	ETF	266.6	266.87	265.71	265.71	4829744.0
2018-04-24 12:00:00	SPY	ETF	265.7	266.0	264.67	264.91	6802328.0
2018-04-24 12:30:00	SPY	ETF	264.9	264.96	263.57	263.57	7662647.0
2018-04-24 13:00:00	SPY	ETF	263.58	264.09	263.17	263.42	6026641.0
2018-04-24 13:30:00	SPY	ETF	263.42	263.55	261.98	262.31	7920852.0
2018-04-24 14:00:00	SPY	ETF	262.3	262.65	261.33	261.79	10363842.0
2018-04-24 14:30:00	SPY	ETF	261.78	262.51	261.28	262.33	7490448.0
2018-04-24 15:00:00	SPY	ETF	262.33	263.34	262.23	262.7211	9443037.0
2018-04-24 15:30:00	SPY	ETF	262.7208	263.15	261.65	263.03	17863553.0
2018-04-24 16:00:00	SPY	ETF	263.04	267.76	262.97	263.2	6662895.0
2018-04-24 16:30:00	SPY	ETF	263.2	263.26	262.98	263.24	172202.0
2018-04-24 17:00:00	SPY	ETF	263.23	263.27	263.08	263.14	73335.0
2018-04-24 17:30:00	SPY	ETF	263.13	263.19	263.12	263.16	66011.0
2018-04-24 18:00:00	SPY	ETF	263.16	263.52	263.07	263.46	68217.0
2018-04-24 18:30:00	SPY	ETF	263.44	263.45	263.37	263.39	5502.0
2018-04-24 19:00:00	SPY	ETF	263.45	263.45	263.29	263.38	7040.0
2018-04-24 19:30:00	SPY	ETF	263.42	263.52	263.4	263.45	8499.0
2018-04-24 04:00:00	QQQ	ETF	162.39	162.86	162.39	162.86	4663.0
2018-04-24 04:30:00	QQQ	ETF	162.88	163.12	162.83	163.07	41062.0
2018-04-24 05:00:00	QQQ	ETF	163.08	163.08	163.01	163.05	15300.0
2018-04-24 05:30:00	QQQ	ETF	163.2	163.2	163.14	163.14	900.0
2018-04-24 06:00:00	QQQ	ETF	163.06	163.41	163.04	163.39	4567.0
2018-04-24 06:30:00	QQQ	ETF	163.43	163.5	163.29	163.39	38700.0
2018-04-24 07:00:00	QQQ	ETF	163.36	163.36	162.97	162.97	112054.0
2018-04-24 07:30:00	QQQ	ETF	163.0	163.24	162.94	163.11	168162.0
2018-04-24 08:00:00	QQQ	ETF	163.06	163.24	162.96	162.98	271675.0
2018-04-24 08:30:00	QQQ	ETF	163.0	163.0	162.79	162.86	215363.0
2018-04-24 09:00:00	QQQ	ETF	162.86	162.88	162.58	162.6	411436.0
2018-04-24 09:30:00	QQQ	ETF	162.6	162.905	161.75	162.21	4051233.0
2018-04-24 10:00:00	QQQ	ETF	162.2	162.43	160.95	161.16	4328724.0
2018-04-24 10:30:00	QQQ	ETF	161.15	161.325	160.61	160.71	2895267.0
2018-04-24 11:00:00	QQQ	ETF	160.71	160.81	159.69	160.48	5738366.0
2018-04-24 11:30:00	QQQ	ETF	160.5	160.93	160.03	160.05	3101899.0
2018-04-24 12:00:00	QQQ	ETF	160.04	160.31	159.03	159.22	3702525.0
2018-04-24 12:30:00	QQQ	ETF	159.23	159.23	158.61	158.61	3861243.0

> showing 50 of 16,236 rows — these rows as CSV

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