PREVIEW / etf_1hour / 2022-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-24.parquet
  size:    501 KB
  rows:    18,552

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-01-24 04:00:00	SPY	ETF	439.02	440.23	438.98	439.5	147847.0
2022-01-24 05:00:00	SPY	ETF	439.39	439.39	435.62	436.8	194722.0
2022-01-24 06:00:00	SPY	ETF	436.84	438.09	436.6	437.81	149390.0
2022-01-24 07:00:00	SPY	ETF	437.79	438.04	435.58	435.79	666349.0
2022-01-24 08:00:00	SPY	ETF	436.27	441.79	431.98	432.0	1904729.0
2022-01-24 09:00:00	SPY	ETF	432.0	433.46	428.45	429.07	23847955.0
2022-01-24 10:00:00	SPY	ETF	429.09	430.94	425.75	428.79	24066016.0
2022-01-24 11:00:00	SPY	ETF	428.78	428.824	422.89	425.82	19090645.0
2022-01-24 12:00:00	SPY	ETF	425.79	426.36	420.76	425.3	20872264.0
2022-01-24 13:00:00	SPY	ETF	425.28	431.35	424.73	431.26	19629744.0
2022-01-24 14:00:00	SPY	ETF	431.27	433.04	426.03	430.32	21853966.0
2022-01-24 15:00:00	SPY	ETF	430.31	440.38	429.91	439.89	39444822.0
2022-01-24 16:00:00	SPY	ETF	439.88	440.54	438.6	440.17	6780945.0
2022-01-24 17:00:00	SPY	ETF	440.28	440.28	439.25	439.59	437992.0
2022-01-24 18:00:00	SPY	ETF	439.6	440.15	437.83	439.6	624284.0
2022-01-24 19:00:00	SPY	ETF	439.6	439.85	435.99	436.18	243787.0
2022-01-24 04:00:00	QQQ	ETF	352.85	354.3	351.77	352.4	165334.0
2022-01-24 05:00:00	QQQ	ETF	352.13	352.13	348.47	349.5	380976.0
2022-01-24 06:00:00	QQQ	ETF	349.61	351.2	349.41	350.76	368056.0
2022-01-24 07:00:00	QQQ	ETF	350.9	351.07	348.11	348.49	764949.0
2022-01-24 08:00:00	QQQ	ETF	348.931	355.0	345.3	345.379	1666242.0
2022-01-24 09:00:00	QQQ	ETF	345.32	347.66	342.53	343.58	20012113.0
2022-01-24 10:00:00	QQQ	ETF	343.59	345.33	339.94	343.47	26479967.0
2022-01-24 11:00:00	QQQ	ETF	343.45	343.46	336.87	339.67	19042496.0
2022-01-24 12:00:00	QQQ	ETF	339.66	340.46	334.15	339.41	22225640.0
2022-01-24 13:00:00	QQQ	ETF	339.38	345.66	338.85	345.6	18323073.0
2022-01-24 14:00:00	QQQ	ETF	345.58	347.33	340.66	345.03	18091623.0
2022-01-24 15:00:00	QQQ	ETF	345.04	353.98	344.21	353.58	23448790.0
2022-01-24 16:00:00	QQQ	ETF	353.56	354.0	341.67	353.79	3100217.0
2022-01-24 17:00:00	QQQ	ETF	353.78	353.8	352.61	353.09	594022.0
2022-01-24 18:00:00	QQQ	ETF	353.15	353.41	351.11	352.9504	431987.0
2022-01-24 19:00:00	QQQ	ETF	352.93	353.14	349.35	349.57	360944.0
2022-01-24 04:00:00	IWM	ETF	198.17	198.33	197.32	197.79	20140.0
2022-01-24 05:00:00	IWM	ETF	197.74	197.74	195.7	196.38	54277.0
2022-01-24 06:00:00	IWM	ETF	196.44	197.09	196.07	196.91	62506.0
2022-01-24 07:00:00	IWM	ETF	196.94	197.08	195.83	196.06	314634.0
2022-01-24 08:00:00	IWM	ETF	198.0796	199.23	193.72	193.73	678454.0
2022-01-24 09:00:00	IWM	ETF	193.64	195.74	192.76	193.2	7629567.0
2022-01-24 10:00:00	IWM	ETF	193.19	195.19	191.49	194.15	11457520.0
2022-01-24 11:00:00	IWM	ETF	194.08	194.405	191.62	193.98	6527438.0
2022-01-24 12:00:00	IWM	ETF	193.94	194.27	191.23	193.85	7022988.0
2022-01-24 13:00:00	IWM	ETF	193.84	197.76	193.43	197.71	7550112.0
2022-01-24 14:00:00	IWM	ETF	197.71	199.7	196.09	198.14	8478847.0
2022-01-24 15:00:00	IWM	ETF	198.18	202.39	197.96	201.85	10297910.0
2022-01-24 16:00:00	IWM	ETF	201.85	202.37	201.5	202.01	3991243.0
2022-01-24 17:00:00	IWM	ETF	201.95	202.15	201.53	202.0	347308.0
2022-01-24 18:00:00	IWM	ETF	201.9	202.19	200.9	201.84	87500.0
2022-01-24 19:00:00	IWM	ETF	201.88	201.95	199.7	199.9	54034.0
2022-01-24 04:00:00	DIA	ETF	343.39	343.64	343.02	343.6	1421.0
2022-01-24 05:00:00	DIA	ETF	343.05	343.05	341.27	341.56	7485.0

> showing 50 of 18,552 rows — these rows as CSV

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