PREVIEW / etf_1hour / 2022-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-17.parquet
  size:    459 KB
  rows:    16,432

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-17 04:00:00	SPY	ETF	436.06	436.1	434.62	435.1	40164.0
2022-03-17 05:00:00	SPY	ETF	435.29	435.34	434.18	434.66	17700.0
2022-03-17 06:00:00	SPY	ETF	434.79	434.79	432.65	434.5	209417.0
2022-03-17 07:00:00	SPY	ETF	434.53	434.99	433.62	434.18	291984.0
2022-03-17 08:00:00	SPY	ETF	433.7201	436.69	433.16	433.74	582573.0
2022-03-17 09:00:00	SPY	ETF	433.67	436.24	433.19	436.1799	7673540.0
2022-03-17 10:00:00	SPY	ETF	436.17	436.97	433.98	434.78	10378119.0
2022-03-17 11:00:00	SPY	ETF	434.76	436.45	434.28	436.12	5924858.0
2022-03-17 12:00:00	SPY	ETF	436.14	437.93	435.74	437.748	5369159.0
2022-03-17 13:00:00	SPY	ETF	437.755	439.86	436.98	439.4359	6742788.0
2022-03-17 14:00:00	SPY	ETF	439.44	439.7	438.26	439.3822	7317146.0
2022-03-17 15:00:00	SPY	ETF	439.385	441.06	438.08	441.0	18600560.0
2022-03-17 16:00:00	SPY	ETF	441.0	441.15	438.57	438.92	6561068.0
2022-03-17 17:00:00	SPY	ETF	439.08	439.26	438.95	439.15	132433.0
2022-03-17 18:00:00	SPY	ETF	439.15	439.54	438.25	438.44	355552.0
2022-03-17 19:00:00	SPY	ETF	438.5	438.75	438.29	438.51	100448.0
2022-03-17 04:00:00	QQQ	ETF	340.73	341.0	339.47	339.76	106211.0
2022-03-17 05:00:00	QQQ	ETF	339.78	340.03	338.98	339.55	105016.0
2022-03-17 06:00:00	QQQ	ETF	338.91	339.43	337.5	339.36	239651.0
2022-03-17 07:00:00	QQQ	ETF	339.38	339.72	338.3	338.88	329942.0
2022-03-17 08:00:00	QQQ	ETF	339.06	341.54	337.41	337.95	1054734.0
2022-03-17 09:00:00	QQQ	ETF	337.91	341.045	337.0406	341.0	7885859.0
2022-03-17 10:00:00	QQQ	ETF	341.0	341.8	337.775	338.47	9825157.0
2022-03-17 11:00:00	QQQ	ETF	338.47	340.34	337.63	339.58	5503892.0
2022-03-17 12:00:00	QQQ	ETF	339.59	341.29	339.13	341.05	3967431.0
2022-03-17 13:00:00	QQQ	ETF	341.04	343.69	340.08	343.1579	5275639.0
2022-03-17 14:00:00	QQQ	ETF	343.17	343.45	341.81	342.95	3749887.0
2022-03-17 15:00:00	QQQ	ETF	342.935	344.5	341.65	344.36	8118421.0
2022-03-17 16:00:00	QQQ	ETF	344.38	344.67	342.47	342.71	1895704.0
2022-03-17 17:00:00	QQQ	ETF	342.7	344.44	342.6	342.85	95032.0
2022-03-17 18:00:00	QQQ	ETF	342.84	343.16	341.88	342.08	228206.0
2022-03-17 19:00:00	QQQ	ETF	342.1	342.3	341.97	342.01	140469.0
2022-03-17 04:00:00	IWM	ETF	202.34	202.34	201.51	201.79	18476.0
2022-03-17 05:00:00	IWM	ETF	201.84	201.84	201.2	201.49	15435.0
2022-03-17 06:00:00	IWM	ETF	201.55	201.55	200.34	201.3	111785.0
2022-03-17 07:00:00	IWM	ETF	201.41	201.65	200.99	201.27	171214.0
2022-03-17 08:00:00	IWM	ETF	201.41	201.57	200.72	201.06	174639.0
2022-03-17 09:00:00	IWM	ETF	201.08	202.89	200.3	202.88	2552683.0
2022-03-17 10:00:00	IWM	ETF	202.87	203.279	202.21	202.63	2937069.0
2022-03-17 11:00:00	IWM	ETF	202.61	203.71	202.33	203.68	1611367.0
2022-03-17 12:00:00	IWM	ETF	203.69	204.3	203.37	204.22	1629646.0
2022-03-17 13:00:00	IWM	ETF	204.2	204.96	203.76	204.94	1453043.0
2022-03-17 14:00:00	IWM	ETF	204.91	205.02	204.3241	204.8	1303782.0
2022-03-17 15:00:00	IWM	ETF	204.8	205.21	204.15	205.18	3129041.0
2022-03-17 16:00:00	IWM	ETF	205.11	205.32	203.85	204.09	2145761.0
2022-03-17 17:00:00	IWM	ETF	204.37	205.11	203.96	204.19	39445.0
2022-03-17 18:00:00	IWM	ETF	204.39	204.41	203.69	203.79	21495.0
2022-03-17 19:00:00	IWM	ETF	203.87	204.3	203.86	204.21	34503.0
2022-03-17 04:00:00	DIA	ETF	341.75	341.75	341.75	341.75	258.0
2022-03-17 05:00:00	DIA	ETF	340.64	340.64	340.64	340.64	150.0

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

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