PREVIEW / etf_1hour / 2022-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-22.parquet
  size:    453 KB
  rows:    16,199

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-03-22 04:00:00	SPY	ETF	444.69	446.17	444.55	445.81	22414.0
2022-03-22 05:00:00	SPY	ETF	446.0	446.41	445.7	445.83	27482.0
2022-03-22 06:00:00	SPY	ETF	445.86	446.27	445.4	446.03	59753.0
2022-03-22 07:00:00	SPY	ETF	445.98	446.06	445.45	445.51	114973.0
2022-03-22 08:00:00	SPY	ETF	445.5201	446.0504	443.1	445.9	182857.0
2022-03-22 09:00:00	SPY	ETF	445.89	447.49	445.58	447.21	5932639.0
2022-03-22 10:00:00	SPY	ETF	447.21	449.39	447.21	448.81	8867770.0
2022-03-22 11:00:00	SPY	ETF	448.84	449.7	448.22	448.7	7259473.0
2022-03-22 12:00:00	SPY	ETF	448.695	449.17	447.79	449.02	5673162.0
2022-03-22 13:00:00	SPY	ETF	449.01	449.6	448.56	449.505	4413275.0
2022-03-22 14:00:00	SPY	ETF	449.51	449.59	448.12	448.98	5885268.0
2022-03-22 15:00:00	SPY	ETF	448.98	450.58	448.81	449.58	15294760.0
2022-03-22 16:00:00	SPY	ETF	449.58	449.82	449.437	449.63	4243489.0
2022-03-22 17:00:00	SPY	ETF	449.63	449.67	449.32	449.5	52820.0
2022-03-22 18:00:00	SPY	ETF	449.53	450.27	449.0	450.01	81171.0
2022-03-22 19:00:00	SPY	ETF	450.01	450.13	449.8	450.08	39248.0
2022-03-22 04:00:00	QQQ	ETF	350.4	351.8	350.32	351.58	90904.0
2022-03-22 05:00:00	QQQ	ETF	351.74	352.0	351.15	351.26	51019.0
2022-03-22 06:00:00	QQQ	ETF	351.27	351.67	350.75	351.42	66972.0
2022-03-22 07:00:00	QQQ	ETF	351.38	351.41	350.4	350.48	226685.0
2022-03-22 08:00:00	QQQ	ETF	351.18	351.7304	348.8	350.75	379324.0
2022-03-22 09:00:00	QQQ	ETF	350.75	352.97	350.2	352.42	7549177.0
2022-03-22 10:00:00	QQQ	ETF	352.46	356.52	352.46	355.97	8078945.0
2022-03-22 11:00:00	QQQ	ETF	355.99	357.7	355.5	356.24	6274394.0
2022-03-22 12:00:00	QQQ	ETF	356.25	356.7	354.95	355.919	5248385.0
2022-03-22 13:00:00	QQQ	ETF	355.94	356.78	355.23	356.74	3944683.0
2022-03-22 14:00:00	QQQ	ETF	356.77	357.0882	355.41	356.6938	4602164.0
2022-03-22 15:00:00	QQQ	ETF	356.68	357.85	356.34	356.96	8427762.0
2022-03-22 16:00:00	QQQ	ETF	356.98	357.3	356.87	356.98	1991357.0
2022-03-22 17:00:00	QQQ	ETF	356.92	357.0	356.6	356.71	85273.0
2022-03-22 18:00:00	QQQ	ETF	356.79	357.35	356.38	357.23	174242.0
2022-03-22 19:00:00	QQQ	ETF	357.19	357.33	356.89	357.3196	170075.0
2022-03-22 04:00:00	IWM	ETF	205.6	206.38	205.6	206.16	26924.0
2022-03-22 05:00:00	IWM	ETF	206.2	206.44	206.16	206.21	24000.0
2022-03-22 06:00:00	IWM	ETF	206.25	206.47	205.94	206.24	47987.0
2022-03-22 07:00:00	IWM	ETF	206.2	206.35	206.01	206.1	30447.0
2022-03-22 08:00:00	IWM	ETF	206.2901	206.31	205.21	206.26	59110.0
2022-03-22 09:00:00	IWM	ETF	206.27	208.48	206.1	208.415	2056060.0
2022-03-22 10:00:00	IWM	ETF	208.42	208.79	207.33	207.57	2902804.0
2022-03-22 11:00:00	IWM	ETF	207.5701	207.64	206.54	206.57	2138452.0
2022-03-22 12:00:00	IWM	ETF	206.57	206.67	205.8	206.53	1832669.0
2022-03-22 13:00:00	IWM	ETF	206.52	207.37	206.46	207.32	1246418.0
2022-03-22 14:00:00	IWM	ETF	207.33	207.71	206.91	207.555	1342066.0
2022-03-22 15:00:00	IWM	ETF	207.55	207.9	207.06	207.38	3330994.0
2022-03-22 16:00:00	IWM	ETF	207.5	207.55	207.0387	207.47	744276.0
2022-03-22 17:00:00	IWM	ETF	207.51	207.51	207.32	207.36	112569.0
2022-03-22 18:00:00	IWM	ETF	207.4	207.85	207.08	207.72	71999.0
2022-03-22 19:00:00	IWM	ETF	207.79	207.79	207.52	207.69	54623.0
2022-03-22 04:00:00	DIA	ETF	345.93	346.66	345.93	346.66	936.0
2022-03-22 05:00:00	DIA	ETF	346.6	346.92	346.6	346.75	1800.0

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

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