PREVIEW / etf_1hour / 2024-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-09.parquet
  size:    535 KB
  rows:    19,581

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
2024-02-09 04:00:00	SPY	ETF	498.96	498.97	498.67	498.84	12916.0
2024-02-09 05:00:00	SPY	ETF	498.83	499.22	498.83	499.03	15738.0
2024-02-09 06:00:00	SPY	ETF	499.0	499.28	498.91	499.25	19910.0
2024-02-09 07:00:00	SPY	ETF	499.2	499.54	499.2	499.35	76019.0
2024-02-09 08:00:00	SPY	ETF	499.19	501.08	498.28	499.9	742305.0
2024-02-09 09:00:00	SPY	ETF	499.889	499.92	498.49	499.5	4926683.0
2024-02-09 10:00:00	SPY	ETF	499.5	500.02	499.135	499.96	7003154.0
2024-02-09 11:00:00	SPY	ETF	499.97	500.21	499.32	499.58	5109516.0
2024-02-09 12:00:00	SPY	ETF	499.58	500.485	499.38	500.47	4988183.0
2024-02-09 13:00:00	SPY	ETF	500.465	500.94	500.3	500.715	4606385.0
2024-02-09 14:00:00	SPY	ETF	500.7188	501.65	500.66	501.285	5636319.0
2024-02-09 15:00:00	SPY	ETF	501.29	501.34	500.69	501.18	11421815.0
2024-02-09 16:00:00	SPY	ETF	501.18	501.2748	499.5697	500.96	3048266.0
2024-02-09 17:00:00	SPY	ETF	501.03	501.12	500.95	501.0	56226.0
2024-02-09 18:00:00	SPY	ETF	500.99	501.03	500.92	500.94	43112.0
2024-02-09 19:00:00	SPY	ETF	500.92	501.03	500.9	501.0	13057.0
2024-02-09 04:00:00	QQQ	ETF	432.8	434.18	432.8	433.86	28389.0
2024-02-09 05:00:00	QQQ	ETF	433.84	434.26	433.83	434.05	17053.0
2024-02-09 06:00:00	QQQ	ETF	434.09	434.28	433.76	434.17	19692.0
2024-02-09 07:00:00	QQQ	ETF	434.19	434.69	434.11	434.11	73785.0
2024-02-09 08:00:00	QQQ	ETF	434.33	435.45	432.97	434.49	590684.0
2024-02-09 09:00:00	QQQ	ETF	434.45	434.77	433.1401	434.71	3179723.0
2024-02-09 10:00:00	QQQ	ETF	434.725	436.06	434.28	435.97	4976355.0
2024-02-09 11:00:00	QQQ	ETF	435.99	436.32	435.341	435.95	3404666.0
2024-02-09 12:00:00	QQQ	ETF	435.96	436.785	435.62	436.72	2130803.0
2024-02-09 13:00:00	QQQ	ETF	436.72	437.22	436.62	437.051	2725899.0
2024-02-09 14:00:00	QQQ	ETF	437.05	437.845	436.85	437.47	2699459.0
2024-02-09 15:00:00	QQQ	ETF	437.48	437.505	436.885	437.08	4919627.0
2024-02-09 16:00:00	QQQ	ETF	437.08	437.14	436.83	437.04	1243951.0
2024-02-09 17:00:00	QQQ	ETF	437.03	437.03	436.91	436.92	45235.0
2024-02-09 18:00:00	QQQ	ETF	436.94	436.98	436.9	436.98	4342.0
2024-02-09 19:00:00	QQQ	ETF	436.97	437.3	436.97	437.23	15099.0
2024-02-09 04:00:00	IWM	ETF	196.19	196.65	196.08	196.65	17934.0
2024-02-09 05:00:00	IWM	ETF	196.63	196.93	196.52	196.78	13485.0
2024-02-09 06:00:00	IWM	ETF	196.91	197.34	196.91	197.11	24431.0
2024-02-09 07:00:00	IWM	ETF	197.14	197.31	196.87	196.95	98632.0
2024-02-09 08:00:00	IWM	ETF	197.11	198.63	196.13	197.51	707380.0
2024-02-09 09:00:00	IWM	ETF	197.45	197.77	196.45	197.25	4403271.0
2024-02-09 10:00:00	IWM	ETF	197.26	197.66	196.485	197.36	4277187.0
2024-02-09 11:00:00	IWM	ETF	197.36	197.675	196.9	197.475	3278903.0
2024-02-09 12:00:00	IWM	ETF	197.48	198.705	197.37	198.64	4260064.0
2024-02-09 13:00:00	IWM	ETF	198.64	199.547	198.58	199.12	4846325.0
2024-02-09 14:00:00	IWM	ETF	199.12	199.42	198.73	198.76	3889925.0
2024-02-09 15:00:00	IWM	ETF	198.77	199.45	198.515	199.38	7347980.0
2024-02-09 16:00:00	IWM	ETF	199.34	199.45	199.02	199.05	1553063.0
2024-02-09 17:00:00	IWM	ETF	199.06	199.3	199.06	199.2	62460.0
2024-02-09 18:00:00	IWM	ETF	199.25	199.33	199.23	199.32	12568.0
2024-02-09 19:00:00	IWM	ETF	199.32	199.35	199.25	199.35	6605.0
2024-02-09 07:00:00	DIA	ETF	387.66	387.66	387.66	387.66	100.0
2024-02-09 08:00:00	DIA	ETF	387.66	388.99	387.6196	388.2	9180.0

> showing 50 of 19,581 rows — these rows as CSV

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