PREVIEW / etf_1hour / 2020-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-25.parquet
  size:    365 KB
  rows:    12,411

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
2020-09-25 04:00:00	SPY	ETF	323.8	323.99	323.26	323.95	35521.0
2020-09-25 05:00:00	SPY	ETF	324.12	324.21	322.5	323.04	61807.0
2020-09-25 06:00:00	SPY	ETF	322.98	323.24	321.17	321.26	120798.0
2020-09-25 07:00:00	SPY	ETF	321.29	322.76	320.66	322.67	576824.0
2020-09-25 08:00:00	SPY	ETF	321.0	325.4	320.81	323.07	499661.0
2020-09-25 09:00:00	SPY	ETF	323.05	323.69	322.15	323.52	7014144.0
2020-09-25 10:00:00	SPY	ETF	323.515	325.29	321.64	324.82	10075848.0
2020-09-25 11:00:00	SPY	ETF	324.82	325.86	324.21	324.33	6534071.0
2020-09-25 12:00:00	SPY	ETF	324.33	325.81	324.3299	325.68	5333895.0
2020-09-25 13:00:00	SPY	ETF	325.69	327.11	325.415	326.92	6296607.0
2020-09-25 14:00:00	SPY	ETF	326.92	328.14	326.86	328.09	6507249.0
2020-09-25 15:00:00	SPY	ETF	328.08	329.58	328.0	328.69	18018508.0
2020-09-25 16:00:00	SPY	ETF	328.69	328.94	328.3	328.49	8169219.0
2020-09-25 17:00:00	SPY	ETF	328.46	328.73	328.29	328.29	559217.0
2020-09-25 18:00:00	SPY	ETF	328.35	328.36	328.08	328.3	36596.0
2020-09-25 19:00:00	SPY	ETF	328.25	328.38	328.03	328.06	36281.0
2020-09-25 04:00:00	QQQ	ETF	265.6	265.96	264.97	265.96	54988.0
2020-09-25 05:00:00	QQQ	ETF	266.0	266.04	264.62	265.15	20422.0
2020-09-25 06:00:00	QQQ	ETF	265.08	265.55	263.92	264.21	54236.0
2020-09-25 07:00:00	QQQ	ETF	264.21	266.0	263.92	265.73	302512.0
2020-09-25 08:00:00	QQQ	ETF	264.2199	267.24	263.9001	266.29	614424.0
2020-09-25 09:00:00	QQQ	ETF	266.26	266.79	264.2999	266.08	4512287.0
2020-09-25 10:00:00	QQQ	ETF	266.06	268.079	264.35	267.58	5585885.0
2020-09-25 11:00:00	QQQ	ETF	267.61	269.17	267.09	267.57	4283912.0
2020-09-25 12:00:00	QQQ	ETF	267.56	269.18	267.55	268.735	3153538.0
2020-09-25 13:00:00	QQQ	ETF	268.75	270.0	268.47	269.93	3371724.0
2020-09-25 14:00:00	QQQ	ETF	269.91	271.11	269.8	270.9799	3875079.0
2020-09-25 15:00:00	QQQ	ETF	270.96	272.395	270.86	271.62	9840388.0
2020-09-25 16:00:00	QQQ	ETF	271.6	271.9	271.43	271.54	2505236.0
2020-09-25 17:00:00	QQQ	ETF	271.63	271.68	271.13	271.19	126365.0
2020-09-25 18:00:00	QQQ	ETF	271.13	271.2	270.88	271.2	27627.0
2020-09-25 19:00:00	QQQ	ETF	271.14	271.2	271.0	271.01	18960.0
2020-09-25 04:00:00	IWM	ETF	144.54	144.54	144.09	144.32	938.0
2020-09-25 05:00:00	IWM	ETF	144.45	144.45	143.66	143.66	8309.0
2020-09-25 06:00:00	IWM	ETF	143.8	143.81	142.62	142.62	26593.0
2020-09-25 07:00:00	IWM	ETF	142.77	143.5	142.33	143.44	138445.0
2020-09-25 08:00:00	IWM	ETF	142.3699	144.69	142.3699	143.71	119534.0
2020-09-25 09:00:00	IWM	ETF	143.75	145.07	143.35	145.03	2369756.0
2020-09-25 10:00:00	IWM	ETF	145.03	145.8022	144.42	145.27	3685520.0
2020-09-25 11:00:00	IWM	ETF	145.28	145.46	144.58	144.67	1332415.0
2020-09-25 12:00:00	IWM	ETF	144.66	145.75	144.66	145.65	826731.0
2020-09-25 13:00:00	IWM	ETF	145.64	146.0461	145.55	145.93	1221739.0
2020-09-25 14:00:00	IWM	ETF	145.92	146.36	145.825	146.33	1680223.0
2020-09-25 15:00:00	IWM	ETF	146.33	146.85	146.1	146.4	3969973.0
2020-09-25 16:00:00	IWM	ETF	146.41	146.6	146.06	146.1	939651.0
2020-09-25 17:00:00	IWM	ETF	146.15	146.24	145.91	146.05	7634.0
2020-09-25 18:00:00	IWM	ETF	146.09	146.23	146.09	146.23	9140.0
2020-09-25 19:00:00	IWM	ETF	146.24	146.24	146.09	146.09	8901.0
2020-09-25 04:00:00	DIA	ETF	268.61	268.61	268.61	268.61	100.0
2020-09-25 05:00:00	DIA	ETF	268.01	268.09	267.95	267.95	300.0

> showing 50 of 12,411 rows — these rows as CSV

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