PREVIEW / etf_1hour / 2020-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-03.parquet
  size:    396 KB
  rows:    13,297

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-03-03 04:00:00	SPY	ETF	308.71	310.0	308.18	309.75	121674.0
2020-03-03 05:00:00	SPY	ETF	310.09	310.1	309.19	309.38	58819.0
2020-03-03 06:00:00	SPY	ETF	309.52	309.52	307.57	307.98	284239.0
2020-03-03 07:00:00	SPY	ETF	307.8	309.78	305.35	306.76	2285156.0
2020-03-03 08:00:00	SPY	ETF	306.73	310.0	304.8	307.69	2832473.0
2020-03-03 09:00:00	SPY	ETF	307.71	309.7	304.9	305.94	20025576.0
2020-03-03 10:00:00	SPY	ETF	305.94	313.84	305.82	310.42	58815750.0
2020-03-03 11:00:00	SPY	ETF	310.38	310.66	302.54	307.32	41297660.0
2020-03-03 12:00:00	SPY	ETF	307.32	308.26	304.57	305.12	17324373.0
2020-03-03 13:00:00	SPY	ETF	305.12	305.89	300.03	300.21	28217698.0
2020-03-03 14:00:00	SPY	ETF	300.19	303.0	297.57	301.35	47519093.0
2020-03-03 15:00:00	SPY	ETF	301.37	304.24	299.29	300.34	59307864.0
2020-03-03 16:00:00	SPY	ETF	300.37	302.07	299.24	299.24	17373255.0
2020-03-03 17:00:00	SPY	ETF	299.24	300.24	298.8	298.94	1224357.0
2020-03-03 18:00:00	SPY	ETF	298.95	309.0078	298.0	299.34	536880.0
2020-03-03 19:00:00	SPY	ETF	299.29	303.0	299.29	302.17	739223.0
2020-03-03 04:00:00	QQQ	ETF	216.24	217.2	215.8	217.05	126608.0
2020-03-03 05:00:00	QQQ	ETF	216.93	217.3	216.59	217.16	97193.0
2020-03-03 06:00:00	QQQ	ETF	216.99	217.0	215.64	216.05	300105.0
2020-03-03 07:00:00	QQQ	ETF	215.89	217.5	214.5	215.43	1377139.0
2020-03-03 08:00:00	QQQ	ETF	215.39	217.13	213.2	215.87	1863397.0
2020-03-03 09:00:00	QQQ	ETF	215.78	217.29	213.3	214.1309	12437827.0
2020-03-03 10:00:00	QQQ	ETF	214.14	219.61	214.06	217.83	24495512.0
2020-03-03 11:00:00	QQQ	ETF	217.8	217.99	212.32	215.46	13689944.0
2020-03-03 12:00:00	QQQ	ETF	215.43	216.18	213.36	213.78	8450817.0
2020-03-03 13:00:00	QQQ	ETF	213.78	213.78	209.45	209.55	10658918.0
2020-03-03 14:00:00	QQQ	ETF	209.57	210.58	207.62	210.24	14693586.0
2020-03-03 15:00:00	QQQ	ETF	210.28	212.34	208.86	209.62	20068820.0
2020-03-03 16:00:00	QQQ	ETF	209.66	211.05	208.76	208.84	2630868.0
2020-03-03 17:00:00	QQQ	ETF	208.66	208.97	208.35	208.4	55908.0
2020-03-03 18:00:00	QQQ	ETF	208.5	209.2	207.61	208.89	312030.0
2020-03-03 19:00:00	QQQ	ETF	208.88	211.3	208.86	210.98	370978.0
2020-03-03 04:00:00	IWM	ETF	151.14	151.79	151.14	151.79	5303.0
2020-03-03 05:00:00	IWM	ETF	152.0	152.0	151.58	151.6	2600.0
2020-03-03 06:00:00	IWM	ETF	151.1	151.1	150.44	150.52	32266.0
2020-03-03 07:00:00	IWM	ETF	150.5	151.08	149.58	150.31	131036.0
2020-03-03 08:00:00	IWM	ETF	149.98	150.7	149.2401	150.41	184535.0
2020-03-03 09:00:00	IWM	ETF	150.24	151.23	149.81	150.34	3159894.0
2020-03-03 10:00:00	IWM	ETF	150.34	154.2	150.31	152.29	9298818.0
2020-03-03 11:00:00	IWM	ETF	152.25	152.44	148.99	150.78	3782940.0
2020-03-03 12:00:00	IWM	ETF	150.75	151.28	149.62	149.72	2043387.0
2020-03-03 13:00:00	IWM	ETF	149.7	149.7	147.4	147.47	3847459.0
2020-03-03 14:00:00	IWM	ETF	147.47	148.44	146.31	148.31	4189530.0
2020-03-03 15:00:00	IWM	ETF	148.32	149.41	147.47	147.99	5806196.0
2020-03-03 16:00:00	IWM	ETF	148.0	148.7414	147.01	147.06	2132089.0
2020-03-03 17:00:00	IWM	ETF	147.15	147.26	146.6	146.93	24113.0
2020-03-03 18:00:00	IWM	ETF	146.93	147.39	146.61	147.17	15534.0
2020-03-03 19:00:00	IWM	ETF	147.3	148.78	147.3	148.66	24436.0
2020-03-03 04:00:00	DIA	ETF	266.6	268.16	266.6	267.75	5415.0
2020-03-03 05:00:00	DIA	ETF	267.64	268.1	267.46	267.66	10943.0

> showing 50 of 13,297 rows — these rows as CSV

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