PREVIEW / etf_30min / 2019-09-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-09.parquet
  size:    510 KB
  rows:    17,723

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-09 04:00:00	SPY	ETF	298.92	298.92	298.73	298.73	5734.0
2019-09-09 04:30:00	SPY	ETF	298.8	298.8	298.78	298.8	1650.0
2019-09-09 05:30:00	SPY	ETF	298.92	299.1	298.85	299.1	10250.0
2019-09-09 06:00:00	SPY	ETF	299.15	299.21	299.1	299.13	3137.0
2019-09-09 06:30:00	SPY	ETF	299.11	299.11	298.98	299.1	7021.0
2019-09-09 07:00:00	SPY	ETF	299.04	299.07	298.92	299.05	83116.0
2019-09-09 07:30:00	SPY	ETF	299.05	299.19	299.0	299.19	67240.0
2019-09-09 08:00:00	SPY	ETF	298.9999	299.32	298.85	299.3	82045.0
2019-09-09 08:30:00	SPY	ETF	299.28	299.3	299.21	299.25	67758.0
2019-09-09 09:00:00	SPY	ETF	299.22	299.35	299.03	299.12	230050.0
2019-09-09 09:30:00	SPY	ETF	299.14	299.24	298.3	298.32	5642113.0
2019-09-09 10:00:00	SPY	ETF	298.32	298.77	298.27	298.68	3541839.0
2019-09-09 10:30:00	SPY	ETF	298.686	298.89	298.56	298.84	2377276.0
2019-09-09 11:00:00	SPY	ETF	298.85	298.91	298.6175	298.69	2860554.0
2019-09-09 11:30:00	SPY	ETF	298.68	298.74	298.42	298.515	2895871.0
2019-09-09 12:00:00	SPY	ETF	298.52	298.56	297.67	297.75	4258160.0
2019-09-09 12:30:00	SPY	ETF	297.74	297.97	297.16	297.93	4432983.0
2019-09-09 13:00:00	SPY	ETF	297.92	297.99	297.56	297.6	1553515.0
2019-09-09 13:30:00	SPY	ETF	297.595	297.89	297.39	297.8	2499726.0
2019-09-09 14:00:00	SPY	ETF	297.8001	297.91	297.46	297.5	2046324.0
2019-09-09 14:30:00	SPY	ETF	297.49	297.7771	297.42	297.61	2793633.0
2019-09-09 15:00:00	SPY	ETF	297.6	298.11	297.48	297.97	3754639.0
2019-09-09 15:30:00	SPY	ETF	297.97	298.23	297.81	298.15	7487545.0
2019-09-09 16:00:00	SPY	ETF	298.14	298.22	297.99	298.03	3112212.0
2019-09-09 16:30:00	SPY	ETF	298.01	298.19	297.99	298.18	206924.0
2019-09-09 17:00:00	SPY	ETF	298.13	298.18	298.0	298.02	170810.0
2019-09-09 17:30:00	SPY	ETF	298.2	298.2	298.01	298.06	147344.0
2019-09-09 18:00:00	SPY	ETF	298.09	298.28	298.09	298.25	132717.0
2019-09-09 18:30:00	SPY	ETF	298.27	298.37	298.26	298.31	17341.0
2019-09-09 19:00:00	SPY	ETF	298.34	298.4	298.3	298.31	7080.0
2019-09-09 19:30:00	SPY	ETF	298.3	298.47	298.25	298.45	14136.0
2019-09-09 04:00:00	QQQ	ETF	192.09	192.1	191.88	191.91	28500.0
2019-09-09 04:30:00	QQQ	ETF	191.9	191.98	191.9	191.98	34750.0
2019-09-09 05:00:00	QQQ	ETF	191.98	192.0	191.98	192.0	3500.0
2019-09-09 05:30:00	QQQ	ETF	192.0	192.2	192.0	192.18	9000.0
2019-09-09 06:00:00	QQQ	ETF	192.15	192.22	192.15	192.19	4876.0
2019-09-09 06:30:00	QQQ	ETF	192.15	192.15	192.05	192.1	6620.0
2019-09-09 07:00:00	QQQ	ETF	192.05	192.07	191.98	192.04	160956.0
2019-09-09 07:30:00	QQQ	ETF	192.01	192.05	191.95	192.0	118641.0
2019-09-09 08:00:00	QQQ	ETF	192.01	192.19	191.95	192.16	32327.0
2019-09-09 08:30:00	QQQ	ETF	192.17	192.23	192.09	192.19	50809.0
2019-09-09 09:00:00	QQQ	ETF	192.19	192.32	192.11	192.18	96779.0
2019-09-09 09:30:00	QQQ	ETF	192.18	192.27	191.48	191.51	3050556.0
2019-09-09 10:00:00	QQQ	ETF	191.51	191.755	191.32	191.72	2542781.0
2019-09-09 10:30:00	QQQ	ETF	191.72	192.065	191.6	192.01	1259009.0
2019-09-09 11:00:00	QQQ	ETF	192.02	192.11	191.81	191.99	802636.0
2019-09-09 11:30:00	QQQ	ETF	191.98	192.03	191.6559	191.77	697611.0
2019-09-09 12:00:00	QQQ	ETF	191.78	191.81	190.83	190.89	1916571.0
2019-09-09 12:30:00	QQQ	ETF	190.89	191.03	190.302	190.98	1544949.0
2019-09-09 13:00:00	QQQ	ETF	190.98	191.07	190.62	190.63	869476.0

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

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