PREVIEW / etf_1hour / 2022-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-14.parquet
  size:    452 KB
  rows:    16,409

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-02-14 04:00:00	SPY	ETF	440.36	440.36	435.78	436.16	103991.0
2022-02-14 05:00:00	SPY	ETF	436.0	438.33	435.24	437.51	73941.0
2022-02-14 06:00:00	SPY	ETF	437.01	437.84	436.67	437.51	46252.0
2022-02-14 07:00:00	SPY	ETF	437.49	441.8	436.5	440.5	1234045.0
2022-02-14 08:00:00	SPY	ETF	437.7001	442.0	435.9096	439.45	1679799.0
2022-02-14 09:00:00	SPY	ETF	439.48	441.28	438.97	440.18	10141422.0
2022-02-14 10:00:00	SPY	ETF	440.16	440.41	437.36	437.87	13452980.0
2022-02-14 11:00:00	SPY	ETF	437.88	440.68	437.62	440.17	10553040.0
2022-02-14 12:00:00	SPY	ETF	440.18	441.489	439.55	440.9023	6566475.0
2022-02-14 13:00:00	SPY	ETF	440.91	441.6	436.15	436.24	11568763.0
2022-02-14 14:00:00	SPY	ETF	436.26	438.88	435.34	438.08	16947701.0
2022-02-14 15:00:00	SPY	ETF	438.1	440.2	436.83	439.06	20505214.0
2022-02-14 16:00:00	SPY	ETF	439.06	439.48	438.89	439.1	4955546.0
2022-02-14 17:00:00	SPY	ETF	439.18	439.28	439.0	439.15	27989.0
2022-02-14 18:00:00	SPY	ETF	439.14	439.87	439.02	439.8404	115193.0
2022-02-14 19:00:00	SPY	ETF	439.94	440.06	438.6	439.3899	136895.0
2022-02-14 04:00:00	QQQ	ETF	345.0	345.0	342.58	343.3	195836.0
2022-02-14 05:00:00	QQQ	ETF	343.08	344.5	342.2	343.95	179529.0
2022-02-14 06:00:00	QQQ	ETF	343.72	344.41	343.02	343.9	235686.0
2022-02-14 07:00:00	QQQ	ETF	343.97	347.76	342.97	347.08	1151024.0
2022-02-14 08:00:00	QQQ	ETF	343.6301	348.3	342.6096	345.92	1252763.0
2022-02-14 09:00:00	QQQ	ETF	345.87	349.55	345.52	348.4291	8622197.0
2022-02-14 10:00:00	QQQ	ETF	348.4	349.26	346.4	348.02	10897122.0
2022-02-14 11:00:00	QQQ	ETF	348.01	350.569	347.66	349.66	7272491.0
2022-02-14 12:00:00	QQQ	ETF	349.69	350.98	349.24	349.87	4234685.0
2022-02-14 13:00:00	QQQ	ETF	349.865	350.47	344.77	344.8	6569797.0
2022-02-14 14:00:00	QQQ	ETF	344.81	347.83	343.89	347.04	11069918.0
2022-02-14 15:00:00	QQQ	ETF	347.0	348.56	345.61	347.67	10507157.0
2022-02-14 16:00:00	QQQ	ETF	347.65	348.12	345.9322	347.69	1233264.0
2022-02-14 17:00:00	QQQ	ETF	347.72	347.83	347.49	347.79	46038.0
2022-02-14 18:00:00	QQQ	ETF	347.7	348.69	347.69	348.57	131617.0
2022-02-14 19:00:00	QQQ	ETF	348.63	348.94	347.55	348.3	161851.0
2022-02-14 04:00:00	IWM	ETF	199.36	200.24	199.0	199.35	48072.0
2022-02-14 05:00:00	IWM	ETF	199.1	200.97	198.9	200.29	42357.0
2022-02-14 06:00:00	IWM	ETF	200.06	200.47	199.99	200.47	11900.0
2022-02-14 07:00:00	IWM	ETF	200.44	202.7	199.67	201.81	171852.0
2022-02-14 08:00:00	IWM	ETF	199.8001	202.51	199.8001	201.27	231140.0
2022-02-14 09:00:00	IWM	ETF	201.21	203.53	201.06	202.37	4265804.0
2022-02-14 10:00:00	IWM	ETF	202.36	203.01	200.09	201.16	5271801.0
2022-02-14 11:00:00	IWM	ETF	201.18	202.84	200.96	202.09	2714938.0
2022-02-14 12:00:00	IWM	ETF	202.09	202.39	201.53	201.8	1487734.0
2022-02-14 13:00:00	IWM	ETF	201.8	202.22	199.61	199.74	2069461.0
2022-02-14 14:00:00	IWM	ETF	199.75	201.34	199.24	201.08	3385273.0
2022-02-14 15:00:00	IWM	ETF	201.07	201.7	200.16	200.69	4027266.0
2022-02-14 16:00:00	IWM	ETF	200.7	200.71	200.38	200.6	1189630.0
2022-02-14 17:00:00	IWM	ETF	200.34	200.68	200.34	200.6	203824.0
2022-02-14 18:00:00	IWM	ETF	200.51	201.02	200.46	200.95	60504.0
2022-02-14 19:00:00	IWM	ETF	201.1	201.1	200.05	200.5	52832.0
2022-02-14 04:00:00	DIA	ETF	344.74	345.35	344.2	344.2	12784.0
2022-02-14 05:00:00	DIA	ETF	344.5	345.6	344.5	345.51	780.0

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

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