PREVIEW / etf_1hour / 2021-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-29.parquet
  size:    414 KB
  rows:    14,429

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-29 04:00:00	SPY	ETF	419.76	420.25	419.76	419.98	13937.0
2021-04-29 05:00:00	SPY	ETF	419.93	420.04	419.8	419.99	12651.0
2021-04-29 06:00:00	SPY	ETF	420.06	420.36	420.0	420.07	26873.0
2021-04-29 07:00:00	SPY	ETF	420.05	420.29	419.92	419.92	172476.0
2021-04-29 08:00:00	SPY	ETF	420.1999	420.44	418.8	420.4	457838.0
2021-04-29 09:00:00	SPY	ETF	420.4	420.72	419.49	419.57	7320159.0
2021-04-29 10:00:00	SPY	ETF	419.56	419.57	417.54	418.27	11185128.0
2021-04-29 11:00:00	SPY	ETF	418.26	418.87	417.387	417.5499	6196659.0
2021-04-29 12:00:00	SPY	ETF	417.54	418.25	416.44	418.115	8195064.0
2021-04-29 13:00:00	SPY	ETF	418.12	418.81	417.78	418.615	4575027.0
2021-04-29 14:00:00	SPY	ETF	418.6	420.49	418.55	420.01	7368945.0
2021-04-29 15:00:00	SPY	ETF	420.02	420.45	419.51	420.0	13360950.0
2021-04-29 16:00:00	SPY	ETF	419.99	420.11	417.1366	419.65	3914006.0
2021-04-29 17:00:00	SPY	ETF	419.65	419.73	419.62	419.64	63533.0
2021-04-29 18:00:00	SPY	ETF	419.71	420.06	419.36	419.49	121244.0
2021-04-29 19:00:00	SPY	ETF	419.5	419.66	419.06	419.35	178779.0
2021-04-29 04:00:00	QQQ	ETF	340.72	342.21	340.72	342.12	42320.0
2021-04-29 05:00:00	QQQ	ETF	342.05	342.11	341.84	341.86	92434.0
2021-04-29 06:00:00	QQQ	ETF	341.86	342.13	341.74	341.92	69633.0
2021-04-29 07:00:00	QQQ	ETF	341.92	342.47	341.87	342.09	292622.0
2021-04-29 08:00:00	QQQ	ETF	342.06	342.88	341.25	342.62	362771.0
2021-04-29 09:00:00	QQQ	ETF	342.621	342.8	340.1	340.5	5568077.0
2021-04-29 10:00:00	QQQ	ETF	340.5	340.54	338.47	339.53	6217097.0
2021-04-29 11:00:00	QQQ	ETF	339.53	339.94	337.61	337.98	3006490.0
2021-04-29 12:00:00	QQQ	ETF	337.955	338.65	336.9001	338.49	4168390.0
2021-04-29 13:00:00	QQQ	ETF	338.48	339.5	338.04	339.43	2865542.0
2021-04-29 14:00:00	QQQ	ETF	339.45	340.73	339.23	340.5119	3451047.0
2021-04-29 15:00:00	QQQ	ETF	340.54	340.84	339.91	340.22	3658333.0
2021-04-29 16:00:00	QQQ	ETF	340.22	340.78	339.8	339.95	1621749.0
2021-04-29 17:00:00	QQQ	ETF	339.91	340.22	339.8	339.83	46064.0
2021-04-29 18:00:00	QQQ	ETF	339.87	340.0	339.52	339.6	58912.0
2021-04-29 19:00:00	QQQ	ETF	339.6	339.68	339.13	339.22	102790.0
2021-04-29 04:00:00	IWM	ETF	229.92	230.28	229.9	230.12	14897.0
2021-04-29 05:00:00	IWM	ETF	230.05	230.23	229.89	230.23	22000.0
2021-04-29 06:00:00	IWM	ETF	230.13	230.46	230.08	230.29	24258.0
2021-04-29 07:00:00	IWM	ETF	230.31	230.53	230.18	230.52	82961.0
2021-04-29 08:00:00	IWM	ETF	230.5	230.9	230.18	230.66	142905.0
2021-04-29 09:00:00	IWM	ETF	230.74	230.95	229.09	229.31	2785908.0
2021-04-29 10:00:00	IWM	ETF	229.315	229.64	227.25	228.4189	3232408.0
2021-04-29 11:00:00	IWM	ETF	228.43	228.62	227.23	227.3	1950063.0
2021-04-29 12:00:00	IWM	ETF	227.32	227.35	225.79	226.92	2847261.0
2021-04-29 13:00:00	IWM	ETF	226.9215	227.178	226.43	226.7	1593829.0
2021-04-29 14:00:00	IWM	ETF	226.71	228.22	226.63	228.205	1853123.0
2021-04-29 15:00:00	IWM	ETF	228.21	228.37	227.15	228.05	3165401.0
2021-04-29 16:00:00	IWM	ETF	227.99	228.06	227.21	227.35	1031039.0
2021-04-29 17:00:00	IWM	ETF	227.4	227.99	227.33	227.33	39572.0
2021-04-29 18:00:00	IWM	ETF	227.4	227.55	227.25	227.48	30942.0
2021-04-29 19:00:00	IWM	ETF	227.48	227.64	227.37	227.58	19330.0
2021-04-29 04:00:00	DIA	ETF	339.77	339.77	339.49	339.5	600.0
2021-04-29 05:00:00	DIA	ETF	339.56	339.56	339.56	339.56	200.0

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

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