PREVIEW / etf_1hour / 2022-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-13.parquet
  size:    458 KB
  rows:    16,776

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-09-13 04:00:00	SPY	ETF	412.42	412.87	412.42	412.67	31875.0
2022-09-13 05:00:00	SPY	ETF	412.55	412.82	412.3	412.52	24991.0
2022-09-13 06:00:00	SPY	ETF	412.55	413.64	412.44	413.64	38411.0
2022-09-13 07:00:00	SPY	ETF	413.5	413.99	413.5	413.78	309954.0
2022-09-13 08:00:00	SPY	ETF	413.6982	415.02	401.99	401.99	5889909.0
2022-09-13 09:00:00	SPY	ETF	401.98	403.1	400.81	400.9	11320159.0
2022-09-13 10:00:00	SPY	ETF	400.91	401.06	398.02	398.4101	12780654.0
2022-09-13 11:00:00	SPY	ETF	398.43	398.82	397.63	397.885	6681767.0
2022-09-13 12:00:00	SPY	ETF	397.88	399.12	397.6	398.4	5646175.0
2022-09-13 13:00:00	SPY	ETF	398.39	399.66	397.96	398.41	5182907.0
2022-09-13 14:00:00	SPY	ETF	398.42	398.56	395.59	395.87	6904679.0
2022-09-13 15:00:00	SPY	ETF	395.87	396.09	391.92	393.13	26313255.0
2022-09-13 16:00:00	SPY	ETF	393.15	393.85	393.01	393.56	8162457.0
2022-09-13 17:00:00	SPY	ETF	393.6	393.89	393.5	393.81	103907.0
2022-09-13 18:00:00	SPY	ETF	393.75	394.37	393.24	394.02	154892.0
2022-09-13 19:00:00	SPY	ETF	394.02	394.06	393.22	393.91	85793.0
2022-09-13 04:00:00	QQQ	ETF	312.0	312.25	311.84	311.86	51573.0
2022-09-13 05:00:00	QQQ	ETF	311.9	312.02	311.6	311.87	20462.0
2022-09-13 06:00:00	QQQ	ETF	311.77	312.64	311.77	312.63	25493.0
2022-09-13 07:00:00	QQQ	ETF	312.56	313.13	312.55	312.9	192230.0
2022-09-13 08:00:00	QQQ	ETF	312.6	313.94	301.83	301.85	5775074.0
2022-09-13 09:00:00	QQQ	ETF	301.82	303.02	300.15	300.19	9399905.0
2022-09-13 10:00:00	QQQ	ETF	300.2	300.71	297.82	298.26	8595806.0
2022-09-13 11:00:00	QQQ	ETF	298.265	298.48	297.14	297.5	4861805.0
2022-09-13 12:00:00	QQQ	ETF	297.47	298.54	297.17	297.9	4171023.0
2022-09-13 13:00:00	QQQ	ETF	297.88	298.94	297.54	297.82	4586046.0
2022-09-13 14:00:00	QQQ	ETF	297.83	298.0	295.77	295.97	5284840.0
2022-09-13 15:00:00	QQQ	ETF	295.97	296.1699	292.785	293.62	15040462.0
2022-09-13 16:00:00	QQQ	ETF	293.65	294.07	293.34	293.82	3114660.0
2022-09-13 17:00:00	QQQ	ETF	293.69	294.02	293.69	293.889	220942.0
2022-09-13 18:00:00	QQQ	ETF	293.91	294.44	293.4	294.25	262634.0
2022-09-13 19:00:00	QQQ	ETF	294.25	294.25	293.63	294.1	169495.0
2022-09-13 04:00:00	IWM	ETF	190.65	190.8	190.56	190.65	10807.0
2022-09-13 05:00:00	IWM	ETF	190.61	190.67	190.4	190.65	11272.0
2022-09-13 06:00:00	IWM	ETF	190.5	191.06	190.45	191.06	4425.0
2022-09-13 07:00:00	IWM	ETF	190.97	191.25	190.95	191.14	63891.0
2022-09-13 08:00:00	IWM	ETF	191.18	191.37	184.9	184.91	1045173.0
2022-09-13 09:00:00	IWM	ETF	184.85	185.91	184.2	185.25	3108369.0
2022-09-13 10:00:00	IWM	ETF	185.25	185.86	183.47	183.85	3525387.0
2022-09-13 11:00:00	IWM	ETF	183.88	184.1	183.31	183.76	3062867.0
2022-09-13 12:00:00	IWM	ETF	183.77	184.38	183.37	183.65	1721407.0
2022-09-13 13:00:00	IWM	ETF	183.63	184.37	183.33	183.69	1921424.0
2022-09-13 14:00:00	IWM	ETF	183.69	183.81	182.65	182.84	2377873.0
2022-09-13 15:00:00	IWM	ETF	182.84	182.97	181.535	182.23	5761417.0
2022-09-13 16:00:00	IWM	ETF	182.25	182.51	181.93	182.2	787081.0
2022-09-13 17:00:00	IWM	ETF	182.23	182.42	182.23	182.3	48368.0
2022-09-13 18:00:00	IWM	ETF	182.37	182.49	182.04	182.34	52845.0
2022-09-13 19:00:00	IWM	ETF	182.31	182.4	181.92	182.4	56012.0
2022-09-13 04:00:00	DIA	ETF	325.87	325.87	325.87	325.87	100.0
2022-09-13 05:00:00	DIA	ETF	325.66	325.72	325.66	325.72	600.0

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

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