PREVIEW / etf_1hour / 2023-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-17.parquet
  size:    468 KB
  rows:    17,133

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-05-17 04:00:00	SPY	ETF	410.76	411.45	410.73	411.25	30203.0
2023-05-17 05:00:00	SPY	ETF	411.4	411.6	411.14	411.58	25046.0
2023-05-17 06:00:00	SPY	ETF	411.48	411.67	411.18	411.65	114674.0
2023-05-17 07:00:00	SPY	ETF	411.64	412.01	411.61	411.79	221568.0
2023-05-17 08:00:00	SPY	ETF	411.7005	412.18	410.3	412.16	363038.0
2023-05-17 09:00:00	SPY	ETF	412.18	412.46	410.25	410.78	5935368.0
2023-05-17 10:00:00	SPY	ETF	410.78	411.93	410.64	411.88	5760374.0
2023-05-17 11:00:00	SPY	ETF	411.88	412.835	411.21	412.59	8074297.0
2023-05-17 12:00:00	SPY	ETF	412.58	414.66	412.42	414.43	7234367.0
2023-05-17 13:00:00	SPY	ETF	414.43	415.855	414.43	415.75	10444479.0
2023-05-17 14:00:00	SPY	ETF	415.76	415.83	414.51	414.57	6359674.0
2023-05-17 15:00:00	SPY	ETF	414.56	415.51	414.45	415.21	15555747.0
2023-05-17 16:00:00	SPY	ETF	415.19	415.29	414.95	415.07	3430403.0
2023-05-17 17:00:00	SPY	ETF	414.95	415.3	414.95	415.18	144436.0
2023-05-17 18:00:00	SPY	ETF	415.18	415.18	414.78	414.93	219738.0
2023-05-17 19:00:00	SPY	ETF	414.92	415.0	414.84	414.97	35222.0
2023-05-17 04:00:00	QQQ	ETF	327.33	327.96	327.31	327.8	32107.0
2023-05-17 05:00:00	QQQ	ETF	327.8	327.9	327.53	327.89	12776.0
2023-05-17 06:00:00	QQQ	ETF	327.88	327.88	327.42	327.79	30893.0
2023-05-17 07:00:00	QQQ	ETF	327.79	328.1	327.78	328.0	127010.0
2023-05-17 08:00:00	QQQ	ETF	327.8591	328.15	326.915	328.15	248961.0
2023-05-17 09:00:00	QQQ	ETF	328.14	328.61	327.04	327.14	5069593.0
2023-05-17 10:00:00	QQQ	ETF	327.13	328.585	327.1	328.5	4419543.0
2023-05-17 11:00:00	QQQ	ETF	328.51	329.14	327.78	328.96	4463781.0
2023-05-17 12:00:00	QQQ	ETF	328.96	330.41	328.56	330.18	4416868.0
2023-05-17 13:00:00	QQQ	ETF	330.19	331.71	330.19	331.68	5580336.0
2023-05-17 14:00:00	QQQ	ETF	331.6701	331.685	330.68	330.75	3623641.0
2023-05-17 15:00:00	QQQ	ETF	330.74	331.56	330.52	331.17	7647631.0
2023-05-17 16:00:00	QQQ	ETF	331.16	331.38	330.94	331.09	1233885.0
2023-05-17 17:00:00	QQQ	ETF	331.09	331.16	331.03	331.09	42628.0
2023-05-17 18:00:00	QQQ	ETF	331.09	331.17	330.99	331.08	76478.0
2023-05-17 19:00:00	QQQ	ETF	331.06	331.18	330.9	331.11	70077.0
2023-05-17 04:00:00	IWM	ETF	172.68	173.02	172.65	172.9	22140.0
2023-05-17 05:00:00	IWM	ETF	173.0	173.06	172.86	173.05	5680.0
2023-05-17 06:00:00	IWM	ETF	173.06	173.2	172.9	173.2	36765.0
2023-05-17 07:00:00	IWM	ETF	173.17	173.35	173.06	173.16	50093.0
2023-05-17 08:00:00	IWM	ETF	173.29	173.5	172.37	173.48	98297.0
2023-05-17 09:00:00	IWM	ETF	173.49	173.64	172.22	172.28	2424286.0
2023-05-17 10:00:00	IWM	ETF	172.27	173.86	172.16	173.8	3104873.0
2023-05-17 11:00:00	IWM	ETF	173.795	174.93	173.735	174.665	4446067.0
2023-05-17 12:00:00	IWM	ETF	174.665	175.91	174.57	175.76	3558144.0
2023-05-17 13:00:00	IWM	ETF	175.77	176.4	175.76	176.26	3632295.0
2023-05-17 14:00:00	IWM	ETF	176.26	176.335	175.68	175.81	3300480.0
2023-05-17 15:00:00	IWM	ETF	175.81	176.5	175.79	176.21	7541419.0
2023-05-17 16:00:00	IWM	ETF	176.12	176.28	176.06	176.14	1413864.0
2023-05-17 17:00:00	IWM	ETF	176.13	176.3	176.1	176.23	275625.0
2023-05-17 18:00:00	IWM	ETF	176.16	176.29	176.12	176.21	25284.0
2023-05-17 19:00:00	IWM	ETF	176.21	176.22	176.12	176.21	11400.0
2023-05-17 04:00:00	DIA	ETF	331.0	331.0	331.0	331.0	100.0
2023-05-17 05:00:00	DIA	ETF	331.2	331.27	331.2	331.27	1000.0

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

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