PREVIEW / etf_1hour / 2021-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-23.parquet
  size:    405 KB
  rows:    14,109

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-23 04:00:00	SPY	ETF	423.32	423.6	423.28	423.4	10991.0
2021-06-23 05:00:00	SPY	ETF	423.4	423.44	423.03	423.31	19844.0
2021-06-23 06:00:00	SPY	ETF	423.23	423.55	423.06	423.06	15057.0
2021-06-23 07:00:00	SPY	ETF	423.2	423.21	422.5	423.11	114345.0
2021-06-23 08:00:00	SPY	ETF	423.07	423.97	422.54	423.57	272236.0
2021-06-23 09:00:00	SPY	ETF	423.57	423.8	423.05	423.64	5032629.0
2021-06-23 10:00:00	SPY	ETF	423.64	424.05	423.26	423.58	5526353.0
2021-06-23 11:00:00	SPY	ETF	423.58	423.71	422.92	423.3	3656223.0
2021-06-23 12:00:00	SPY	ETF	423.29	423.46	422.69	423.145	3037259.0
2021-06-23 13:00:00	SPY	ETF	423.16	423.6	423.07	423.56	2623009.0
2021-06-23 14:00:00	SPY	ETF	423.56	423.5681	423.18	423.37	2923848.0
2021-06-23 15:00:00	SPY	ETF	423.37	423.82	422.51	422.6	10130371.0
2021-06-23 16:00:00	SPY	ETF	422.61	422.9	422.5749	422.82	3501483.0
2021-06-23 17:00:00	SPY	ETF	422.96	422.96	422.7	422.85	51581.0
2021-06-23 18:00:00	SPY	ETF	422.84	423.06	422.6	423.04	53770.0
2021-06-23 19:00:00	SPY	ETF	423.01	423.15	422.97	423.11	57973.0
2021-06-23 04:00:00	QQQ	ETF	347.78	347.93	347.54	347.6	17676.0
2021-06-23 05:00:00	QQQ	ETF	347.68	347.86	347.4	347.7	15095.0
2021-06-23 06:00:00	QQQ	ETF	347.7	348.06	347.58	347.78	18904.0
2021-06-23 07:00:00	QQQ	ETF	347.79	347.82	347.08	347.63	235650.0
2021-06-23 08:00:00	QQQ	ETF	347.6204	348.59	347.13	347.81	184232.0
2021-06-23 09:00:00	QQQ	ETF	347.88	348.83	347.42	348.69	3572276.0
2021-06-23 10:00:00	QQQ	ETF	348.69	348.92	347.7	347.98	3684523.0
2021-06-23 11:00:00	QQQ	ETF	347.98	348.27	347.34	348.19	2606637.0
2021-06-23 12:00:00	QQQ	ETF	348.1907	348.31	346.88	347.59	2443933.0
2021-06-23 13:00:00	QQQ	ETF	347.6	348.16	347.41	348.095	1636449.0
2021-06-23 14:00:00	QQQ	ETF	348.09	348.21	347.62	348.07	1683614.0
2021-06-23 15:00:00	QQQ	ETF	348.06	348.39	347.42	347.66	3492149.0
2021-06-23 16:00:00	QQQ	ETF	347.66	347.97	347.64	347.93	914408.0
2021-06-23 17:00:00	QQQ	ETF	347.86	347.91	347.79	347.9	15241.0
2021-06-23 18:00:00	QQQ	ETF	347.92	348.07	347.85	348.02	76080.0
2021-06-23 19:00:00	QQQ	ETF	348.07	348.2	347.91	348.18	32643.0
2021-06-23 04:00:00	IWM	ETF	228.24	228.27	228.0	228.0	9118.0
2021-06-23 05:00:00	IWM	ETF	227.91	227.96	227.75	227.88	17545.0
2021-06-23 06:00:00	IWM	ETF	227.78	228.0	227.54	227.54	10751.0
2021-06-23 07:00:00	IWM	ETF	227.62	227.71	227.26	227.67	176001.0
2021-06-23 08:00:00	IWM	ETF	227.5201	228.17	227.29	228.12	69424.0
2021-06-23 09:00:00	IWM	ETF	228.11	229.52	227.98	228.7	2111294.0
2021-06-23 10:00:00	IWM	ETF	228.71	229.65	228.52	229.18	2265269.0
2021-06-23 11:00:00	IWM	ETF	229.17	229.33	228.36	228.57	1560595.0
2021-06-23 12:00:00	IWM	ETF	228.57	229.475	228.46	229.11	1654903.0
2021-06-23 13:00:00	IWM	ETF	229.11	229.96	228.97	229.88	1749352.0
2021-06-23 14:00:00	IWM	ETF	229.865	229.89	229.25	229.43	1216780.0
2021-06-23 15:00:00	IWM	ETF	229.43	229.83	228.52	228.79	3242550.0
2021-06-23 16:00:00	IWM	ETF	228.79	228.94	228.66	228.9	2221811.0
2021-06-23 17:00:00	IWM	ETF	228.84	229.11	228.66	229.09	59121.0
2021-06-23 18:00:00	IWM	ETF	228.91	229.11	228.9	229.08	19127.0
2021-06-23 19:00:00	IWM	ETF	229.1	229.18	229.09	229.09	22755.0
2021-06-23 04:00:00	DIA	ETF	340.18	340.29	340.14	340.29	3007.0
2021-06-23 05:00:00	DIA	ETF	340.0	340.0	339.88	339.88	2000.0

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

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