PREVIEW / etf_1hour / 2022-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-21.parquet
  size:    462 KB
  rows:    16,531

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-04-21 04:00:00	SPY	ETF	447.94	448.43	447.85	448.36	28879.0
2022-04-21 05:00:00	SPY	ETF	448.38	448.38	447.55	447.73	12754.0
2022-04-21 06:00:00	SPY	ETF	447.73	448.41	447.61	448.2	156829.0
2022-04-21 07:00:00	SPY	ETF	448.35	448.8	447.97	448.7	283448.0
2022-04-21 08:00:00	SPY	ETF	448.67	448.86	446.23	448.81	478869.0
2022-04-21 09:00:00	SPY	ETF	448.83	450.01	448.41	449.36	6572180.0
2022-04-21 10:00:00	SPY	ETF	449.38	449.42	446.92	447.29	7713385.0
2022-04-21 11:00:00	SPY	ETF	447.29	447.64	444.67	444.7	6723454.0
2022-04-21 12:00:00	SPY	ETF	444.71	445.0601	442.63	442.6687	7296422.0
2022-04-21 13:00:00	SPY	ETF	442.66	443.62	441.36	441.75	9356598.0
2022-04-21 14:00:00	SPY	ETF	441.73	441.925	438.85	439.22	10391507.0
2022-04-21 15:00:00	SPY	ETF	439.23	439.71	437.1	438.04	19123349.0
2022-04-21 16:00:00	SPY	ETF	438.02	438.2	437.25	437.58	3225040.0
2022-04-21 17:00:00	SPY	ETF	437.79	437.81	437.51	437.73	58135.0
2022-04-21 18:00:00	SPY	ETF	437.71	438.12	437.38	437.79	77330.0
2022-04-21 19:00:00	SPY	ETF	437.75	437.75	436.8	436.95	80600.0
2022-04-21 04:00:00	QQQ	ETF	344.64	345.2	344.64	345.17	49613.0
2022-04-21 05:00:00	QQQ	ETF	345.3	345.3	344.28	344.35	18437.0
2022-04-21 06:00:00	QQQ	ETF	344.26	345.12	344.13	344.87	121010.0
2022-04-21 07:00:00	QQQ	ETF	345.0	345.56	344.48	345.5	264536.0
2022-04-21 08:00:00	QQQ	ETF	344.88	345.68	341.465	345.48	399761.0
2022-04-21 09:00:00	QQQ	ETF	345.45	347.87	344.983	345.93	7956652.0
2022-04-21 10:00:00	QQQ	ETF	345.94	346.23	342.59	343.27	8538267.0
2022-04-21 11:00:00	QQQ	ETF	343.26	343.975	340.1	340.12	7520660.0
2022-04-21 12:00:00	QQQ	ETF	340.15	340.635	338.69	338.8765	6393161.0
2022-04-21 13:00:00	QQQ	ETF	338.85	339.79	337.47	337.69	8154027.0
2022-04-21 14:00:00	QQQ	ETF	337.66	337.66	334.73	335.14	8330657.0
2022-04-21 15:00:00	QQQ	ETF	335.14	335.425	333.2	334.22	14922199.0
2022-04-21 16:00:00	QQQ	ETF	334.22	334.59	332.9	334.14	1901754.0
2022-04-21 17:00:00	QQQ	ETF	334.14	334.41	333.85	333.99	136214.0
2022-04-21 18:00:00	QQQ	ETF	334.02	334.36	333.52	334.03	138002.0
2022-04-21 19:00:00	QQQ	ETF	334.1	334.16	333.13	333.32	80412.0
2022-04-21 04:00:00	IWM	ETF	204.0	204.33	203.93	204.22	28537.0
2022-04-21 05:00:00	IWM	ETF	204.32	204.32	203.91	203.97	5495.0
2022-04-21 06:00:00	IWM	ETF	204.04	204.39	203.92	204.39	16030.0
2022-04-21 07:00:00	IWM	ETF	204.32	204.54	204.13	204.45	36047.0
2022-04-21 08:00:00	IWM	ETF	204.0796	204.47	203.5	204.19	40883.0
2022-04-21 09:00:00	IWM	ETF	204.22	204.8	203.08	203.31	3978764.0
2022-04-21 10:00:00	IWM	ETF	203.32	203.34	201.87	202.02	2407898.0
2022-04-21 11:00:00	IWM	ETF	202.02	202.13	200.74	200.77	2409544.0
2022-04-21 12:00:00	IWM	ETF	200.77	201.13	199.46	199.47	1936543.0
2022-04-21 13:00:00	IWM	ETF	199.47	200.28	199.0	199.07	2817300.0
2022-04-21 14:00:00	IWM	ETF	199.06	199.11	197.49	197.69	3601423.0
2022-04-21 15:00:00	IWM	ETF	197.67	198.18	197.02	197.72	6231809.0
2022-04-21 16:00:00	IWM	ETF	197.8	197.8	197.24	197.3	997350.0
2022-04-21 17:00:00	IWM	ETF	197.22	197.8	197.22	197.3	94649.0
2022-04-21 18:00:00	IWM	ETF	197.4	197.65	197.34	197.44	24249.0
2022-04-21 19:00:00	IWM	ETF	197.42	197.42	196.88	196.88	22647.0
2022-04-21 04:00:00	DIA	ETF	353.65	353.71	353.65	353.71	2314.0
2022-04-21 05:00:00	DIA	ETF	353.6	353.67	353.35	353.67	300.0

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

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