PREVIEW / etf_1hour / 2023-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-03.parquet
  size:    488 KB
  rows:    17,875

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-02-03 04:00:00	SPY	ETF	413.6	413.82	412.93	413.45	56040.0
2023-02-03 05:00:00	SPY	ETF	413.42	413.54	412.93	413.44	17865.0
2023-02-03 06:00:00	SPY	ETF	413.03	413.89	412.96	413.5	22157.0
2023-02-03 07:00:00	SPY	ETF	413.59	414.59	413.58	414.52	209611.0
2023-02-03 08:00:00	SPY	ETF	414.5	414.95	411.13	411.9	3173182.0
2023-02-03 09:00:00	SPY	ETF	411.86	414.43	410.84	413.58	8321979.0
2023-02-03 10:00:00	SPY	ETF	413.46	416.7	412.43	415.65	12056703.0
2023-02-03 11:00:00	SPY	ETF	415.665	416.97	414.61	414.8	6847408.0
2023-02-03 12:00:00	SPY	ETF	414.77	416.54	413.92	414.11	4979631.0
2023-02-03 13:00:00	SPY	ETF	414.12	414.27	411.69	412.9792	8744636.0
2023-02-03 14:00:00	SPY	ETF	412.96	413.24	411.555	411.82	6218097.0
2023-02-03 15:00:00	SPY	ETF	411.82	413.01	411.09	412.36	12541257.0
2023-02-03 16:00:00	SPY	ETF	412.37	413.0	411.94	412.19	3813754.0
2023-02-03 17:00:00	SPY	ETF	412.19	412.35	411.85	412.0	623176.0
2023-02-03 18:00:00	SPY	ETF	412.04	412.15	411.9	411.93	29855.0
2023-02-03 19:00:00	SPY	ETF	411.93	411.96	411.42	411.5	46980.0
2023-02-03 04:00:00	QQQ	ETF	305.9	307.25	305.58	306.87	116390.0
2023-02-03 05:00:00	QQQ	ETF	306.84	307.15	306.36	306.95	75468.0
2023-02-03 06:00:00	QQQ	ETF	306.82	307.61	306.5	307.42	203869.0
2023-02-03 07:00:00	QQQ	ETF	307.42	308.92	307.4	308.86	355628.0
2023-02-03 08:00:00	QQQ	ETF	307.45	311.953	304.89	305.33	3608996.0
2023-02-03 09:00:00	QQQ	ETF	305.32	309.38	304.42	308.64	10167933.0
2023-02-03 10:00:00	QQQ	ETF	308.65	311.88	307.33	310.5907	12613265.0
2023-02-03 11:00:00	QQQ	ETF	310.61	312.39	309.73	309.93	6093240.0
2023-02-03 12:00:00	QQQ	ETF	309.9	311.53	308.55	308.75	3850339.0
2023-02-03 13:00:00	QQQ	ETF	308.77	308.94	306.07	307.48	7622730.0
2023-02-03 14:00:00	QQQ	ETF	307.46	307.6298	305.69	305.9416	4922158.0
2023-02-03 15:00:00	QQQ	ETF	305.96	306.97	305.15	306.18	7551485.0
2023-02-03 16:00:00	QQQ	ETF	306.19	306.4	305.82	306.02	1835508.0
2023-02-03 17:00:00	QQQ	ETF	306.04	306.18	305.93	306.1	77542.0
2023-02-03 18:00:00	QQQ	ETF	306.09	306.18	305.89	306.0	40204.0
2023-02-03 19:00:00	QQQ	ETF	305.98	306.04	305.51	305.87	22955.0
2023-02-03 04:00:00	IWM	ETF	198.06	198.45	197.94	198.3	34796.0
2023-02-03 05:00:00	IWM	ETF	198.29	198.32	198.06	198.2	10699.0
2023-02-03 06:00:00	IWM	ETF	198.18	198.36	197.97	198.17	11845.0
2023-02-03 07:00:00	IWM	ETF	198.2	198.32	197.9	198.2	196976.0
2023-02-03 08:00:00	IWM	ETF	198.12	198.2896	196.2	196.53	677511.0
2023-02-03 09:00:00	IWM	ETF	196.52	198.02	195.7	197.48	3546678.0
2023-02-03 10:00:00	IWM	ETF	197.45	199.13	196.8	198.35	3759524.0
2023-02-03 11:00:00	IWM	ETF	198.35	198.9299	197.835	197.93	1635350.0
2023-02-03 12:00:00	IWM	ETF	197.92	199.065	197.74	197.8	1539839.0
2023-02-03 13:00:00	IWM	ETF	197.81	197.845	196.44	196.93	1996961.0
2023-02-03 14:00:00	IWM	ETF	196.92	197.305	196.54	196.7	1127293.0
2023-02-03 15:00:00	IWM	ETF	196.7	197.4	196.16	196.99	3667829.0
2023-02-03 16:00:00	IWM	ETF	196.99	197.0	196.7	196.9	910148.0
2023-02-03 17:00:00	IWM	ETF	196.87	196.99	196.61	196.79	51514.0
2023-02-03 18:00:00	IWM	ETF	196.79	196.89	196.64	196.65	7824.0
2023-02-03 19:00:00	IWM	ETF	196.64	196.8	196.21	196.23	18815.0
2023-02-03 04:00:00	DIA	ETF	339.43	339.62	339.43	339.62	2100.0
2023-02-03 05:00:00	DIA	ETF	339.19	339.3	339.19	339.3	1000.0

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

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