PREVIEW / etf_1hour / 2023-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-18.parquet
  size:    481 KB
  rows:    17,583

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-01-18 04:00:00	SPY	ETF	398.22	398.33	397.77	398.08	18562.0
2023-01-18 05:00:00	SPY	ETF	397.95	398.36	397.72	398.19	31695.0
2023-01-18 06:00:00	SPY	ETF	398.15	398.5	398.1	398.42	104004.0
2023-01-18 07:00:00	SPY	ETF	398.39	399.14	398.39	399.11	302419.0
2023-01-18 08:00:00	SPY	ETF	398.92	400.05	397.9	399.22	1452258.0
2023-01-18 09:00:00	SPY	ETF	399.22	399.69	398.01	399.54	6337578.0
2023-01-18 10:00:00	SPY	ETF	399.54	400.12	396.48	397.25	11598162.0
2023-01-18 11:00:00	SPY	ETF	397.24	397.415	394.21	394.8631	12154649.0
2023-01-18 12:00:00	SPY	ETF	394.86	395.07	393.2	393.36	7314363.0
2023-01-18 13:00:00	SPY	ETF	393.37	394.06	392.53	393.5889	8081334.0
2023-01-18 14:00:00	SPY	ETF	393.59	393.9101	393.05	393.1201	4860346.0
2023-01-18 15:00:00	SPY	ETF	393.13	393.5814	391.28	391.54	16089966.0
2023-01-18 16:00:00	SPY	ETF	391.55	391.62	391.37	391.47	8236100.0
2023-01-18 17:00:00	SPY	ETF	391.53	391.53	391.35	391.37	398741.0
2023-01-18 18:00:00	SPY	ETF	391.35	391.71	391.25	391.54	105509.0
2023-01-18 19:00:00	SPY	ETF	391.5	391.53	390.77	390.86	124127.0
2023-01-18 04:00:00	QQQ	ETF	281.68	281.83	281.34	281.64	47021.0
2023-01-18 05:00:00	QQQ	ETF	281.5	281.95	281.18	281.81	23023.0
2023-01-18 06:00:00	QQQ	ETF	281.75	282.02	281.63	282.0	32492.0
2023-01-18 07:00:00	QQQ	ETF	281.9	282.61	281.87	282.55	150658.0
2023-01-18 08:00:00	QQQ	ETF	281.9533	283.78	281.5	283.05	1243933.0
2023-01-18 09:00:00	QQQ	ETF	283.05	283.9	282.59	283.745	5492550.0
2023-01-18 10:00:00	QQQ	ETF	283.78	284.69	280.49	281.242	7418857.0
2023-01-18 11:00:00	QQQ	ETF	281.22	281.43	278.86	279.64	5143157.0
2023-01-18 12:00:00	QQQ	ETF	279.64	279.85	278.57	278.73	3305965.0
2023-01-18 13:00:00	QQQ	ETF	278.74	279.33	278.01	279.0	3178222.0
2023-01-18 14:00:00	QQQ	ETF	279.02	279.5	278.5	278.995	2153118.0
2023-01-18 15:00:00	QQQ	ETF	278.98	279.4099	277.67	277.865	6994182.0
2023-01-18 16:00:00	QQQ	ETF	277.88	278.02	277.63	277.99	1614601.0
2023-01-18 17:00:00	QQQ	ETF	277.98	277.98	277.56	277.64	110568.0
2023-01-18 18:00:00	QQQ	ETF	277.7	278.06	277.67	277.9	95203.0
2023-01-18 19:00:00	QQQ	ETF	277.89	277.89	277.16	277.25	116892.0
2023-01-18 04:00:00	IWM	ETF	187.07	187.1	186.84	187.03	13265.0
2023-01-18 05:00:00	IWM	ETF	186.95	187.03	186.8	186.91	4353.0
2023-01-18 06:00:00	IWM	ETF	186.91	187.12	186.82	187.09	9036.0
2023-01-18 07:00:00	IWM	ETF	187.01	187.44	187.0	187.4	89618.0
2023-01-18 08:00:00	IWM	ETF	187.0	187.87	186.8	187.67	196765.0
2023-01-18 09:00:00	IWM	ETF	187.64	188.485	187.16	188.44	2250273.0
2023-01-18 10:00:00	IWM	ETF	188.45	188.96	186.84	187.22	3674339.0
2023-01-18 11:00:00	IWM	ETF	187.225	187.41	184.9302	185.395	3013618.0
2023-01-18 12:00:00	IWM	ETF	185.4	185.68	184.51	184.58	1589747.0
2023-01-18 13:00:00	IWM	ETF	184.58	185.685	184.035	185.01	2374204.0
2023-01-18 14:00:00	IWM	ETF	185.025	185.07	184.38	184.46	1640394.0
2023-01-18 15:00:00	IWM	ETF	184.45	184.625	183.695	183.8	3278887.0
2023-01-18 16:00:00	IWM	ETF	183.79	183.95	183.76	183.94	629788.0
2023-01-18 17:00:00	IWM	ETF	183.99	183.99	183.75	183.75	8619.0
2023-01-18 18:00:00	IWM	ETF	183.84	184.07	183.8	183.9	46795.0
2023-01-18 19:00:00	IWM	ETF	183.87	183.87	183.51	183.58	73534.0
2023-01-18 05:00:00	DIA	ETF	339.12	339.12	339.12	339.12	300.0
2023-01-18 07:00:00	DIA	ETF	339.5	339.8	339.5	339.8	2094.0

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

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