PREVIEW / etf_30min / 2019-09-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-16.parquet
  size:    513 KB
  rows:    17,812

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-09-16 04:00:00	SPY	ETF	299.69	299.98	299.58	299.86	12401.0
2019-09-16 04:30:00	SPY	ETF	299.9	299.9	299.7	299.7	6130.0
2019-09-16 05:00:00	SPY	ETF	299.58	299.76	299.3	299.76	26799.0
2019-09-16 05:30:00	SPY	ETF	299.83	299.83	299.44	299.62	11393.0
2019-09-16 06:00:00	SPY	ETF	299.72	299.86	299.68	299.68	2760.0
2019-09-16 06:30:00	SPY	ETF	299.65	299.83	299.53	299.79	69511.0
2019-09-16 07:00:00	SPY	ETF	299.8	299.91	299.54	299.77	209502.0
2019-09-16 07:30:00	SPY	ETF	299.77	300.07	299.74	300.0	200627.0
2019-09-16 08:00:00	SPY	ETF	299.84	300.22	299.0	300.03	334342.0
2019-09-16 08:30:00	SPY	ETF	300.03	300.1	299.915	299.915	189685.0
2019-09-16 09:00:00	SPY	ETF	299.93	299.94	299.75	299.79	281009.0
2019-09-16 09:30:00	SPY	ETF	299.84	300.56	299.7	300.51	5768098.0
2019-09-16 10:00:00	SPY	ETF	300.5	300.65	300.07	300.09	2827124.0
2019-09-16 10:30:00	SPY	ETF	300.1	300.22	299.79	300.0001	2650081.0
2019-09-16 11:00:00	SPY	ETF	300.025	300.555	299.9	300.36	2764609.0
2019-09-16 11:30:00	SPY	ETF	300.35	300.4	299.45	299.53	3408794.0
2019-09-16 12:00:00	SPY	ETF	299.53	299.88	299.48	299.81	2637991.0
2019-09-16 12:30:00	SPY	ETF	299.82	300.02	299.58	299.89	5802696.0
2019-09-16 13:00:00	SPY	ETF	299.895	300.16	299.79	300.09	2359717.0
2019-09-16 13:30:00	SPY	ETF	300.08	301.1378	299.96	300.26	2571822.0
2019-09-16 14:00:00	SPY	ETF	300.26	300.38	300.03	300.28	3334951.0
2019-09-16 14:30:00	SPY	ETF	300.28	300.295	300.085	300.24	2485289.0
2019-09-16 15:00:00	SPY	ETF	300.24	301.1378	300.02	300.0789	4577621.0
2019-09-16 15:30:00	SPY	ETF	300.08	300.31	299.97	300.16	6590605.0
2019-09-16 16:00:00	SPY	ETF	300.18	300.5	300.14	300.28	4502838.0
2019-09-16 16:30:00	SPY	ETF	300.28	300.58	300.1978	300.58	2129394.0
2019-09-16 17:00:00	SPY	ETF	300.52	300.6	300.4	300.44	198667.0
2019-09-16 17:30:00	SPY	ETF	300.44	300.49	300.41	300.49	39447.0
2019-09-16 18:00:00	SPY	ETF	300.49	300.8	300.49	300.72	150822.0
2019-09-16 18:30:00	SPY	ETF	300.71	300.71	300.41	300.57	53832.0
2019-09-16 19:00:00	SPY	ETF	300.57	300.69	300.49	300.69	21505.0
2019-09-16 19:30:00	SPY	ETF	300.68	300.74	300.5	300.5	17831.0
2019-09-16 04:00:00	QQQ	ETF	191.64	191.64	191.05	191.2	26123.0
2019-09-16 04:30:00	QQQ	ETF	191.18	191.18	190.95	191.04	11449.0
2019-09-16 05:00:00	QQQ	ETF	191.04	191.26	190.75	191.25	7375.0
2019-09-16 05:30:00	QQQ	ETF	191.1	191.15	190.9	191.1	33505.0
2019-09-16 06:00:00	QQQ	ETF	191.09	191.28	191.05	191.18	19550.0
2019-09-16 06:30:00	QQQ	ETF	191.2	191.29	191.06	191.22	8160.0
2019-09-16 07:00:00	QQQ	ETF	191.26	191.34	190.94	191.11	47411.0
2019-09-16 07:30:00	QQQ	ETF	191.1	191.31	191.09	191.31	35794.0
2019-09-16 08:00:00	QQQ	ETF	191.25	191.56	190.55	191.44	120237.0
2019-09-16 08:30:00	QQQ	ETF	191.4	191.46	191.21	191.22	50436.0
2019-09-16 09:00:00	QQQ	ETF	191.24	191.41	191.15	191.3	59202.0
2019-09-16 09:30:00	QQQ	ETF	191.3	192.05	191.14	192.002	2434132.0
2019-09-16 10:00:00	QQQ	ETF	192.0	192.08	191.59	191.6	931760.0
2019-09-16 10:30:00	QQQ	ETF	191.61	191.75	191.27	191.45	1581225.0
2019-09-16 11:00:00	QQQ	ETF	191.46	191.94	191.33	191.78	836424.0
2019-09-16 11:30:00	QQQ	ETF	191.77	191.83	191.12	191.16	1101361.0
2019-09-16 12:00:00	QQQ	ETF	191.14	191.39	191.11	191.355	936409.0
2019-09-16 12:30:00	QQQ	ETF	191.36	191.45	191.13	191.3098	986249.0

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

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