PREVIEW / etf_1hour / 2022-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-27.parquet
  size:    448 KB
  rows:    16,427

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-06-27 04:00:00	SPY	ETF	392.57	392.94	391.02	391.71	65198.0
2022-06-27 05:00:00	SPY	ETF	391.74	391.99	391.35	391.7	49484.0
2022-06-27 06:00:00	SPY	ETF	391.67	391.67	390.68	391.2	43160.0
2022-06-27 07:00:00	SPY	ETF	391.19	391.76	391.1	391.43	216776.0
2022-06-27 08:00:00	SPY	ETF	391.19	392.7196	389.71	390.37	492257.0
2022-06-27 09:00:00	SPY	ETF	390.39	391.36	387.52	388.1	8028431.0
2022-06-27 10:00:00	SPY	ETF	388.13	390.86	387.99	390.382	8331744.0
2022-06-27 11:00:00	SPY	ETF	390.36	391.13	389.39	390.58	5468532.0
2022-06-27 12:00:00	SPY	ETF	390.6	390.745	388.55	389.82	4659207.0
2022-06-27 13:00:00	SPY	ETF	389.82	389.94	388.1	388.3918	4795358.0
2022-06-27 14:00:00	SPY	ETF	388.42	389.37	387.96	388.58	4917614.0
2022-06-27 15:00:00	SPY	ETF	388.59	389.2099	387.44	388.66	11411793.0
2022-06-27 16:00:00	SPY	ETF	388.66	389.33	388.53	389.15	3579758.0
2022-06-27 17:00:00	SPY	ETF	389.27	389.35	388.96	389.15	104204.0
2022-06-27 18:00:00	SPY	ETF	389.15	389.35	388.74	389.01	54183.0
2022-06-27 19:00:00	SPY	ETF	388.95	389.25	388.91	389.09	42457.0
2022-06-27 04:00:00	QQQ	ETF	296.56	297.8	295.66	296.81	140904.0
2022-06-27 05:00:00	QQQ	ETF	296.75	296.96	296.32	296.79	58996.0
2022-06-27 06:00:00	QQQ	ETF	296.79	296.8	295.85	296.2	199456.0
2022-06-27 07:00:00	QQQ	ETF	296.2	296.78	296.13	296.43	321659.0
2022-06-27 08:00:00	QQQ	ETF	296.42	297.75	294.61	295.36	622172.0
2022-06-27 09:00:00	QQQ	ETF	295.35	296.5799	291.92	292.99	7403130.0
2022-06-27 10:00:00	QQQ	ETF	293.0	295.05	292.03	294.76	6846795.0
2022-06-27 11:00:00	QQQ	ETF	294.75	295.13	293.525	294.3402	3782241.0
2022-06-27 12:00:00	QQQ	ETF	294.335	294.52	292.41	293.71	2894253.0
2022-06-27 13:00:00	QQQ	ETF	293.73	293.82	292.17	292.39	2731872.0
2022-06-27 14:00:00	QQQ	ETF	292.39	293.33	292.09	292.63	2375348.0
2022-06-27 15:00:00	QQQ	ETF	292.62	292.965	291.29	292.48	7618474.0
2022-06-27 16:00:00	QQQ	ETF	292.51	293.35	291.6	293.2	7335826.0
2022-06-27 17:00:00	QQQ	ETF	293.13	293.4	293.1	293.1	82667.0
2022-06-27 18:00:00	QQQ	ETF	293.18	293.38	292.74	292.96	78197.0
2022-06-27 19:00:00	QQQ	ETF	293.0	293.22	292.8	293.05	81635.0
2022-06-27 04:00:00	IWM	ETF	175.09	176.43	175.09	175.71	36594.0
2022-06-27 05:00:00	IWM	ETF	175.73	175.89	175.46	175.73	9468.0
2022-06-27 06:00:00	IWM	ETF	175.76	175.76	175.26	175.62	7230.0
2022-06-27 07:00:00	IWM	ETF	175.55	175.9	175.55	175.68	49442.0
2022-06-27 08:00:00	IWM	ETF	175.62	175.82	174.59	175.18	179196.0
2022-06-27 09:00:00	IWM	ETF	175.18	176.51	174.18	174.79	3127141.0
2022-06-27 10:00:00	IWM	ETF	174.8	176.6266	174.32	176.4	3482993.0
2022-06-27 11:00:00	IWM	ETF	176.43	176.99	176.14	176.42	2320807.0
2022-06-27 12:00:00	IWM	ETF	176.43	176.5	175.35	176.35	1643410.0
2022-06-27 13:00:00	IWM	ETF	176.33	176.475	175.645	175.95	1460002.0
2022-06-27 14:00:00	IWM	ETF	175.94	176.55	175.755	176.22	1525234.0
2022-06-27 15:00:00	IWM	ETF	176.22	176.49	175.27	175.79	4277182.0
2022-06-27 16:00:00	IWM	ETF	175.74	176.18	175.74	175.96	756074.0
2022-06-27 17:00:00	IWM	ETF	175.93	176.2	175.85	175.98	4066.0
2022-06-27 18:00:00	IWM	ETF	176.0	176.01	175.78	175.95	6494.0
2022-06-27 19:00:00	IWM	ETF	175.86	176.06	175.86	176.01	12736.0
2022-06-27 04:00:00	DIA	ETF	316.5	316.85	316.23	316.23	7098.0
2022-06-27 05:00:00	DIA	ETF	316.12	316.12	316.02	316.02	1300.0

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

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