PREVIEW / etf_1hour / 2022-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-31.parquet
  size:    467 KB
  rows:    16,603

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-31 04:00:00	SPY	ETF	442.0	443.08	441.71	442.03	71983.0
2022-01-31 05:00:00	SPY	ETF	442.33	442.33	441.14	441.35	49575.0
2022-01-31 06:00:00	SPY	ETF	441.34	441.7	440.62	440.93	60692.0
2022-01-31 07:00:00	SPY	ETF	440.99	441.23	439.15	440.57	486005.0
2022-01-31 08:00:00	SPY	ETF	440.59	443.0	439.3	440.96	545345.0
2022-01-31 09:00:00	SPY	ETF	440.94	443.36	439.81	443.33	11342913.0
2022-01-31 10:00:00	SPY	ETF	443.33	445.79	443.28	445.18	14535096.0
2022-01-31 11:00:00	SPY	ETF	445.17	446.8	443.89	446.71	10104278.0
2022-01-31 12:00:00	SPY	ETF	446.71	447.53	445.66	447.32	7497368.0
2022-01-31 13:00:00	SPY	ETF	447.32	447.62	446.53	447.38	8053280.0
2022-01-31 14:00:00	SPY	ETF	447.38	448.38	447.19	448.08	8321546.0
2022-01-31 15:00:00	SPY	ETF	448.08	450.28	445.69	449.79	30143137.0
2022-01-31 16:00:00	SPY	ETF	449.785	450.1741	448.49	448.58	7874411.0
2022-01-31 17:00:00	SPY	ETF	448.49	448.96	448.49	448.83	98415.0
2022-01-31 18:00:00	SPY	ETF	448.83	449.91	448.44	448.79	642178.0
2022-01-31 19:00:00	SPY	ETF	448.84	449.12	448.68	448.96	54548.0
2022-01-31 04:00:00	QQQ	ETF	352.0	354.6	352.0	354.03	84410.0
2022-01-31 05:00:00	QQQ	ETF	354.03	354.09	352.97	353.55	105930.0
2022-01-31 06:00:00	QQQ	ETF	353.4	353.69	352.79	353.21	101834.0
2022-01-31 07:00:00	QQQ	ETF	353.24	353.37	351.08	352.34	378455.0
2022-01-31 08:00:00	QQQ	ETF	352.39	354.5596	351.1201	352.87	730594.0
2022-01-31 09:00:00	QQQ	ETF	352.9	356.83	351.52	356.74	8795555.0
2022-01-31 10:00:00	QQQ	ETF	356.75	358.98	356.65	358.75	11635173.0
2022-01-31 11:00:00	QQQ	ETF	358.74	360.36	357.48	360.17	7777539.0
2022-01-31 12:00:00	QQQ	ETF	360.17	360.46	358.65	360.26	6590826.0
2022-01-31 13:00:00	QQQ	ETF	360.27	360.51	359.18	360.2168	5185892.0
2022-01-31 14:00:00	QQQ	ETF	360.24	361.47	359.91	361.1282	5226318.0
2022-01-31 15:00:00	QQQ	ETF	361.12	363.65	358.77	363.28	15432682.0
2022-01-31 16:00:00	QQQ	ETF	363.24	363.6236	362.06	362.42	2924942.0
2022-01-31 17:00:00	QQQ	ETF	362.35	363.05	362.22	362.4	357199.0
2022-01-31 18:00:00	QQQ	ETF	362.4	362.87	362.3	362.54	140531.0
2022-01-31 19:00:00	QQQ	ETF	362.54	362.9	362.31	362.69	105521.0
2022-01-31 04:00:00	IWM	ETF	194.95	195.17	194.33	194.44	37998.0
2022-01-31 05:00:00	IWM	ETF	194.59	194.6	193.87	194.06	28109.0
2022-01-31 06:00:00	IWM	ETF	194.12	194.18	193.39	193.49	42331.0
2022-01-31 07:00:00	IWM	ETF	193.58	193.65	192.58	193.58	189539.0
2022-01-31 08:00:00	IWM	ETF	193.67	195.14	192.6096	193.98	145564.0
2022-01-31 09:00:00	IWM	ETF	193.85	196.5	193.77	196.42	5470053.0
2022-01-31 10:00:00	IWM	ETF	196.425	197.89	196.14	197.25	7371123.0
2022-01-31 11:00:00	IWM	ETF	197.24	198.52	196.75	198.5	4583046.0
2022-01-31 12:00:00	IWM	ETF	198.51	199.76	198.49	199.71	3587955.0
2022-01-31 13:00:00	IWM	ETF	199.71	200.095	198.92	199.11	3243157.0
2022-01-31 14:00:00	IWM	ETF	199.14	199.92	198.89	199.54	2609475.0
2022-01-31 15:00:00	IWM	ETF	199.545	201.17	197.9	201.1	10105062.0
2022-01-31 16:00:00	IWM	ETF	201.09	201.24	199.96	199.99	3329983.0
2022-01-31 17:00:00	IWM	ETF	200.08	201.24	200.01	200.4	131395.0
2022-01-31 18:00:00	IWM	ETF	200.25	200.54	200.12	200.46	30425.0
2022-01-31 19:00:00	IWM	ETF	200.34	200.58	200.34	200.42	76182.0
2022-01-31 04:00:00	DIA	ETF	347.46	347.46	346.25	346.26	4732.0
2022-01-31 05:00:00	DIA	ETF	346.59	346.59	345.98	346.12	3900.0

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

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