PREVIEW / etf_1hour / 2024-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-10.parquet
  size:    544 KB
  rows:    20,415

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-04-10 04:00:00	SPY	ETF	519.99	520.21	519.76	520.2	8722.0
2024-04-10 05:00:00	SPY	ETF	520.37	520.37	519.55	519.65	3271.0
2024-04-10 06:00:00	SPY	ETF	519.26	519.91	519.26	519.91	9957.0
2024-04-10 07:00:00	SPY	ETF	519.87	520.2	519.81	520.2	112732.0
2024-04-10 08:00:00	SPY	ETF	519.88	521.35	511.27	512.75	3606244.0
2024-04-10 09:00:00	SPY	ETF	512.72	514.48	511.55	513.985	9580392.0
2024-04-10 10:00:00	SPY	ETF	514.0	516.16	513.41	514.46	9234613.0
2024-04-10 11:00:00	SPY	ETF	514.47	514.53	513.0	513.3499	5589431.0
2024-04-10 12:00:00	SPY	ETF	513.34	514.38	512.98	514.1679	4284356.0
2024-04-10 13:00:00	SPY	ETF	514.1679	515.14	512.09	513.76	11003899.0
2024-04-10 14:00:00	SPY	ETF	513.7804	514.68	512.5651	512.635	6588291.0
2024-04-10 15:00:00	SPY	ETF	512.63	515.07	512.445	514.16	13450433.0
2024-04-10 16:00:00	SPY	ETF	514.15	514.3	513.16	513.98	2252386.0
2024-04-10 17:00:00	SPY	ETF	514.0	514.0	513.8	513.81	80591.0
2024-04-10 18:00:00	SPY	ETF	513.81	513.81	513.25	513.45	89419.0
2024-04-10 19:00:00	SPY	ETF	513.28	513.41	512.87	513.21	57050.0
2024-04-10 04:00:00	QQQ	ETF	442.77	443.41	442.77	443.38	30887.0
2024-04-10 05:00:00	QQQ	ETF	443.38	443.5	442.23	442.23	20277.0
2024-04-10 06:00:00	QQQ	ETF	442.17	442.68	441.86	442.6	47090.0
2024-04-10 07:00:00	QQQ	ETF	442.5	442.88	442.49	442.75	79378.0
2024-04-10 08:00:00	QQQ	ETF	442.49	444.75	434.96	436.1909	2626059.0
2024-04-10 09:00:00	QQQ	ETF	436.25	438.67	435.15	437.98	8870293.0
2024-04-10 10:00:00	QQQ	ETF	438.0	439.24	436.92	437.47	8157630.0
2024-04-10 11:00:00	QQQ	ETF	437.49	438.06	436.68	437.15	3280063.0
2024-04-10 12:00:00	QQQ	ETF	437.14	438.5	436.72	438.27	2915278.0
2024-04-10 13:00:00	QQQ	ETF	438.28	439.04	436.39	437.6532	6795337.0
2024-04-10 14:00:00	QQQ	ETF	437.65	438.39	436.67	436.76	4641230.0
2024-04-10 15:00:00	QQQ	ETF	436.76	439.06	436.52	438.27	8102741.0
2024-04-10 16:00:00	QQQ	ETF	438.27	438.45	437.33	438.32	1644430.0
2024-04-10 17:00:00	QQQ	ETF	438.32	438.37	437.97	438.02	82928.0
2024-04-10 18:00:00	QQQ	ETF	437.97	437.97	437.55	437.78	67811.0
2024-04-10 19:00:00	QQQ	ETF	437.78	437.78	437.14	437.46	56386.0
2024-04-10 04:00:00	IWM	ETF	206.76	207.14	206.67	207.04	12159.0
2024-04-10 05:00:00	IWM	ETF	207.05	207.12	206.51	206.51	6498.0
2024-04-10 06:00:00	IWM	ETF	206.37	206.63	206.37	206.63	4022.0
2024-04-10 07:00:00	IWM	ETF	206.65	207.16	206.6	207.16	40104.0
2024-04-10 08:00:00	IWM	ETF	207.19	207.69	199.36	200.89	2949557.0
2024-04-10 09:00:00	IWM	ETF	200.81	201.53	199.925	201.25	9087585.0
2024-04-10 10:00:00	IWM	ETF	201.24	202.93	200.78	201.41	6705308.0
2024-04-10 11:00:00	IWM	ETF	201.41	201.7	200.705	200.83	3386203.0
2024-04-10 12:00:00	IWM	ETF	200.83	201.17	200.69	201.05	2278883.0
2024-04-10 13:00:00	IWM	ETF	201.06	201.15	199.54	200.51	6307257.0
2024-04-10 14:00:00	IWM	ETF	200.52	200.85	199.72	199.76	2853457.0
2024-04-10 15:00:00	IWM	ETF	199.7695	201.16	199.635	200.9	7106826.0
2024-04-10 16:00:00	IWM	ETF	200.9	200.93	200.37	200.87	1242544.0
2024-04-10 17:00:00	IWM	ETF	200.9	200.93	200.8	200.91	56357.0
2024-04-10 18:00:00	IWM	ETF	200.82	200.82	200.3895	200.6	76264.0
2024-04-10 19:00:00	IWM	ETF	200.58	200.58	200.17	200.3	30892.0
2024-04-10 04:00:00	DIA	ETF	389.17	389.17	389.17	389.17	300.0
2024-04-10 07:00:00	DIA	ETF	389.511	389.63	389.511	389.59	760.0

> showing 50 of 20,415 rows — these rows as CSV

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