PREVIEW / etf_1hour / 2022-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-17.parquet
  size:    470 KB
  rows:    17,152

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-11-17 04:00:00	SPY	ETF	396.27	396.41	394.49	394.77	101245.0
2022-11-17 05:00:00	SPY	ETF	394.9	395.45	393.35	393.35	54116.0
2022-11-17 06:00:00	SPY	ETF	393.26	393.76	392.33	393.33	134776.0
2022-11-17 07:00:00	SPY	ETF	393.38	393.53	391.98	392.17	366098.0
2022-11-17 08:00:00	SPY	ETF	393.47	397.12	390.27	390.36	1355548.0
2022-11-17 09:00:00	SPY	ETF	390.36	391.7	390.04	390.3744	6843364.0
2022-11-17 10:00:00	SPY	ETF	390.33	392.2	390.14	390.56	7948516.0
2022-11-17 11:00:00	SPY	ETF	390.541	393.18	390.29	393.14	6609381.0
2022-11-17 12:00:00	SPY	ETF	393.1401	394.548	392.73	394.26	6410626.0
2022-11-17 13:00:00	SPY	ETF	394.26	394.95	393.69	394.2111	5286021.0
2022-11-17 14:00:00	SPY	ETF	394.22	394.65	392.5	393.15	5487537.0
2022-11-17 15:00:00	SPY	ETF	393.1339	394.365	391.64	394.28	11533287.0
2022-11-17 16:00:00	SPY	ETF	394.27	394.86	393.99	394.81	6166443.0
2022-11-17 17:00:00	SPY	ETF	394.7508	395.0	394.65	394.9	98043.0
2022-11-17 18:00:00	SPY	ETF	394.88	395.16	394.07	394.07	130100.0
2022-11-17 19:00:00	SPY	ETF	394.18	394.66	394.0	394.66	135012.0
2022-11-17 04:00:00	QQQ	ETF	287.0	287.0	284.89	285.04	69305.0
2022-11-17 05:00:00	QQQ	ETF	285.24	285.64	283.68	283.81	105041.0
2022-11-17 06:00:00	QQQ	ETF	283.67	284.22	283.18	284.11	144270.0
2022-11-17 07:00:00	QQQ	ETF	284.15	284.23	282.71	282.87	409621.0
2022-11-17 08:00:00	QQQ	ETF	284.07	287.5	281.08	281.16	1351451.0
2022-11-17 09:00:00	QQQ	ETF	281.13	282.97	280.36	281.83	6069424.0
2022-11-17 10:00:00	QQQ	ETF	281.82	283.8557	281.42	282.23	5951606.0
2022-11-17 11:00:00	QQQ	ETF	282.22	284.78	282.06	284.74	4963263.0
2022-11-17 12:00:00	QQQ	ETF	284.75	286.05	284.06	285.69	4278676.0
2022-11-17 13:00:00	QQQ	ETF	285.7	286.3189	285.18	285.63	3678223.0
2022-11-17 14:00:00	QQQ	ETF	285.64	285.88	283.64	284.12	4155266.0
2022-11-17 15:00:00	QQQ	ETF	284.11	284.91	282.7	284.82	7833466.0
2022-11-17 16:00:00	QQQ	ETF	284.82	285.69	284.68	285.63	2008953.0
2022-11-17 17:00:00	QQQ	ETF	285.63	285.75	284.81	285.61	114719.0
2022-11-17 18:00:00	QQQ	ETF	285.65	285.94	284.98	284.98	131571.0
2022-11-17 19:00:00	QQQ	ETF	285.02	285.44	284.94	285.44	78253.0
2022-11-17 04:00:00	IWM	ETF	184.13	184.21	183.33	183.38	18059.0
2022-11-17 05:00:00	IWM	ETF	183.4	183.75	182.76	182.76	5747.0
2022-11-17 06:00:00	IWM	ETF	182.7	182.94	182.2	182.76	59219.0
2022-11-17 07:00:00	IWM	ETF	182.84	183.0	182.08	182.19	37332.0
2022-11-17 08:00:00	IWM	ETF	182.8875	185.02	181.31	181.38	115388.0
2022-11-17 09:00:00	IWM	ETF	181.38	181.87	180.58	180.7	2546667.0
2022-11-17 10:00:00	IWM	ETF	180.7	182.0	180.51	181.1	1938324.0
2022-11-17 11:00:00	IWM	ETF	181.1	181.62	180.69	181.59	1856826.0
2022-11-17 12:00:00	IWM	ETF	181.59	182.74	181.38	182.62	1692395.0
2022-11-17 13:00:00	IWM	ETF	182.63	182.95	181.9	182.09	1725595.0
2022-11-17 14:00:00	IWM	ETF	182.1	182.3335	181.36	182.05	1109746.0
2022-11-17 15:00:00	IWM	ETF	182.05	182.7	181.0818	182.61	3274130.0
2022-11-17 16:00:00	IWM	ETF	182.54	182.85	182.34	182.85	1117071.0
2022-11-17 17:00:00	IWM	ETF	182.8	183.1	182.54	183.01	127999.0
2022-11-17 18:00:00	IWM	ETF	183.0	183.02	182.45	182.54	49740.0
2022-11-17 19:00:00	IWM	ETF	182.55	182.91	182.49	182.91	30143.0
2022-11-17 04:00:00	DIA	ETF	336.49	336.49	335.4	335.4	578.0
2022-11-17 05:00:00	DIA	ETF	335.57	335.57	334.4	334.4	550.0

> showing 50 of 17,152 rows — these rows as CSV

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