PREVIEW / etf_1hour / 2022-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-26.parquet
  size:    471 KB
  rows:    17,011

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-26 04:00:00	SPY	ETF	436.0	440.51	436.0	439.52	91963.0
2022-01-26 05:00:00	SPY	ETF	439.43	440.39	438.81	440.01	46022.0
2022-01-26 06:00:00	SPY	ETF	440.49	441.25	439.96	441.25	357228.0
2022-01-26 07:00:00	SPY	ETF	441.23	441.3	439.37	440.01	495905.0
2022-01-26 08:00:00	SPY	ETF	440.87	441.72	434.1	441.06	1112869.0
2022-01-26 09:00:00	SPY	ETF	441.06	442.35	438.79	441.95	10998814.0
2022-01-26 10:00:00	SPY	ETF	441.97	443.0978	437.54	439.12	15794100.0
2022-01-26 11:00:00	SPY	ETF	439.1	441.4001	438.25	440.6999	9943895.0
2022-01-26 12:00:00	SPY	ETF	440.7	442.12	440.54	441.92	7322547.0
2022-01-26 13:00:00	SPY	ETF	441.91	442.02	440.04	440.74	8635161.0
2022-01-26 14:00:00	SPY	ETF	440.7404	444.04	434.41	436.34	36487707.0
2022-01-26 15:00:00	SPY	ETF	436.32	436.3499	428.86	433.46	48203936.0
2022-01-26 16:00:00	SPY	ETF	433.46	433.79	432.1	433.24	4292021.0
2022-01-26 17:00:00	SPY	ETF	433.45	434.71	433.2	434.1	302514.0
2022-01-26 18:00:00	SPY	ETF	434.2	436.22	433.38	435.91	241953.0
2022-01-26 19:00:00	SPY	ETF	436.03	436.09	432.4	432.95	211684.0
2022-01-26 04:00:00	QQQ	ETF	347.0	352.04	347.0	351.15	382799.0
2022-01-26 05:00:00	QQQ	ETF	350.99	351.83	350.32	351.33	83987.0
2022-01-26 06:00:00	QQQ	ETF	351.28	352.6	351.28	352.56	185851.0
2022-01-26 07:00:00	QQQ	ETF	352.53	352.55	350.38	351.44	551431.0
2022-01-26 08:00:00	QQQ	ETF	351.45	353.62	345.12	352.62	1195871.0
2022-01-26 09:00:00	QQQ	ETF	352.4	353.47	349.8501	352.365	8209957.0
2022-01-26 10:00:00	QQQ	ETF	352.37	353.83	349.23	350.8	11949952.0
2022-01-26 11:00:00	QQQ	ETF	350.8	352.83	349.62	352.2051	6457897.0
2022-01-26 12:00:00	QQQ	ETF	352.21	354.6372	352.05	354.3201	6021810.0
2022-01-26 13:00:00	QQQ	ETF	354.34	354.43	352.58	352.98	6473063.0
2022-01-26 14:00:00	QQQ	ETF	352.98	356.88	346.04	347.7079	32009490.0
2022-01-26 15:00:00	QQQ	ETF	347.69	347.69	340.78	344.98	31937584.0
2022-01-26 16:00:00	QQQ	ETF	344.98	345.43	342.71	345.0	3010861.0
2022-01-26 17:00:00	QQQ	ETF	345.0	347.49	344.57	346.2	1285224.0
2022-01-26 18:00:00	QQQ	ETF	346.15	348.17	345.95	347.77	486351.0
2022-01-26 19:00:00	QQQ	ETF	347.89	347.94	345.1001	345.22	517642.0
2022-01-26 04:00:00	IWM	ETF	200.64	201.7	200.64	201.32	24639.0
2022-01-26 05:00:00	IWM	ETF	201.01	201.75	201.01	201.67	13552.0
2022-01-26 06:00:00	IWM	ETF	201.79	202.61	201.69	202.61	67786.0
2022-01-26 07:00:00	IWM	ETF	202.53	202.53	201.6	201.62	113739.0
2022-01-26 08:00:00	IWM	ETF	202.11	202.46	198.75	201.75	473493.0
2022-01-26 09:00:00	IWM	ETF	201.7	202.76	200.51	202.75	4486023.0
2022-01-26 10:00:00	IWM	ETF	202.76	203.37	200.11	200.86	6216155.0
2022-01-26 11:00:00	IWM	ETF	200.84	202.19	200.5099	201.88	4174825.0
2022-01-26 12:00:00	IWM	ETF	201.89	202.4	201.52	202.29	2269028.0
2022-01-26 13:00:00	IWM	ETF	202.32	202.34	201.3	201.8201	2942480.0
2022-01-26 14:00:00	IWM	ETF	201.865	203.55	197.83	198.28	17168687.0
2022-01-26 15:00:00	IWM	ETF	198.26	198.28	193.72	196.0	16512046.0
2022-01-26 16:00:00	IWM	ETF	195.97	196.05	195.14	195.58	1491073.0
2022-01-26 17:00:00	IWM	ETF	195.88	195.97	195.42	195.75	315456.0
2022-01-26 18:00:00	IWM	ETF	195.79	196.93	195.71	196.76	124832.0
2022-01-26 19:00:00	IWM	ETF	196.81	196.9	194.78	194.81	99293.0
2022-01-26 04:00:00	DIA	ETF	345.64	346.01	345.64	345.93	2408.0
2022-01-26 05:00:00	DIA	ETF	345.68	346.34	345.67	346.34	5500.0

> showing 50 of 17,011 rows — these rows as CSV

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