PREVIEW / etf_1hour / 2022-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-13.parquet
  size:    439 KB
  rows:    16,145

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-07-13 04:00:00	SPY	ETF	380.8	382.2	380.42	382.15	28003.0
2022-07-13 05:00:00	SPY	ETF	382.14	382.2	381.79	381.83	13886.0
2022-07-13 06:00:00	SPY	ETF	381.75	381.75	381.14	381.61	62913.0
2022-07-13 07:00:00	SPY	ETF	381.61	382.25	381.41	382.11	240846.0
2022-07-13 08:00:00	SPY	ETF	381.52	385.71	373.18	375.71	4174207.0
2022-07-13 09:00:00	SPY	ETF	375.59	378.14	374.658	377.57	9621915.0
2022-07-13 10:00:00	SPY	ETF	377.55	380.2	375.05	379.58	11571494.0
2022-07-13 11:00:00	SPY	ETF	379.6	380.87	377.99	378.7501	7110618.0
2022-07-13 12:00:00	SPY	ETF	378.76	380.83	378.59	380.81	4477121.0
2022-07-13 13:00:00	SPY	ETF	380.83	381.92	379.89	380.84	5656841.0
2022-07-13 14:00:00	SPY	ETF	380.8299	381.41	378.55	381.38	7927368.0
2022-07-13 15:00:00	SPY	ETF	381.41	381.46	378.86	378.87	10967688.0
2022-07-13 16:00:00	SPY	ETF	378.87	379.0017	378.01	378.15	3302172.0
2022-07-13 17:00:00	SPY	ETF	378.2	378.2	378.0	378.09	62689.0
2022-07-13 18:00:00	SPY	ETF	378.03	378.08	376.89	377.16	157548.0
2022-07-13 19:00:00	SPY	ETF	377.13	377.58	376.1	376.44	113723.0
2022-07-13 04:00:00	QQQ	ETF	286.59	287.6	286.06	287.6	53901.0
2022-07-13 05:00:00	QQQ	ETF	287.6	287.6	287.13	287.13	41296.0
2022-07-13 06:00:00	QQQ	ETF	287.11	287.17	286.66	287.14	60740.0
2022-07-13 07:00:00	QQQ	ETF	287.12	287.61	286.83	287.45	266718.0
2022-07-13 08:00:00	QQQ	ETF	286.9301	290.6	279.03	281.0	5367256.0
2022-07-13 09:00:00	QQQ	ETF	280.95	284.99	280.02	283.845	11357473.0
2022-07-13 10:00:00	QQQ	ETF	283.85	287.54	281.88	286.45	11985818.0
2022-07-13 11:00:00	QQQ	ETF	286.51	287.49	284.455	285.4731	5683415.0
2022-07-13 12:00:00	QQQ	ETF	285.47	287.23	285.15	287.2192	3611102.0
2022-07-13 13:00:00	QQQ	ETF	287.22	288.05	286.339	287.29	3936135.0
2022-07-13 14:00:00	QQQ	ETF	287.29	287.68	285.25	287.63	5408251.0
2022-07-13 15:00:00	QQQ	ETF	287.66	287.71	285.58	285.62	6734247.0
2022-07-13 16:00:00	QQQ	ETF	285.63	285.78	284.96	285.05	5934317.0
2022-07-13 17:00:00	QQQ	ETF	285.05	285.63	285.02	285.1	576028.0
2022-07-13 18:00:00	QQQ	ETF	285.07	285.09	284.0	284.27	200768.0
2022-07-13 19:00:00	QQQ	ETF	284.27	284.57	283.45	283.72	221343.0
2022-07-13 04:00:00	IWM	ETF	171.63	172.2	171.32	172.2	13069.0
2022-07-13 05:00:00	IWM	ETF	172.23	172.34	172.11	172.11	13306.0
2022-07-13 06:00:00	IWM	ETF	172.12	172.17	171.79	172.06	8483.0
2022-07-13 07:00:00	IWM	ETF	172.04	172.36	171.92	172.31	28407.0
2022-07-13 08:00:00	IWM	ETF	172.06	174.27	168.62	169.58	705069.0
2022-07-13 09:00:00	IWM	ETF	169.48	171.47	168.85	170.4	5405132.0
2022-07-13 10:00:00	IWM	ETF	170.37	171.82	168.79	171.63	3819731.0
2022-07-13 11:00:00	IWM	ETF	171.63	172.23	170.31	170.73	2266717.0
2022-07-13 12:00:00	IWM	ETF	170.73	171.69	170.67	171.65	998340.0
2022-07-13 13:00:00	IWM	ETF	171.65	172.16	171.41	172.05	1151834.0
2022-07-13 14:00:00	IWM	ETF	172.03	172.27	171.03	172.245	2012196.0
2022-07-13 15:00:00	IWM	ETF	172.25	172.275	171.22	171.33	2953626.0
2022-07-13 16:00:00	IWM	ETF	171.32	171.42	170.92	171.02	779655.0
2022-07-13 17:00:00	IWM	ETF	171.17	171.17	170.83	171.0	9021.0
2022-07-13 18:00:00	IWM	ETF	170.91	171.0	170.29	170.5	46919.0
2022-07-13 19:00:00	IWM	ETF	170.5	170.57	169.83	170.06	35303.0
2022-07-13 06:00:00	DIA	ETF	310.54	310.54	310.54	310.54	200.0
2022-07-13 07:00:00	DIA	ETF	310.4	310.71	310.36	310.71	3400.0

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

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