PREVIEW / etf_1hour / 2021-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-16.parquet
  size:    415 KB
  rows:    14,283

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-04-16 04:00:00	SPY	ETF	415.46	415.6	415.28	415.6	11986.0
2021-04-16 05:00:00	SPY	ETF	415.55	416.21	415.55	416.1	11022.0
2021-04-16 06:00:00	SPY	ETF	416.06	416.2	415.98	416.08	33723.0
2021-04-16 07:00:00	SPY	ETF	416.02	416.5	415.98	416.48	166749.0
2021-04-16 08:00:00	SPY	ETF	416.47	416.87	415.3	416.85	266524.0
2021-04-16 09:00:00	SPY	ETF	416.85	417.39	415.91	416.1	6635957.0
2021-04-16 10:00:00	SPY	ETF	416.11	417.01	415.73	416.61	7994456.0
2021-04-16 11:00:00	SPY	ETF	416.6	417.0	416.19	416.4	4435235.0
2021-04-16 12:00:00	SPY	ETF	416.4	416.87	416.4	416.6	2944976.0
2021-04-16 13:00:00	SPY	ETF	416.61	416.8	416.43	416.5	3035280.0
2021-04-16 14:00:00	SPY	ETF	416.499	417.49	416.4	417.44	5781114.0
2021-04-16 15:00:00	SPY	ETF	417.44	417.91	417.1	417.3101	17644427.0
2021-04-16 16:00:00	SPY	ETF	417.32	417.35	416.74	416.82	6018666.0
2021-04-16 17:00:00	SPY	ETF	416.75	417.26	416.71	416.8	313342.0
2021-04-16 18:00:00	SPY	ETF	416.9	417.12	416.9	417.08	39419.0
2021-04-16 19:00:00	SPY	ETF	417.08	417.08	416.75	416.75	13964.0
2021-04-16 04:00:00	QQQ	ETF	340.56	340.97	340.5	340.62	34708.0
2021-04-16 05:00:00	QQQ	ETF	340.6	341.12	340.6	341.02	34196.0
2021-04-16 06:00:00	QQQ	ETF	341.04	341.36	340.91	341.23	29010.0
2021-04-16 07:00:00	QQQ	ETF	341.23	341.96	341.19	341.89	118599.0
2021-04-16 08:00:00	QQQ	ETF	341.2196	342.61	340.54	342.44	336211.0
2021-04-16 09:00:00	QQQ	ETF	342.39	342.39	340.08	340.34	4178673.0
2021-04-16 10:00:00	QQQ	ETF	340.34	341.9799	340.14	341.31	4359294.0
2021-04-16 11:00:00	QQQ	ETF	341.3	341.66	340.8701	341.38	2691320.0
2021-04-16 12:00:00	QQQ	ETF	341.42	342.12	341.27	341.785	2330383.0
2021-04-16 13:00:00	QQQ	ETF	341.795	341.96	341.2	341.2	2008233.0
2021-04-16 14:00:00	QQQ	ETF	341.2	342.03	341.14	341.97	2322344.0
2021-04-16 15:00:00	QQQ	ETF	341.97	342.23	341.69	341.99	4993074.0
2021-04-16 16:00:00	QQQ	ETF	341.97	342.35	341.56	341.82	2075132.0
2021-04-16 17:00:00	QQQ	ETF	341.81	342.01	341.81	341.85	264137.0
2021-04-16 18:00:00	QQQ	ETF	341.88	342.01	341.85	341.86	255158.0
2021-04-16 19:00:00	QQQ	ETF	341.91	341.91	341.74	341.74	14187.0
2021-04-16 04:00:00	IWM	ETF	224.25	224.52	224.25	224.5	2986.0
2021-04-16 05:00:00	IWM	ETF	224.46	225.0	224.46	224.85	7690.0
2021-04-16 06:00:00	IWM	ETF	224.85	224.95	224.8	224.82	22185.0
2021-04-16 07:00:00	IWM	ETF	224.76	225.1	224.59	224.98	34586.0
2021-04-16 08:00:00	IWM	ETF	224.69	225.14	224.02	224.86	50011.0
2021-04-16 09:00:00	IWM	ETF	224.84	225.678	223.42	223.53	3768008.0
2021-04-16 10:00:00	IWM	ETF	223.5	224.67	223.01	224.06	2664335.0
2021-04-16 11:00:00	IWM	ETF	224.05	224.73	223.73	223.96	1476076.0
2021-04-16 12:00:00	IWM	ETF	223.96	224.2	223.42	223.74	1258129.0
2021-04-16 13:00:00	IWM	ETF	223.73	224.32	223.5	224.21	1506387.0
2021-04-16 14:00:00	IWM	ETF	224.2018	225.06	224.08	225.03	1459475.0
2021-04-16 15:00:00	IWM	ETF	225.04	225.325	224.5	224.73	4102975.0
2021-04-16 16:00:00	IWM	ETF	224.7301	224.8	224.41	224.53	1281481.0
2021-04-16 17:00:00	IWM	ETF	224.43	224.65	224.23	224.5	83845.0
2021-04-16 18:00:00	IWM	ETF	224.62	224.74	224.62	224.65	640584.0
2021-04-16 19:00:00	IWM	ETF	224.69	224.74	224.6	224.74	9294.0
2021-04-16 05:00:00	DIA	ETF	340.74	340.74	340.74	340.74	100.0
2021-04-16 07:00:00	DIA	ETF	340.67	340.73	340.67	340.72	2555.0

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

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