PREVIEW / etf_1hour / 2022-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-28.parquet
  size:    461 KB
  rows:    16,888

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
2022-01-28 04:00:00	SPY	ETF	432.21	432.69	431.19	431.35	17582.0
2022-01-28 05:00:00	SPY	ETF	431.42	431.42	429.91	430.48	54027.0
2022-01-28 06:00:00	SPY	ETF	430.62	430.63	428.68	429.58	131081.0
2022-01-28 07:00:00	SPY	ETF	429.88	430.16	426.2	427.33	478698.0
2022-01-28 08:00:00	SPY	ETF	429.6799	434.1	426.27	430.72	1760909.0
2022-01-28 09:00:00	SPY	ETF	430.84	433.15	427.88	428.49	14471603.0
2022-01-28 10:00:00	SPY	ETF	428.5	433.48	427.82	433.42	16795580.0
2022-01-28 11:00:00	SPY	ETF	433.45	437.08	432.08	436.92	16241449.0
2022-01-28 12:00:00	SPY	ETF	436.94	437.55	434.2	434.58	10997527.0
2022-01-28 13:00:00	SPY	ETF	434.57	436.94	434.44	436.2	9966453.0
2022-01-28 14:00:00	SPY	ETF	436.2	437.19	431.83	436.06	13911558.0
2022-01-28 15:00:00	SPY	ETF	436.08	442.0	435.59	441.9	32465371.0
2022-01-28 16:00:00	SPY	ETF	441.89	442.09	440.75	441.41	7800961.0
2022-01-28 17:00:00	SPY	ETF	441.58	441.95	441.29	441.69	542943.0
2022-01-28 18:00:00	SPY	ETF	441.69	442.74	441.6	442.1	72108.0
2022-01-28 19:00:00	SPY	ETF	442.05	442.49	441.94	442.3	42761.0
2022-01-28 04:00:00	QQQ	ETF	343.22	344.07	342.32	342.79	207990.0
2022-01-28 05:00:00	QQQ	ETF	342.76	342.77	341.33	341.87	131074.0
2022-01-28 06:00:00	QQQ	ETF	342.29	342.34	340.18	340.91	219512.0
2022-01-28 07:00:00	QQQ	ETF	341.05	341.71	337.3	338.36	885847.0
2022-01-28 08:00:00	QQQ	ETF	338.41	345.14	337.32	341.46	2194876.0
2022-01-28 09:00:00	QQQ	ETF	341.6	343.84	338.08	338.92	9041216.0
2022-01-28 10:00:00	QQQ	ETF	338.95	344.9	337.95	344.8588	11635286.0
2022-01-28 11:00:00	QQQ	ETF	344.86	348.57	343.45	348.37	12923117.0
2022-01-28 12:00:00	QQQ	ETF	348.39	348.91	345.85	346.08	9049971.0
2022-01-28 13:00:00	QQQ	ETF	346.08	347.84	345.59	346.94	6430376.0
2022-01-28 14:00:00	QQQ	ETF	346.92	347.87	342.76	346.5	9288441.0
2022-01-28 15:00:00	QQQ	ETF	346.48	352.02	346.1	351.95	15149748.0
2022-01-28 16:00:00	QQQ	ETF	351.96	352.1	348.5	351.83	1838154.0
2022-01-28 17:00:00	QQQ	ETF	351.77	352.16	351.77	352.08	852503.0
2022-01-28 18:00:00	QQQ	ETF	352.12	352.89	351.98	352.43	45765.0
2022-01-28 19:00:00	QQQ	ETF	352.45	352.85	352.29	352.7	55020.0
2022-01-28 04:00:00	IWM	ETF	191.6	191.6	190.25	190.41	29082.0
2022-01-28 05:00:00	IWM	ETF	190.36	190.36	189.45	190.12	40329.0
2022-01-28 06:00:00	IWM	ETF	189.99	190.31	189.0	189.42	44188.0
2022-01-28 07:00:00	IWM	ETF	189.51	189.85	188.08	188.74	174086.0
2022-01-28 08:00:00	IWM	ETF	188.85	192.59	188.48	190.56	616342.0
2022-01-28 09:00:00	IWM	ETF	190.63	192.51	189.12	189.34	7585963.0
2022-01-28 10:00:00	IWM	ETF	189.34	190.94	188.09	190.4845	7507649.0
2022-01-28 11:00:00	IWM	ETF	190.5	192.66	189.595	192.5105	6841817.0
2022-01-28 12:00:00	IWM	ETF	192.52	193.3	190.31	190.54	5925173.0
2022-01-28 13:00:00	IWM	ETF	190.54	192.16	190.43	191.76	2980625.0
2022-01-28 14:00:00	IWM	ETF	191.75	192.34	188.44	191.34	5854989.0
2022-01-28 15:00:00	IWM	ETF	191.33	195.31	190.9	195.23	8509691.0
2022-01-28 16:00:00	IWM	ETF	195.25	195.27	194.4	194.56	2835979.0
2022-01-28 17:00:00	IWM	ETF	194.5	195.25	194.4	194.67	56683.0
2022-01-28 18:00:00	IWM	ETF	194.67	195.25	194.51	194.65	32208.0
2022-01-28 19:00:00	IWM	ETF	194.65	195.1	194.65	194.89	25504.0
2022-01-28 04:00:00	DIA	ETF	341.68	341.71	341.11	341.2	5562.0
2022-01-28 05:00:00	DIA	ETF	340.26	340.94	340.26	340.49	6061.0

> showing 50 of 16,888 rows — these rows as CSV

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