PREVIEW / etf_1hour / 2023-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-27.parquet
  size:    497 KB
  rows:    18,026

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
2023-07-27 04:00:00	SPY	ETF	457.44	458.32	457.27	458.31	56250.0
2023-07-27 05:00:00	SPY	ETF	458.25	458.38	458.1	458.21	11514.0
2023-07-27 06:00:00	SPY	ETF	458.17	458.47	458.16	458.2	35104.0
2023-07-27 07:00:00	SPY	ETF	458.2	458.73	458.08	458.65	130081.0
2023-07-27 08:00:00	SPY	ETF	458.09	459.55	456.85	459.04	775586.0
2023-07-27 09:00:00	SPY	ETF	459.03	459.44	458.66	458.9779	6303249.0
2023-07-27 10:00:00	SPY	ETF	458.97	459.05	457.27	457.4799	8264038.0
2023-07-27 11:00:00	SPY	ETF	457.48	458.01	457.065	457.45	4875717.0
2023-07-27 12:00:00	SPY	ETF	457.45	458.5995	457.39	458.384	4882703.0
2023-07-27 13:00:00	SPY	ETF	458.39	458.59	455.7	456.04	9770637.0
2023-07-27 14:00:00	SPY	ETF	456.04	456.22	452.73	452.73	13247139.0
2023-07-27 15:00:00	SPY	ETF	452.73	453.87	451.55	452.48	18412007.0
2023-07-27 16:00:00	SPY	ETF	452.47	454.0105	452.4	452.91	3914421.0
2023-07-27 17:00:00	SPY	ETF	452.96	452.9802	452.82	452.9	46488.0
2023-07-27 18:00:00	SPY	ETF	452.86	452.95	452.7	452.88	57090.0
2023-07-27 19:00:00	SPY	ETF	452.95	453.0	452.65	452.79	34046.0
2023-07-27 04:00:00	QQQ	ETF	381.11	382.34	380.05	382.32	96234.0
2023-07-27 05:00:00	QQQ	ETF	382.28	382.42	381.86	382.24	65013.0
2023-07-27 06:00:00	QQQ	ETF	382.24	382.39	382.03	382.23	42925.0
2023-07-27 07:00:00	QQQ	ETF	382.18	382.63	382.02	382.55	178888.0
2023-07-27 08:00:00	QQQ	ETF	382.1811	383.26	377.803	382.73	673961.0
2023-07-27 09:00:00	QQQ	ETF	382.7	384.71	382.6	383.905	7138645.0
2023-07-27 10:00:00	QQQ	ETF	383.9	384.235	381.31	381.545	7188201.0
2023-07-27 11:00:00	QQQ	ETF	381.56	383.23	381.53	382.0001	3866355.0
2023-07-27 12:00:00	QQQ	ETF	382.01	383.57	381.96	383.04	2898963.0
2023-07-27 13:00:00	QQQ	ETF	383.04	383.35	379.96	380.39	6120462.0
2023-07-27 14:00:00	QQQ	ETF	380.405	380.69	376.17	376.17	9096246.0
2023-07-27 15:00:00	QQQ	ETF	376.17	377.78	375.31	376.54	9547193.0
2023-07-27 16:00:00	QQQ	ETF	376.6	377.32	376.52	377.0	1653715.0
2023-07-27 17:00:00	QQQ	ETF	377.03	377.07	376.83	376.91	75266.0
2023-07-27 18:00:00	QQQ	ETF	376.92	377.2	376.65	377.2	83393.0
2023-07-27 19:00:00	QQQ	ETF	377.22	377.31	376.89	377.12	50418.0
2023-07-27 04:00:00	IWM	ETF	197.26	197.62	197.26	197.38	25883.0
2023-07-27 05:00:00	IWM	ETF	197.36	197.38	197.1	197.1	10072.0
2023-07-27 06:00:00	IWM	ETF	197.09	197.1	196.9	196.95	34690.0
2023-07-27 07:00:00	IWM	ETF	196.98	197.4	196.86	197.37	60712.0
2023-07-27 08:00:00	IWM	ETF	196.99	198.59	196.8	198.15	271404.0
2023-07-27 09:00:00	IWM	ETF	198.1399	198.1399	196.53	197.0188	3585877.0
2023-07-27 10:00:00	IWM	ETF	197.01	197.09	196.2	196.33	2749593.0
2023-07-27 11:00:00	IWM	ETF	196.335	196.52	195.66	195.91	2336786.0
2023-07-27 12:00:00	IWM	ETF	195.92	196.65	195.84	196.47	1460982.0
2023-07-27 13:00:00	IWM	ETF	196.465	196.58	195.005	195.325	2988890.0
2023-07-27 14:00:00	IWM	ETF	195.32	195.4	193.71	193.71	3552281.0
2023-07-27 15:00:00	IWM	ETF	193.69	194.15	193.18	193.92	6045570.0
2023-07-27 16:00:00	IWM	ETF	193.92	194.17	193.86	194.05	1028499.0
2023-07-27 17:00:00	IWM	ETF	194.04	194.17	194.04	194.15	22059.0
2023-07-27 18:00:00	IWM	ETF	194.05	194.09	193.92	193.99	33541.0
2023-07-27 19:00:00	IWM	ETF	194.0	194.06	193.73	193.83	40117.0
2023-07-27 04:00:00	DIA	ETF	355.8	355.86	355.8	355.86	1000.0
2023-07-27 05:00:00	DIA	ETF	355.87	355.87	355.86	355.86	400.0

> showing 50 of 18,026 rows — these rows as CSV

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