PREVIEW / etf_1hour / 2021-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-07.parquet
  size:    403 KB
  rows:    14,284

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
2021-06-07 04:00:00	SPY	ETF	421.85	422.14	421.63	422.14	12368.0
2021-06-07 05:00:00	SPY	ETF	422.12	422.12	421.45	421.71	10000.0
2021-06-07 06:00:00	SPY	ETF	421.66	422.14	421.66	421.99	35603.0
2021-06-07 07:00:00	SPY	ETF	422.02	422.72	422.02	422.57	121522.0
2021-06-07 08:00:00	SPY	ETF	422.6	422.99	421.6	422.88	187638.0
2021-06-07 09:00:00	SPY	ETF	422.87	422.87	421.93	422.19	4214884.0
2021-06-07 10:00:00	SPY	ETF	422.2	422.2	421.29	421.725	4850352.0
2021-06-07 11:00:00	SPY	ETF	421.73	421.91	421.24	421.52	4538899.0
2021-06-07 12:00:00	SPY	ETF	421.515	421.82	421.43	421.6733	2610875.0
2021-06-07 13:00:00	SPY	ETF	421.675	421.8	421.19	421.235	3374993.0
2021-06-07 14:00:00	SPY	ETF	421.237	421.965	421.2	421.83	3017744.0
2021-06-07 15:00:00	SPY	ETF	421.82	422.4	421.802	422.22	10044054.0
2021-06-07 16:00:00	SPY	ETF	422.23	422.5	422.19	422.42	3384596.0
2021-06-07 17:00:00	SPY	ETF	422.33	422.58	422.32	422.44	69145.0
2021-06-07 18:00:00	SPY	ETF	422.44	422.5	422.19	422.25	81234.0
2021-06-07 19:00:00	SPY	ETF	422.25	422.62	422.22	422.28	54047.0
2021-06-07 04:00:00	QQQ	ETF	335.0	335.0	334.31	334.78	33706.0
2021-06-07 05:00:00	QQQ	ETF	334.73	334.76	333.88	334.19	36026.0
2021-06-07 06:00:00	QQQ	ETF	334.12	334.61	334.1	334.31	52599.0
2021-06-07 07:00:00	QQQ	ETF	334.35	335.49	334.3	335.35	221778.0
2021-06-07 08:00:00	QQQ	ETF	334.51	335.851	334.3104	335.45	223215.0
2021-06-07 09:00:00	QQQ	ETF	335.47	335.61	334.56	335.37	3375433.0
2021-06-07 10:00:00	QQQ	ETF	335.37	335.44	334.34	335.31	3252238.0
2021-06-07 11:00:00	QQQ	ETF	335.31	335.33	334.47	335.03	5365495.0
2021-06-07 12:00:00	QQQ	ETF	335.04	335.59	335.03	335.45	2718942.0
2021-06-07 13:00:00	QQQ	ETF	335.45	335.63	334.84	334.98	2032139.0
2021-06-07 14:00:00	QQQ	ETF	334.99	336.12	334.96	335.95	1560566.0
2021-06-07 15:00:00	QQQ	ETF	335.94	336.66	335.8993	336.51	4157604.0
2021-06-07 16:00:00	QQQ	ETF	336.53	337.04	336.51	336.97	1945719.0
2021-06-07 17:00:00	QQQ	ETF	337.05	337.05	336.58	336.82	97090.0
2021-06-07 18:00:00	QQQ	ETF	336.82	337.09	336.78	336.84	94935.0
2021-06-07 19:00:00	QQQ	ETF	336.9	337.3	336.88	337.0	68802.0
2021-06-07 04:00:00	IWM	ETF	226.63	226.83	226.56	226.83	2776.0
2021-06-07 05:00:00	IWM	ETF	226.68	226.69	226.5	226.66	6900.0
2021-06-07 06:00:00	IWM	ETF	226.56	227.07	226.56	227.05	7977.0
2021-06-07 07:00:00	IWM	ETF	227.17	227.43	227.11	227.43	26981.0
2021-06-07 08:00:00	IWM	ETF	227.28	227.8	227.2601	227.8	94009.0
2021-06-07 09:00:00	IWM	ETF	227.81	229.2	227.75	229.13	2723170.0
2021-06-07 10:00:00	IWM	ETF	229.13	229.3799	228.67	229.34	2248389.0
2021-06-07 11:00:00	IWM	ETF	229.35	230.17	229.14	230.06	2464854.0
2021-06-07 12:00:00	IWM	ETF	230.0601	230.615	229.97	230.615	1379538.0
2021-06-07 13:00:00	IWM	ETF	230.62	230.75	230.2	230.2	1895873.0
2021-06-07 14:00:00	IWM	ETF	230.21	230.54	229.9	230.1675	1775960.0
2021-06-07 15:00:00	IWM	ETF	230.165	230.775	230.15	230.47	3803618.0
2021-06-07 16:00:00	IWM	ETF	230.45	230.79	230.42	230.64	1887234.0
2021-06-07 17:00:00	IWM	ETF	230.8	230.8	230.38	230.65	186210.0
2021-06-07 18:00:00	IWM	ETF	230.7	230.7	230.5	230.58	17194.0
2021-06-07 19:00:00	IWM	ETF	230.6	230.8	230.57	230.62	28969.0
2021-06-07 04:00:00	DIA	ETF	347.74	347.74	347.74	347.74	100.0
2021-06-07 05:00:00	DIA	ETF	347.66	347.89	347.66	347.89	950.0

> showing 50 of 14,284 rows — these rows as CSV

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