PREVIEW / etf_1hour / 2023-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-30.parquet
  size:    460 KB
  rows:    16,964

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-03-30 04:00:00	SPY	ETF	402.78	403.14	402.12	402.98	70783.0
2023-03-30 05:00:00	SPY	ETF	402.98	403.12	402.81	402.98	31553.0
2023-03-30 06:00:00	SPY	ETF	403.05	403.85	403.05	403.75	73392.0
2023-03-30 07:00:00	SPY	ETF	403.75	403.96	403.41	403.67	178038.0
2023-03-30 08:00:00	SPY	ETF	403.75	404.18	401.5	403.93	571571.0
2023-03-30 09:00:00	SPY	ETF	403.92	404.25	403.48	404.07	6563765.0
2023-03-30 10:00:00	SPY	ETF	404.08	404.35	402.8144	403.59	9931250.0
2023-03-30 11:00:00	SPY	ETF	403.61	404.035	402.73	403.08	6351018.0
2023-03-30 12:00:00	SPY	ETF	403.075	403.26	402.06	402.37	5376210.0
2023-03-30 13:00:00	SPY	ETF	402.39	402.83	401.76	402.33	4916812.0
2023-03-30 14:00:00	SPY	ETF	402.33	403.49	402.25	403.1401	5993569.0
2023-03-30 15:00:00	SPY	ETF	403.15	403.78	402.875	403.7	12160503.0
2023-03-30 16:00:00	SPY	ETF	403.7	404.17	403.68	403.96	2705046.0
2023-03-30 17:00:00	SPY	ETF	403.96	404.0	403.81	403.82	73570.0
2023-03-30 18:00:00	SPY	ETF	403.81	403.81	403.44	403.73	59596.0
2023-03-30 19:00:00	SPY	ETF	403.75	404.23	403.7	404.22	42368.0
2023-03-30 04:00:00	QQQ	ETF	313.4	313.74	313.38	313.62	41774.0
2023-03-30 05:00:00	QQQ	ETF	313.68	313.96	313.6	313.89	32977.0
2023-03-30 06:00:00	QQQ	ETF	313.91	314.5	313.85	314.42	39650.0
2023-03-30 07:00:00	QQQ	ETF	314.39	314.67	314.28	314.46	154688.0
2023-03-30 08:00:00	QQQ	ETF	314.46	315.3	312.59	314.92	677256.0
2023-03-30 09:00:00	QQQ	ETF	314.9	315.59	314.52	315.55	5653758.0
2023-03-30 10:00:00	QQQ	ETF	315.56	316.24	314.32	315.66	8117700.0
2023-03-30 11:00:00	QQQ	ETF	315.675	316.32	315.15	315.51	4942515.0
2023-03-30 12:00:00	QQQ	ETF	315.515	315.66	314.555	314.85	4021611.0
2023-03-30 13:00:00	QQQ	ETF	314.855	315.245	313.93	314.406	3870127.0
2023-03-30 14:00:00	QQQ	ETF	314.435	315.55	314.3103	315.25	3400287.0
2023-03-30 15:00:00	QQQ	ETF	315.24	315.84	314.98	315.68	5224534.0
2023-03-30 16:00:00	QQQ	ETF	315.695	316.03	315.4846	315.8	2027939.0
2023-03-30 17:00:00	QQQ	ETF	315.82	315.83	315.6	315.6	50075.0
2023-03-30 18:00:00	QQQ	ETF	315.63	315.65	315.4	315.63	83351.0
2023-03-30 19:00:00	QQQ	ETF	315.61	316.03	315.6	315.98	50353.0
2023-03-30 04:00:00	IWM	ETF	176.0	176.58	176.0	176.49	15324.0
2023-03-30 05:00:00	IWM	ETF	176.46	176.56	176.31	176.49	12720.0
2023-03-30 06:00:00	IWM	ETF	176.4	177.07	176.4	177.07	55687.0
2023-03-30 07:00:00	IWM	ETF	177.07	177.12	176.81	176.88	51999.0
2023-03-30 08:00:00	IWM	ETF	177.03	177.0996	175.46	176.84	153430.0
2023-03-30 09:00:00	IWM	ETF	176.96	177.305	176.44	177.08	3413348.0
2023-03-30 10:00:00	IWM	ETF	177.08	177.19	175.91	176.09	3161495.0
2023-03-30 11:00:00	IWM	ETF	176.09	176.39	175.17	175.39	2745891.0
2023-03-30 12:00:00	IWM	ETF	175.4	175.44	174.68	174.95	2197775.0
2023-03-30 13:00:00	IWM	ETF	174.95	175.23	174.445	174.855	1597970.0
2023-03-30 14:00:00	IWM	ETF	174.85	175.275	174.78	174.99	1576315.0
2023-03-30 15:00:00	IWM	ETF	174.99	175.295	174.705	175.16	3340782.0
2023-03-30 16:00:00	IWM	ETF	175.18	175.45	175.12	175.29	810033.0
2023-03-30 17:00:00	IWM	ETF	175.42	175.42	175.18	175.24	16021.0
2023-03-30 18:00:00	IWM	ETF	175.15	175.24	174.95	175.24	61025.0
2023-03-30 19:00:00	IWM	ETF	175.24	175.49	175.24	175.45	36767.0
2023-03-30 04:00:00	DIA	ETF	328.13	328.56	328.13	328.56	1600.0
2023-03-30 06:00:00	DIA	ETF	329.09	329.14	329.09	329.14	1400.0

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

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