PREVIEW / etf_30min / 2019-11-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-06.parquet
  size:    504 KB
  rows:    17,679

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
2019-11-06 04:00:00	SPY	ETF	307.21	307.23	307.0	307.01	9450.0
2019-11-06 04:30:00	SPY	ETF	306.96	306.97	306.56	306.72	4260.0
2019-11-06 05:00:00	SPY	ETF	306.67	306.86	306.67	306.86	31110.0
2019-11-06 05:30:00	SPY	ETF	306.89	306.92	306.87	306.9	2629.0
2019-11-06 06:00:00	SPY	ETF	306.89	306.97	306.89	306.97	4212.0
2019-11-06 06:30:00	SPY	ETF	306.95	307.0	306.82	306.9	21451.0
2019-11-06 07:00:00	SPY	ETF	306.92	307.27	306.92	307.2	34586.0
2019-11-06 07:30:00	SPY	ETF	307.2	307.21	307.1	307.18	44639.0
2019-11-06 08:00:00	SPY	ETF	306.94	307.3	306.89	307.24	159484.0
2019-11-06 08:30:00	SPY	ETF	307.2	307.41	307.13	307.3	118178.0
2019-11-06 09:00:00	SPY	ETF	307.25	307.29	307.02	307.02	181180.0
2019-11-06 09:30:00	SPY	ETF	307.03	307.07	306.4501	306.955	3367328.0
2019-11-06 10:00:00	SPY	ETF	306.96	307.18	306.85	306.9	2640255.0
2019-11-06 10:30:00	SPY	ETF	306.89	307.015	306.74	306.78	2146404.0
2019-11-06 11:00:00	SPY	ETF	306.78	307.0	306.74	306.88	1429483.0
2019-11-06 11:30:00	SPY	ETF	306.88	307.4	306.06	306.36	7982425.0
2019-11-06 12:00:00	SPY	ETF	306.36	306.69	306.32	306.3466	2239370.0
2019-11-06 12:30:00	SPY	ETF	306.35	306.62	306.32	306.48	1224750.0
2019-11-06 13:00:00	SPY	ETF	306.4741	306.87	306.3	306.825	2482638.0
2019-11-06 13:30:00	SPY	ETF	306.83	307.155	306.7195	307.1	2038842.0
2019-11-06 14:00:00	SPY	ETF	307.1	307.16	306.86	307.01	1748316.0
2019-11-06 14:30:00	SPY	ETF	307.01	307.08	306.89	307.045	1419636.0
2019-11-06 15:00:00	SPY	ETF	307.045	307.19	306.87	307.031	2923809.0
2019-11-06 15:30:00	SPY	ETF	307.04	307.19	306.86	307.14	7097639.0
2019-11-06 16:00:00	SPY	ETF	307.14	307.34	307.07	307.3	5657013.0
2019-11-06 16:30:00	SPY	ETF	307.3	307.5	307.1756	307.43	375743.0
2019-11-06 17:00:00	SPY	ETF	307.47	307.47	307.1	307.41	107489.0
2019-11-06 17:30:00	SPY	ETF	307.4	307.43	307.34	307.43	14256.0
2019-11-06 18:00:00	SPY	ETF	307.44	307.46	307.22	307.22	34136.0
2019-11-06 18:30:00	SPY	ETF	307.25	307.26	307.15	307.15	16260.0
2019-11-06 19:00:00	SPY	ETF	307.17	307.23	307.13	307.23	13601.0
2019-11-06 19:30:00	SPY	ETF	307.24	307.3	307.16	307.18	19780.0
2019-11-06 04:00:00	QQQ	ETF	200.2	200.24	200.14	200.21	7500.0
2019-11-06 04:30:00	QQQ	ETF	200.18	200.18	199.84	199.84	8480.0
2019-11-06 05:00:00	QQQ	ETF	199.88	200.01	199.88	200.01	2270.0
2019-11-06 05:30:00	QQQ	ETF	200.04	200.06	200.01	200.06	1500.0
2019-11-06 06:00:00	QQQ	ETF	200.05	200.08	200.0	200.08	10317.0
2019-11-06 06:30:00	QQQ	ETF	200.08	200.08	199.91	200.0	7866.0
2019-11-06 07:00:00	QQQ	ETF	200.04	200.22	200.03	200.18	15480.0
2019-11-06 07:30:00	QQQ	ETF	200.12	200.2	200.12	200.18	6170.0
2019-11-06 08:00:00	QQQ	ETF	200.0401	200.36	200.0401	200.28	44413.0
2019-11-06 08:30:00	QQQ	ETF	200.2	200.33	200.16	200.23	259464.0
2019-11-06 09:00:00	QQQ	ETF	200.23	200.23	199.99	199.99	42928.0
2019-11-06 09:30:00	QQQ	ETF	199.98	200.0	199.46	199.7	2316266.0
2019-11-06 10:00:00	QQQ	ETF	199.71	199.82	199.38	199.39	1032463.0
2019-11-06 10:30:00	QQQ	ETF	199.39	199.54	199.2001	199.27	1818963.0
2019-11-06 11:00:00	QQQ	ETF	199.26	199.48	199.2	199.41	602345.0
2019-11-06 11:30:00	QQQ	ETF	199.41	199.87	198.785	199.036	2537375.0
2019-11-06 12:00:00	QQQ	ETF	199.07	199.31	198.99	199.1	969072.0
2019-11-06 12:30:00	QQQ	ETF	199.1	199.29	199.08	199.21	356447.0

> showing 50 of 17,679 rows — these rows as CSV

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