PREVIEW / etf_30min / 2019-09-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-26.parquet
  size:    495 KB
  rows:    17,261

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-26 04:00:00	SPY	ETF	297.83	297.86	297.73	297.83	11204.0
2019-09-26 04:30:00	SPY	ETF	297.77	298.5	297.77	298.16	27207.0
2019-09-26 05:00:00	SPY	ETF	298.2	298.28	298.18	298.18	4072.0
2019-09-26 05:30:00	SPY	ETF	298.18	298.23	298.07	298.07	5000.0
2019-09-26 06:00:00	SPY	ETF	298.11	298.24	298.08	298.15	1766.0
2019-09-26 06:30:00	SPY	ETF	298.1	298.16	298.0	298.16	3875.0
2019-09-26 07:00:00	SPY	ETF	298.1	298.31	298.03	298.28	39346.0
2019-09-26 07:30:00	SPY	ETF	298.25	298.34	298.2	298.32	58564.0
2019-09-26 08:00:00	SPY	ETF	298.1501	298.34	297.03	298.26	95275.0
2019-09-26 08:30:00	SPY	ETF	298.2	298.25	297.65	298.0	295373.0
2019-09-26 09:00:00	SPY	ETF	297.98	298.03	297.48	297.64	178443.0
2019-09-26 09:30:00	SPY	ETF	297.63	297.65	296.53	296.75	5161442.0
2019-09-26 10:00:00	SPY	ETF	296.75	297.21	296.27	296.74	3941600.0
2019-09-26 10:30:00	SPY	ETF	296.75	297.08	296.26	296.56	3711276.0
2019-09-26 11:00:00	SPY	ETF	296.56	296.57	295.45	295.88	4689919.0
2019-09-26 11:30:00	SPY	ETF	295.89	296.24	295.57	295.845	2315093.0
2019-09-26 12:00:00	SPY	ETF	295.845	296.76	295.61	296.67	3412498.0
2019-09-26 12:30:00	SPY	ETF	296.66	296.83	296.34	296.6	2769439.0
2019-09-26 13:00:00	SPY	ETF	296.61	296.74	296.11	296.23	1777418.0
2019-09-26 13:30:00	SPY	ETF	296.22	296.88	296.17	296.87	2393778.0
2019-09-26 14:00:00	SPY	ETF	296.88	297.54	296.87	297.23	4186198.0
2019-09-26 14:30:00	SPY	ETF	297.23	297.41	296.9	296.96	2257088.0
2019-09-26 15:00:00	SPY	ETF	296.96	297.72	296.95	297.55	4585376.0
2019-09-26 15:30:00	SPY	ETF	297.53	297.86	296.7	296.97	8593379.0
2019-09-26 16:00:00	SPY	ETF	296.98	297.24	296.8564	297.03	4943420.0
2019-09-26 16:30:00	SPY	ETF	297.01	297.01	296.87	296.94	127112.0
2019-09-26 17:00:00	SPY	ETF	296.96	296.99	296.85	296.9	2266690.0
2019-09-26 17:30:00	SPY	ETF	296.88	297.0	296.84	296.84	43282.0
2019-09-26 18:00:00	SPY	ETF	296.98	297.26	296.98	297.09	49338.0
2019-09-26 18:30:00	SPY	ETF	297.13	297.19	297.08	297.08	35850.0
2019-09-26 19:00:00	SPY	ETF	297.1	297.1	297.01	297.01	9025.0
2019-09-26 19:30:00	SPY	ETF	297.07	297.16	296.8	296.84	26828.0
2019-09-26 04:00:00	QQQ	ETF	190.0	190.05	189.95	190.05	3267.0
2019-09-26 04:30:00	QQQ	ETF	190.0	190.5	190.0	190.27	4100.0
2019-09-26 05:00:00	QQQ	ETF	190.33	190.4	190.25	190.25	7567.0
2019-09-26 05:30:00	QQQ	ETF	190.25	190.28	190.13	190.17	4207.0
2019-09-26 06:00:00	QQQ	ETF	190.25	190.25	190.2	190.22	2704.0
2019-09-26 06:30:00	QQQ	ETF	190.18	190.24	190.06	190.19	6705.0
2019-09-26 07:00:00	QQQ	ETF	190.18	190.3	190.07	190.3	11706.0
2019-09-26 07:30:00	QQQ	ETF	190.35	190.37	190.28	190.36	24193.0
2019-09-26 08:00:00	QQQ	ETF	190.14	190.38	189.56	190.34	117762.0
2019-09-26 08:30:00	QQQ	ETF	190.3	190.31	189.84	190.14	233656.0
2019-09-26 09:00:00	QQQ	ETF	190.15	190.17	189.72	189.89	255969.0
2019-09-26 09:30:00	QQQ	ETF	189.87	189.87	188.75	188.91	2977256.0
2019-09-26 10:00:00	QQQ	ETF	188.9166	189.32	188.55	189.08	1741005.0
2019-09-26 10:30:00	QQQ	ETF	189.07	189.48	188.69	188.88	1956563.0
2019-09-26 11:00:00	QQQ	ETF	188.87	188.92	187.98	188.3438	2721813.0
2019-09-26 11:30:00	QQQ	ETF	188.35	188.64	188.14	188.42	1496295.0
2019-09-26 12:00:00	QQQ	ETF	188.42	189.14	188.19	189.01	1736868.0
2019-09-26 12:30:00	QQQ	ETF	189.01	189.03	188.6	188.79	1309870.0

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

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