PREVIEW / etf_1hour / 2023-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-06.parquet
  size:    478 KB
  rows:    17,296

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-06-06 04:00:00	SPY	ETF	427.02	427.52	426.64	426.76	26844.0
2023-06-06 05:00:00	SPY	ETF	426.76	426.96	426.51	426.79	10472.0
2023-06-06 06:00:00	SPY	ETF	426.83	426.94	426.67	426.87	16468.0
2023-06-06 07:00:00	SPY	ETF	426.84	427.14	426.77	426.98	44639.0
2023-06-06 08:00:00	SPY	ETF	426.8416	427.42	426.65	426.87	122745.0
2023-06-06 09:00:00	SPY	ETF	426.88	427.16	425.99	426.6	4669629.0
2023-06-06 10:00:00	SPY	ETF	426.6	428.445	426.51	428.09	8807293.0
2023-06-06 11:00:00	SPY	ETF	428.1	428.28	426.86	428.15	5456448.0
2023-06-06 12:00:00	SPY	ETF	428.15	428.45	426.73	426.91	4900257.0
2023-06-06 13:00:00	SPY	ETF	426.92	427.86	426.565	426.86	5315457.0
2023-06-06 14:00:00	SPY	ETF	426.87	427.755	426.565	427.7	4750474.0
2023-06-06 15:00:00	SPY	ETF	427.7	428.5772	427.48	428.04	12613769.0
2023-06-06 16:00:00	SPY	ETF	428.04	428.38	427.6406	428.27	2170595.0
2023-06-06 17:00:00	SPY	ETF	428.23	428.52	428.15	428.4	169356.0
2023-06-06 18:00:00	SPY	ETF	428.36	428.38	428.0	428.17	96309.0
2023-06-06 19:00:00	SPY	ETF	428.14	428.53	428.14	428.48	99616.0
2023-06-06 04:00:00	QQQ	ETF	354.62	355.5	354.62	354.8	21592.0
2023-06-06 05:00:00	QQQ	ETF	354.91	354.95	354.69	354.84	10611.0
2023-06-06 06:00:00	QQQ	ETF	354.76	354.8	354.41	354.8	13035.0
2023-06-06 07:00:00	QQQ	ETF	354.77	355.14	354.65	354.9	65454.0
2023-06-06 08:00:00	QQQ	ETF	354.7616	355.1	354.05	354.58	410909.0
2023-06-06 09:00:00	QQQ	ETF	354.57	354.87	352.93	353.9296	5125566.0
2023-06-06 10:00:00	QQQ	ETF	353.93	355.41	353.4401	355.05	5667972.0
2023-06-06 11:00:00	QQQ	ETF	355.07	355.62	353.8	355.51	5154174.0
2023-06-06 12:00:00	QQQ	ETF	355.52	355.82	353.49	353.61	3992066.0
2023-06-06 13:00:00	QQQ	ETF	353.62	354.78	353.57	354.09	3637856.0
2023-06-06 14:00:00	QQQ	ETF	354.09	354.96	353.91	354.89	2428499.0
2023-06-06 15:00:00	QQQ	ETF	354.9	355.33	354.29	354.86	5732007.0
2023-06-06 16:00:00	QQQ	ETF	354.87	355.19	354.73	355.11	1106910.0
2023-06-06 17:00:00	QQQ	ETF	355.12	355.28	354.84	355.13	173310.0
2023-06-06 18:00:00	QQQ	ETF	355.15	355.15	354.66	354.76	48799.0
2023-06-06 19:00:00	QQQ	ETF	354.69	355.2	354.69	355.14	28222.0
2023-06-06 04:00:00	IWM	ETF	179.76	179.93	179.31	179.4	6231.0
2023-06-06 05:00:00	IWM	ETF	179.37	179.65	179.24	179.59	4149.0
2023-06-06 06:00:00	IWM	ETF	179.52	179.7	179.5	179.52	10971.0
2023-06-06 07:00:00	IWM	ETF	179.67	179.68	179.39	179.45	18314.0
2023-06-06 08:00:00	IWM	ETF	179.5882	179.64	179.27	179.38	50518.0
2023-06-06 09:00:00	IWM	ETF	179.4	181.035	178.93	180.86	4448749.0
2023-06-06 10:00:00	IWM	ETF	180.87	183.76	180.87	183.74	8579132.0
2023-06-06 11:00:00	IWM	ETF	183.735	184.93	183.51	184.74	7396513.0
2023-06-06 12:00:00	IWM	ETF	184.735	184.96	183.66	183.78	4242501.0
2023-06-06 13:00:00	IWM	ETF	183.79	184.275	183.46	183.735	3362217.0
2023-06-06 14:00:00	IWM	ETF	183.745	184.36	183.475	184.3	3094544.0
2023-06-06 15:00:00	IWM	ETF	184.32	184.72	184.16	184.31	7542470.0
2023-06-06 16:00:00	IWM	ETF	184.31	184.63	184.29	184.47	3033439.0
2023-06-06 17:00:00	IWM	ETF	184.47	184.49	184.23	184.34	149248.0
2023-06-06 18:00:00	IWM	ETF	184.36	184.43	184.28	184.4	58418.0
2023-06-06 19:00:00	IWM	ETF	184.39	184.6296	184.39	184.58	40739.0
2023-06-06 04:00:00	DIA	ETF	336.19	336.34	336.08	336.08	3100.0
2023-06-06 05:00:00	DIA	ETF	335.72	335.72	335.69	335.69	250.0

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

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