PREVIEW / etf_1hour / 2023-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-11.parquet
  size:    462 KB
  rows:    16,809

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
2023-05-11 04:00:00	SPY	ETF	414.1	414.51	413.86	414.1	34597.0
2023-05-11 05:00:00	SPY	ETF	414.17	414.55	413.94	414.18	13532.0
2023-05-11 06:00:00	SPY	ETF	414.3	414.3	413.66	413.66	100502.0
2023-05-11 07:00:00	SPY	ETF	413.6	413.69	412.26	412.44	517440.0
2023-05-11 08:00:00	SPY	ETF	412.7695	414.53	412.31	412.5	1149490.0
2023-05-11 09:00:00	SPY	ETF	412.5	412.5	410.16	410.3095	8013674.0
2023-05-11 10:00:00	SPY	ETF	410.32	411.41	409.97	411.32	10308995.0
2023-05-11 11:00:00	SPY	ETF	411.36	412.01	410.955	411.855	6517574.0
2023-05-11 12:00:00	SPY	ETF	411.86	412.25	411.28	412.01	4622858.0
2023-05-11 13:00:00	SPY	ETF	412.01	412.09	410.27	411.3299	5589290.0
2023-05-11 14:00:00	SPY	ETF	411.33	412.43	410.935	412.23	5503392.0
2023-05-11 15:00:00	SPY	ETF	412.2322	412.32	411.46	412.16	10165318.0
2023-05-11 16:00:00	SPY	ETF	412.16	412.35	411.93	412.32	2454566.0
2023-05-11 17:00:00	SPY	ETF	412.3	412.31	412.1	412.1	295007.0
2023-05-11 18:00:00	SPY	ETF	412.1	412.7	412.1	412.63	238854.0
2023-05-11 19:00:00	SPY	ETF	412.63	412.64	412.39	412.4	28839.0
2023-05-11 04:00:00	QQQ	ETF	325.69	326.49	325.69	326.25	34663.0
2023-05-11 05:00:00	QQQ	ETF	326.28	326.53	326.05	326.33	18430.0
2023-05-11 06:00:00	QQQ	ETF	326.4	326.51	325.92	325.92	15042.0
2023-05-11 07:00:00	QQQ	ETF	325.87	325.94	325.15	325.46	173399.0
2023-05-11 08:00:00	QQQ	ETF	325.5212	326.65	325.15	325.89	896326.0
2023-05-11 09:00:00	QQQ	ETF	325.84	325.85	324.38	324.705	5912099.0
2023-05-11 10:00:00	QQQ	ETF	324.73	325.52	324.12	325.5	6192072.0
2023-05-11 11:00:00	QQQ	ETF	325.5	326.265	325.15	326.06	4379544.0
2023-05-11 12:00:00	QQQ	ETF	326.07	326.49	325.5	326.28	3356002.0
2023-05-11 13:00:00	QQQ	ETF	326.3	326.38	324.91	325.7	3780829.0
2023-05-11 14:00:00	QQQ	ETF	325.71	326.75	325.47	326.599	3163892.0
2023-05-11 15:00:00	QQQ	ETF	326.6	326.71	325.7933	326.19	4383247.0
2023-05-11 16:00:00	QQQ	ETF	326.18	326.26	324.897	326.17	1098470.0
2023-05-11 17:00:00	QQQ	ETF	326.2	326.3	326.04	326.2	40513.0
2023-05-11 18:00:00	QQQ	ETF	326.19	326.62	326.19	326.59	56234.0
2023-05-11 19:00:00	QQQ	ETF	326.5699	326.58	326.34	326.41	48005.0
2023-05-11 04:00:00	IWM	ETF	175.27	175.3	175.08	175.15	14490.0
2023-05-11 05:00:00	IWM	ETF	175.17	175.23	174.92	175.05	8549.0
2023-05-11 06:00:00	IWM	ETF	175.11	175.12	174.83	174.95	16542.0
2023-05-11 07:00:00	IWM	ETF	174.81	174.83	173.62	173.74	262891.0
2023-05-11 08:00:00	IWM	ETF	175.2996	175.3	173.62	173.67	425751.0
2023-05-11 09:00:00	IWM	ETF	173.61	173.78	172.69	173.3	3372038.0
2023-05-11 10:00:00	IWM	ETF	173.3	173.375	172.11	172.55	4464315.0
2023-05-11 11:00:00	IWM	ETF	172.55	173.07	172.305	172.91	1839600.0
2023-05-11 12:00:00	IWM	ETF	172.92	173.1259	172.57	172.965	1478590.0
2023-05-11 13:00:00	IWM	ETF	172.97	173.08	172.17	172.755	1502474.0
2023-05-11 14:00:00	IWM	ETF	172.77	173.2	172.455	173.07	1226446.0
2023-05-11 15:00:00	IWM	ETF	173.08	173.16	172.7	173.05	3276431.0
2023-05-11 16:00:00	IWM	ETF	173.07	173.2	172.89	173.2	1827281.0
2023-05-11 17:00:00	IWM	ETF	173.17	173.19	173.07	173.07	6688.0
2023-05-11 18:00:00	IWM	ETF	173.19	173.38	173.19	173.36	30887.0
2023-05-11 19:00:00	IWM	ETF	173.35	173.39	173.1	173.1	29016.0
2023-05-11 06:00:00	DIA	ETF	335.91	335.95	335.59	335.59	1371.0
2023-05-11 07:00:00	DIA	ETF	335.45	335.45	334.4	334.54	5884.0

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

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