PREVIEW / etf_1hour / 2022-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-19.parquet
  size:    459 KB
  rows:    16,338

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-19 04:00:00	SPY	ETF	438.99	439.51	437.39	437.39	82183.0
2022-04-19 05:00:00	SPY	ETF	437.46	437.46	436.38	436.42	142757.0
2022-04-19 06:00:00	SPY	ETF	436.79	437.54	436.44	437.54	50613.0
2022-04-19 07:00:00	SPY	ETF	437.59	438.2	437.32	438.11	146512.0
2022-04-19 08:00:00	SPY	ETF	437.5	439.95	436.5796	437.71	488310.0
2022-04-19 09:00:00	SPY	ETF	437.7	441.4599	436.9	441.42	7281884.0
2022-04-19 10:00:00	SPY	ETF	441.4	443.85	441.15	443.16	9968360.0
2022-04-19 11:00:00	SPY	ETF	443.16	444.28	442.76	443.71	6552654.0
2022-04-19 12:00:00	SPY	ETF	443.72	444.03	443.09	443.3801	4377435.0
2022-04-19 13:00:00	SPY	ETF	443.375	443.87	442.65	443.57	3970131.0
2022-04-19 14:00:00	SPY	ETF	443.57	443.86	442.44	443.785	5171046.0
2022-04-19 15:00:00	SPY	ETF	443.78	445.8	443.53	445.01	18865402.0
2022-04-19 16:00:00	SPY	ETF	444.99	445.11	442.52	443.2	5293753.0
2022-04-19 17:00:00	SPY	ETF	443.25	443.25	442.94	443.06	153063.0
2022-04-19 18:00:00	SPY	ETF	443.11	443.92	443.01	443.61	166720.0
2022-04-19 19:00:00	SPY	ETF	443.61	443.61	443.1	443.42	78153.0
2022-04-19 04:00:00	QQQ	ETF	340.46	340.46	337.66	337.75	198666.0
2022-04-19 05:00:00	QQQ	ETF	337.74	337.89	336.9	337.6	199717.0
2022-04-19 06:00:00	QQQ	ETF	337.67	338.45	337.21	338.38	125665.0
2022-04-19 07:00:00	QQQ	ETF	338.4	339.28	338.16	339.11	312860.0
2022-04-19 08:00:00	QQQ	ETF	337.3196	341.33	337.1696	338.53	699804.0
2022-04-19 09:00:00	QQQ	ETF	338.51	341.46	336.98	341.41	7060429.0
2022-04-19 10:00:00	QQQ	ETF	341.39	344.74	341.03	344.29	7580882.0
2022-04-19 11:00:00	QQQ	ETF	344.3	345.78	343.81	345.24	4840281.0
2022-04-19 12:00:00	QQQ	ETF	345.27	345.3	344.24	344.81	3719166.0
2022-04-19 13:00:00	QQQ	ETF	344.8	345.13	344.02	344.8	3501866.0
2022-04-19 14:00:00	QQQ	ETF	344.8	344.95	343.48	344.805	4040115.0
2022-04-19 15:00:00	QQQ	ETF	344.82	346.85	344.545	346.13	10391970.0
2022-04-19 16:00:00	QQQ	ETF	346.19	346.26	342.55	343.25	3053079.0
2022-04-19 17:00:00	QQQ	ETF	343.23	343.37	342.62	342.97	252407.0
2022-04-19 18:00:00	QQQ	ETF	343.04	343.78	342.95	343.31	237266.0
2022-04-19 19:00:00	QQQ	ETF	343.32	343.32	342.61	342.9	185205.0
2022-04-19 04:00:00	IWM	ETF	198.6	198.61	197.69	197.7	13371.0
2022-04-19 05:00:00	IWM	ETF	197.67	197.7	196.96	197.14	68065.0
2022-04-19 06:00:00	IWM	ETF	197.18	197.58	196.98	197.58	36049.0
2022-04-19 07:00:00	IWM	ETF	197.61	198.02	197.55	197.98	131648.0
2022-04-19 08:00:00	IWM	ETF	197.7999	198.07	197.7	197.78	131243.0
2022-04-19 09:00:00	IWM	ETF	197.77	199.72	197.46	199.71	2421974.0
2022-04-19 10:00:00	IWM	ETF	199.69	201.53	199.34	201.125	2867578.0
2022-04-19 11:00:00	IWM	ETF	201.125	202.11	200.87	201.95	2389593.0
2022-04-19 12:00:00	IWM	ETF	201.92	202.235	201.76	201.89	1397474.0
2022-04-19 13:00:00	IWM	ETF	201.88	202.14	201.525	201.95	1262473.0
2022-04-19 14:00:00	IWM	ETF	201.94	202.01	201.155	201.39	1692472.0
2022-04-19 15:00:00	IWM	ETF	201.38	202.07	201.08	201.64	3397263.0
2022-04-19 16:00:00	IWM	ETF	201.56	201.95	200.67	201.47	1676522.0
2022-04-19 17:00:00	IWM	ETF	201.49	201.5	200.99	201.1	100615.0
2022-04-19 18:00:00	IWM	ETF	201.1	201.72	201.1	201.59	92785.0
2022-04-19 19:00:00	IWM	ETF	201.59	201.59	201.38	201.57	28238.0
2022-04-19 04:00:00	DIA	ETF	344.91	344.97	344.91	344.97	200.0
2022-04-19 05:00:00	DIA	ETF	343.79	343.79	343.79	343.79	400.0

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

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