PREVIEW / etf_1hour / 2021-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-30.parquet
  size:    410 KB
  rows:    14,348

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-30 04:00:00	SPY	ETF	419.5	419.5	418.63	418.84	8300.0
2021-04-30 05:00:00	SPY	ETF	418.87	418.98	418.34	418.39	16355.0
2021-04-30 06:00:00	SPY	ETF	418.32	418.41	417.23	417.49	194305.0
2021-04-30 07:00:00	SPY	ETF	417.5	417.92	417.34	417.92	132511.0
2021-04-30 08:00:00	SPY	ETF	417.92	419.15	417.08	417.92	363103.0
2021-04-30 09:00:00	SPY	ETF	417.89	418.5	417.3	418.4656	5211212.0
2021-04-30 10:00:00	SPY	ETF	418.47	418.54	417.33	417.48	7949661.0
2021-04-30 11:00:00	SPY	ETF	417.48	417.76	416.71	417.635	8850034.0
2021-04-30 12:00:00	SPY	ETF	417.63	417.89	417.1001	417.4701	3610761.0
2021-04-30 13:00:00	SPY	ETF	417.46	417.9	416.38	416.6699	5100928.0
2021-04-30 14:00:00	SPY	ETF	416.66	417.48	416.49	417.055	6544081.0
2021-04-30 15:00:00	SPY	ETF	417.07	417.57	416.34	417.29	21865976.0
2021-04-30 16:00:00	SPY	ETF	417.29	417.82	416.9672	417.65	4937788.0
2021-04-30 17:00:00	SPY	ETF	417.5	417.6	417.2	417.32	174470.0
2021-04-30 18:00:00	SPY	ETF	417.31	417.31	417.1	417.14	52505.0
2021-04-30 19:00:00	SPY	ETF	417.12	417.38	417.12	417.33	21588.0
2021-04-30 04:00:00	QQQ	ETF	339.0	339.19	338.7	338.94	44999.0
2021-04-30 05:00:00	QQQ	ETF	339.0	339.23	338.49	338.56	43560.0
2021-04-30 06:00:00	QQQ	ETF	338.49	338.65	337.3	337.76	223678.0
2021-04-30 07:00:00	QQQ	ETF	337.76	338.15	337.53	338.15	172821.0
2021-04-30 08:00:00	QQQ	ETF	337.8096	339.29	336.97	337.84	285430.0
2021-04-30 09:00:00	QQQ	ETF	337.73	339.07	337.35	339.05	4340357.0
2021-04-30 10:00:00	QQQ	ETF	339.0311	340.26	338.26	338.83	4567393.0
2021-04-30 11:00:00	QQQ	ETF	338.8401	339.28	337.9103	339.02	3838064.0
2021-04-30 12:00:00	QQQ	ETF	339.03	339.33	338.17	338.62	2084523.0
2021-04-30 13:00:00	QQQ	ETF	338.62	338.8899	337.05	337.355	2693634.0
2021-04-30 14:00:00	QQQ	ETF	337.37	338.23	337.23	337.81	2905305.0
2021-04-30 15:00:00	QQQ	ETF	337.8	338.3	337.08	337.89	7253044.0
2021-04-30 16:00:00	QQQ	ETF	337.88	338.4	337.4	338.02	1358464.0
2021-04-30 17:00:00	QQQ	ETF	338.05	338.16	337.92	338.06	100944.0
2021-04-30 18:00:00	QQQ	ETF	338.08	338.15	337.85	338.06	13116.0
2021-04-30 19:00:00	QQQ	ETF	338.06	338.1	338.0	338.1	12820.0
2021-04-30 04:00:00	IWM	ETF	227.49	227.49	226.85	226.93	6900.0
2021-04-30 05:00:00	IWM	ETF	227.0	227.24	226.77	226.82	9316.0
2021-04-30 06:00:00	IWM	ETF	226.77	226.77	225.47	225.9	16099.0
2021-04-30 07:00:00	IWM	ETF	225.96	226.42	225.81	226.25	37914.0
2021-04-30 08:00:00	IWM	ETF	226.25	227.34	224.78	225.75	108083.0
2021-04-30 09:00:00	IWM	ETF	225.79	227.21	225.42	227.145	2184494.0
2021-04-30 10:00:00	IWM	ETF	227.14	227.8	225.85	226.01	2713033.0
2021-04-30 11:00:00	IWM	ETF	226.03	226.39	225.53	226.21	2002888.0
2021-04-30 12:00:00	IWM	ETF	226.21	226.495	225.585	226.03	1001239.0
2021-04-30 13:00:00	IWM	ETF	226.03	226.04	224.3501	224.68	1947877.0
2021-04-30 14:00:00	IWM	ETF	224.69	225.31	224.42	224.69	1851334.0
2021-04-30 15:00:00	IWM	ETF	224.71	225.14	224.14	224.92	5484762.0
2021-04-30 16:00:00	IWM	ETF	224.89	225.3	224.88	225.25	1863382.0
2021-04-30 17:00:00	IWM	ETF	225.2	225.4	224.89	224.89	167504.0
2021-04-30 18:00:00	IWM	ETF	225.27	225.27	224.96	224.97	476169.0
2021-04-30 19:00:00	IWM	ETF	224.94	225.19	224.94	225.09	5967.0
2021-04-30 04:00:00	DIA	ETF	340.0	340.0	339.8	339.81	1600.0
2021-04-30 05:00:00	DIA	ETF	340.09	340.09	339.64	339.91	4045.0

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

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