PREVIEW / etf_1hour / 2022-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-06.parquet
  size:    463 KB
  rows:    16,777

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-05-06 04:00:00	SPY	ETF	412.58	413.88	411.99	412.58	42157.0
2022-05-06 05:00:00	SPY	ETF	412.36	413.06	411.4	413.06	48825.0
2022-05-06 06:00:00	SPY	ETF	413.04	413.3	411.98	412.35	42909.0
2022-05-06 07:00:00	SPY	ETF	412.38	412.38	410.73	411.84	405999.0
2022-05-06 08:00:00	SPY	ETF	412.05	414.64	410.62	410.8	1652300.0
2022-05-06 09:00:00	SPY	ETF	410.82	411.77	405.73	406.3616	16632237.0
2022-05-06 10:00:00	SPY	ETF	406.35	413.48	405.75	412.77	22485455.0
2022-05-06 11:00:00	SPY	ETF	412.735	414.8	409.5301	409.89	13138533.0
2022-05-06 12:00:00	SPY	ETF	409.88	413.98	409.53	413.79	9167694.0
2022-05-06 13:00:00	SPY	ETF	413.79	414.36	409.79	410.11	9788680.0
2022-05-06 14:00:00	SPY	ETF	410.11	410.75	407.8	408.9399	11812853.0
2022-05-06 15:00:00	SPY	ETF	408.915	412.98	407.36	411.38	22690320.0
2022-05-06 16:00:00	SPY	ETF	411.38	411.53	409.82	410.66	4289511.0
2022-05-06 17:00:00	SPY	ETF	410.39	411.01	410.3	410.51	152154.0
2022-05-06 18:00:00	SPY	ETF	410.6	410.89	410.31	410.67	36072.0
2022-05-06 19:00:00	SPY	ETF	410.64	411.0	410.25	410.7	55953.0
2022-05-06 04:00:00	QQQ	ETF	311.66	313.47	311.66	311.78	205704.0
2022-05-06 05:00:00	QQQ	ETF	311.8	312.42	311.13	312.41	65795.0
2022-05-06 06:00:00	QQQ	ETF	312.36	312.56	311.44	311.5	173817.0
2022-05-06 07:00:00	QQQ	ETF	311.69	311.77	310.19	311.4	376810.0
2022-05-06 08:00:00	QQQ	ETF	311.31	314.2	309.94	310.09	2176505.0
2022-05-06 09:00:00	QQQ	ETF	310.08	311.73	305.105	305.84	18487635.0
2022-05-06 10:00:00	QQQ	ETF	305.85	313.63	305.67	312.98	30983962.0
2022-05-06 11:00:00	QQQ	ETF	312.93	315.09	309.48	309.85	15402083.0
2022-05-06 12:00:00	QQQ	ETF	309.8699	313.56	309.5	313.47	10417271.0
2022-05-06 13:00:00	QQQ	ETF	313.4876	313.81	309.04	309.22	7253105.0
2022-05-06 14:00:00	QQQ	ETF	309.19	309.9	307.25	307.83	8659478.0
2022-05-06 15:00:00	QQQ	ETF	307.86	310.86	306.3	309.4	16237140.0
2022-05-06 16:00:00	QQQ	ETF	309.4	309.65	307.83	308.77	2554338.0
2022-05-06 17:00:00	QQQ	ETF	308.53	309.0	308.53	308.58	94842.0
2022-05-06 18:00:00	QQQ	ETF	308.6	308.8	308.48	308.6	29713.0
2022-05-06 19:00:00	QQQ	ETF	308.6	308.9	308.58	308.9	64754.0
2022-05-06 04:00:00	IWM	ETF	185.37	186.21	185.27	185.51	18261.0
2022-05-06 05:00:00	IWM	ETF	185.57	185.95	185.12	185.95	12597.0
2022-05-06 06:00:00	IWM	ETF	185.81	186.0	185.46	185.6	20791.0
2022-05-06 07:00:00	IWM	ETF	185.5	185.5	184.86	185.13	50059.0
2022-05-06 08:00:00	IWM	ETF	185.54	186.51	184.65	184.6996	215905.0
2022-05-06 09:00:00	IWM	ETF	184.7	185.42	180.82	181.27	4634195.0
2022-05-06 10:00:00	IWM	ETF	181.29	184.45	181.14	184.08	6091648.0
2022-05-06 11:00:00	IWM	ETF	184.07	184.99	182.35	182.52	3348899.0
2022-05-06 12:00:00	IWM	ETF	182.5	185.17	182.24	185.11	3107303.0
2022-05-06 13:00:00	IWM	ETF	185.14	185.23	182.41	182.49	3367183.0
2022-05-06 14:00:00	IWM	ETF	182.47	182.77	181.17	181.6935	4510255.0
2022-05-06 15:00:00	IWM	ETF	181.685	182.98	180.55	182.6	8668978.0
2022-05-06 16:00:00	IWM	ETF	182.58	182.61	181.8	182.32	567018.0
2022-05-06 17:00:00	IWM	ETF	182.27	182.52	182.24	182.49	7786.0
2022-05-06 18:00:00	IWM	ETF	182.26	182.43	182.13	182.33	13524.0
2022-05-06 19:00:00	IWM	ETF	182.47	182.58	182.1	182.48	32343.0
2022-05-06 04:00:00	DIA	ETF	329.7	330.06	329.7	330.06	300.0
2022-05-06 05:00:00	DIA	ETF	329.08	329.51	328.99	329.51	2700.0

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

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