PREVIEW / etf_1hour / 2021-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-28.parquet
  size:    442 KB
  rows:    15,632

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-12-28 04:00:00	SPY	ETF	477.81	478.47	477.69	478.4	31722.0
2021-12-28 05:00:00	SPY	ETF	478.46	478.69	478.3	478.3	13386.0
2021-12-28 06:00:00	SPY	ETF	478.49	478.52	478.17	478.2	13237.0
2021-12-28 07:00:00	SPY	ETF	478.24	478.66	478.14	478.5	49010.0
2021-12-28 08:00:00	SPY	ETF	478.41	478.68	476.95	477.91	175897.0
2021-12-28 09:00:00	SPY	ETF	477.99	478.81	477.23	478.47	4316151.0
2021-12-28 10:00:00	SPY	ETF	478.4911	478.75	477.11	477.84	4722619.0
2021-12-28 11:00:00	SPY	ETF	477.84	478.16	477.17	478.05	3768306.0
2021-12-28 12:00:00	SPY	ETF	478.05	478.09	476.06	476.77	3283557.0
2021-12-28 13:00:00	SPY	ETF	476.77	477.19	476.44	477.17	1992317.0
2021-12-28 14:00:00	SPY	ETF	477.17	477.17	476.24	476.99	2661518.0
2021-12-28 15:00:00	SPY	ETF	477.0	477.7	476.44	476.8901	8386364.0
2021-12-28 16:00:00	SPY	ETF	476.89	477.43	476.7109	477.02	2138857.0
2021-12-28 17:00:00	SPY	ETF	477.02	477.05	476.86	477.02	55374.0
2021-12-28 18:00:00	SPY	ETF	477.02	477.63	476.87	477.52	86815.0
2021-12-28 19:00:00	SPY	ETF	477.59	477.64	477.33	477.58	26479.0
2021-12-28 04:00:00	QQQ	ETF	404.46	405.29	404.45	405.25	71896.0
2021-12-28 05:00:00	QQQ	ETF	405.31	405.64	405.29	405.49	30029.0
2021-12-28 06:00:00	QQQ	ETF	405.54	405.54	405.13	405.25	14904.0
2021-12-28 07:00:00	QQQ	ETF	405.2	405.71	405.0	405.36	102047.0
2021-12-28 08:00:00	QQQ	ETF	405.0001	405.6296	403.22	404.57	174035.0
2021-12-28 09:00:00	QQQ	ETF	404.66	404.73	402.4	403.7499	4737625.0
2021-12-28 10:00:00	QQQ	ETF	403.73	403.98	401.685	402.98	5213906.0
2021-12-28 11:00:00	QQQ	ETF	403.0	403.48	401.77	403.17	2748739.0
2021-12-28 12:00:00	QQQ	ETF	403.18	403.31	401.08	401.88	2470839.0
2021-12-28 13:00:00	QQQ	ETF	401.84	402.1	401.131	401.6982	1928052.0
2021-12-28 14:00:00	QQQ	ETF	401.67	401.9478	400.71	401.72	2787441.0
2021-12-28 15:00:00	QQQ	ETF	401.74	402.55	401.22	401.71	3880487.0
2021-12-28 16:00:00	QQQ	ETF	401.72	402.53	401.61	402.14	730744.0
2021-12-28 17:00:00	QQQ	ETF	402.1	402.26	401.96	402.14	14948.0
2021-12-28 18:00:00	QQQ	ETF	402.18	402.88	402.14	402.71	125249.0
2021-12-28 19:00:00	QQQ	ETF	402.8	402.9	402.58	402.9	40873.0
2021-12-28 04:00:00	IWM	ETF	224.1	224.62	224.08	224.41	10990.0
2021-12-28 05:00:00	IWM	ETF	224.41	224.64	224.36	224.54	11587.0
2021-12-28 06:00:00	IWM	ETF	224.49	224.62	224.39	224.54	8934.0
2021-12-28 07:00:00	IWM	ETF	224.51	224.82	224.51	224.63	34626.0
2021-12-28 08:00:00	IWM	ETF	224.5496	224.81	224.02	224.02	46884.0
2021-12-28 09:00:00	IWM	ETF	224.07	225.4	223.52	225.03	3406720.0
2021-12-28 10:00:00	IWM	ETF	225.02	225.73	224.06	224.14	2723011.0
2021-12-28 11:00:00	IWM	ETF	224.12	224.19	222.9	223.54	2260041.0
2021-12-28 12:00:00	IWM	ETF	223.54	223.55	222.35	222.66	1894384.0
2021-12-28 13:00:00	IWM	ETF	222.65	223.15	222.58	223.15	1022405.0
2021-12-28 14:00:00	IWM	ETF	223.14	223.665	222.58	223.46	1230283.0
2021-12-28 15:00:00	IWM	ETF	223.47	223.79	222.43	222.78	2938635.0
2021-12-28 16:00:00	IWM	ETF	222.75	223.08	222.71	222.75	314346.0
2021-12-28 17:00:00	IWM	ETF	222.53	222.91	222.53	222.79	15347.0
2021-12-28 18:00:00	IWM	ETF	222.89	223.22	222.81	223.07	33363.0
2021-12-28 19:00:00	IWM	ETF	223.07	223.28	223.07	223.2204	15642.0
2021-12-28 04:00:00	DIA	ETF	363.34	363.34	363.34	363.34	292.0
2021-12-28 05:00:00	DIA	ETF	363.73	363.89	363.71	363.71	1160.0

> showing 50 of 15,632 rows — these rows as CSV

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