PREVIEW / etf_1hour / 2022-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-30.parquet
  size:    456 KB
  rows:    16,817

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-06-30 04:00:00	SPY	ETF	377.48	377.48	375.81	376.02	112801.0
2022-06-30 05:00:00	SPY	ETF	376.08	376.19	374.6	375.82	125696.0
2022-06-30 06:00:00	SPY	ETF	375.8	375.99	374.67	375.51	139132.0
2022-06-30 07:00:00	SPY	ETF	375.55	375.61	374.54	375.01	317277.0
2022-06-30 08:00:00	SPY	ETF	375.5001	379.4	374.56	375.31	1110680.0
2022-06-30 09:00:00	SPY	ETF	375.31	377.0	373.05	373.3421	8953511.0
2022-06-30 10:00:00	SPY	ETF	373.36	375.9	372.56	375.775	10288221.0
2022-06-30 11:00:00	SPY	ETF	375.74	378.43	374.84	378.3413	8749645.0
2022-06-30 12:00:00	SPY	ETF	378.345	380.6582	376.9	379.59	7780471.0
2022-06-30 13:00:00	SPY	ETF	379.585	380.48	377.71	379.835	7581069.0
2022-06-30 14:00:00	SPY	ETF	379.83	380.12	376.74	377.23	7726742.0
2022-06-30 15:00:00	SPY	ETF	377.25	378.7	375.09	377.285	24345213.0
2022-06-30 16:00:00	SPY	ETF	377.285	380.5345	376.18	376.48	6711346.0
2022-06-30 17:00:00	SPY	ETF	376.56	377.25	376.48	376.57	217521.0
2022-06-30 18:00:00	SPY	ETF	376.55	376.64	375.72	376.1	135710.0
2022-06-30 19:00:00	SPY	ETF	376.15	377.49	375.97	377.37	101825.0
2022-06-30 04:00:00	QQQ	ETF	280.84	280.95	279.78	279.91	139242.0
2022-06-30 05:00:00	QQQ	ETF	279.92	279.97	278.42	279.47	182538.0
2022-06-30 06:00:00	QQQ	ETF	279.47	279.55	278.76	279.35	97892.0
2022-06-30 07:00:00	QQQ	ETF	279.43	279.82	278.87	279.17	393322.0
2022-06-30 08:00:00	QQQ	ETF	279.4913	282.9	278.5204	279.75	1396360.0
2022-06-30 09:00:00	QQQ	ETF	279.73	281.5196	276.81	276.92	8830587.0
2022-06-30 10:00:00	QQQ	ETF	276.93	279.24	275.78	279.1	11268997.0
2022-06-30 11:00:00	QQQ	ETF	279.1199	282.18	278.35	282.1097	8065711.0
2022-06-30 12:00:00	QQQ	ETF	282.065	283.89	280.365	282.69	6790695.0
2022-06-30 13:00:00	QQQ	ETF	282.68	283.46	281.0	282.9	5084974.0
2022-06-30 14:00:00	QQQ	ETF	282.92	283.15	280.24	280.59	4802075.0
2022-06-30 15:00:00	QQQ	ETF	280.56	281.88	278.68	280.24	12569664.0
2022-06-30 16:00:00	QQQ	ETF	280.29	281.2524	279.27	279.67	2610571.0
2022-06-30 17:00:00	QQQ	ETF	279.66	280.28	279.62	279.75	1198299.0
2022-06-30 18:00:00	QQQ	ETF	279.75	279.75	278.99	279.28	165714.0
2022-06-30 19:00:00	QQQ	ETF	279.3	280.47	279.14	280.41	120635.0
2022-06-30 04:00:00	IWM	ETF	168.91	169.18	168.53	168.67	22549.0
2022-06-30 05:00:00	IWM	ETF	168.59	168.62	168.01	168.62	38313.0
2022-06-30 06:00:00	IWM	ETF	168.49	168.54	167.81	168.11	102586.0
2022-06-30 07:00:00	IWM	ETF	168.09	168.23	167.63	167.94	71059.0
2022-06-30 08:00:00	IWM	ETF	168.1699	168.9	167.72	168.07	199223.0
2022-06-30 09:00:00	IWM	ETF	168.04	168.855	166.86	167.08	2645834.0
2022-06-30 10:00:00	IWM	ETF	167.08	168.59	166.76	168.47	2492937.0
2022-06-30 11:00:00	IWM	ETF	168.46	169.92	167.98	169.92	2144665.0
2022-06-30 12:00:00	IWM	ETF	169.93	171.31	169.12	170.605	2590090.0
2022-06-30 13:00:00	IWM	ETF	170.61	170.89	169.54	170.44	1596665.0
2022-06-30 14:00:00	IWM	ETF	170.45	170.49	168.99	169.22	1552651.0
2022-06-30 15:00:00	IWM	ETF	169.23	169.67	168.21	169.54	5552569.0
2022-06-30 16:00:00	IWM	ETF	169.51	169.58	168.83	168.89	1474230.0
2022-06-30 17:00:00	IWM	ETF	168.77	169.36	168.77	169.24	963767.0
2022-06-30 18:00:00	IWM	ETF	169.01	169.01	168.39	168.45	25319.0
2022-06-30 19:00:00	IWM	ETF	168.58	169.23	168.39	169.18	31613.0
2022-06-30 04:00:00	DIA	ETF	307.35	307.92	307.23	307.92	2012.0
2022-06-30 05:00:00	DIA	ETF	307.14	307.14	306.37	307.08	2660.0

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

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