PREVIEW / etf_1hour / 2021-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-03.parquet
  size:    450 KB
  rows:    16,047

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
2021-12-03 04:00:00	SPY	ETF	456.27	457.42	456.27	456.84	13209.0
2021-12-03 05:00:00	SPY	ETF	456.95	456.95	455.5	455.88	28655.0
2021-12-03 06:00:00	SPY	ETF	455.99	457.0	455.79	457.0	45971.0
2021-12-03 07:00:00	SPY	ETF	457.0	457.9	456.86	457.67	235378.0
2021-12-03 08:00:00	SPY	ETF	457.69	459.8	455.62	458.91	1221787.0
2021-12-03 09:00:00	SPY	ETF	458.96	460.3	455.12	455.4	10438574.0
2021-12-03 10:00:00	SPY	ETF	455.42	456.13	451.62	451.95	16440343.0
2021-12-03 11:00:00	SPY	ETF	451.98	453.64	450.4	450.5165	14002747.0
2021-12-03 12:00:00	SPY	ETF	450.53	453.25	450.13	451.8	9855469.0
2021-12-03 13:00:00	SPY	ETF	451.78	453.14	450.3132	450.53	8689571.0
2021-12-03 14:00:00	SPY	ETF	450.5	451.5	449.435	449.64	12613567.0
2021-12-03 15:00:00	SPY	ETF	449.64	453.67	448.92	453.43	27619290.0
2021-12-03 16:00:00	SPY	ETF	453.44	453.99	452.46	452.97	5145492.0
2021-12-03 17:00:00	SPY	ETF	453.04	454.15	452.87	454.15	275956.0
2021-12-03 18:00:00	SPY	ETF	454.15	454.85	453.42	454.05	117978.0
2021-12-03 19:00:00	SPY	ETF	454.155	454.4	453.43	453.53	67838.0
2021-12-03 04:00:00	QQQ	ETF	389.21	389.77	388.71	389.05	36451.0
2021-12-03 05:00:00	QQQ	ETF	389.13	389.13	388.1	388.54	17654.0
2021-12-03 06:00:00	QQQ	ETF	388.56	389.63	388.55	389.61	21285.0
2021-12-03 07:00:00	QQQ	ETF	389.72	390.7	389.5	390.6	187286.0
2021-12-03 08:00:00	QQQ	ETF	390.52	393.08	388.24	391.24	1074329.0
2021-12-03 09:00:00	QQQ	ETF	391.32	392.34	386.0	386.29	7668087.0
2021-12-03 10:00:00	QQQ	ETF	386.38	386.96	381.74	382.55	17824679.0
2021-12-03 11:00:00	QQQ	ETF	382.55	383.32	379.89	380.05	15059730.0
2021-12-03 12:00:00	QQQ	ETF	380.05	382.43	379.43	381.17	8996454.0
2021-12-03 13:00:00	QQQ	ETF	381.13	382.439	379.5598	379.9327	7029758.0
2021-12-03 14:00:00	QQQ	ETF	379.91	381.4	379.15	379.65	8216183.0
2021-12-03 15:00:00	QQQ	ETF	379.66	383.86	378.9	383.21	16157760.0
2021-12-03 16:00:00	QQQ	ETF	383.21	383.82	382.17	382.46	3652234.0
2021-12-03 17:00:00	QQQ	ETF	382.5	383.13	382.46	383.02	318328.0
2021-12-03 18:00:00	QQQ	ETF	382.94	383.06	382.76	382.7601	21738.0
2021-12-03 19:00:00	QQQ	ETF	382.83	382.94	382.35	382.35	25869.0
2021-12-03 04:00:00	IWM	ETF	218.95	219.6	218.8	219.06	20895.0
2021-12-03 05:00:00	IWM	ETF	219.11	219.22	217.96	218.25	11176.0
2021-12-03 06:00:00	IWM	ETF	218.43	219.14	218.11	219.14	20523.0
2021-12-03 07:00:00	IWM	ETF	219.21	219.76	219.14	219.42	53902.0
2021-12-03 08:00:00	IWM	ETF	219.65	220.88	218.9	220.31	361543.0
2021-12-03 09:00:00	IWM	ETF	220.33	220.72	215.71	216.41	5285313.0
2021-12-03 10:00:00	IWM	ETF	216.44	217.37	214.25	214.95	7986258.0
2021-12-03 11:00:00	IWM	ETF	214.95	216.2	213.62	213.71	7017323.0
2021-12-03 12:00:00	IWM	ETF	213.75	215.92	213.36	214.75	5582851.0
2021-12-03 13:00:00	IWM	ETF	214.71	215.83	213.775	214.0	4996592.0
2021-12-03 14:00:00	IWM	ETF	213.99	214.6287	212.91	213.14	6557806.0
2021-12-03 15:00:00	IWM	ETF	213.15	214.975	212.71	214.67	10610018.0
2021-12-03 16:00:00	IWM	ETF	214.68	214.95	213.97	214.25	2152582.0
2021-12-03 17:00:00	IWM	ETF	214.38	214.8	214.2	214.62	74620.0
2021-12-03 18:00:00	IWM	ETF	214.7	214.88	214.51	214.71	17081.0
2021-12-03 19:00:00	IWM	ETF	214.67	214.73	214.25	214.25	7137.0
2021-12-03 04:00:00	DIA	ETF	347.02	347.02	346.96	347.02	1395.0
2021-12-03 05:00:00	DIA	ETF	346.4	346.4	345.65	345.81	1440.0

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

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