PREVIEW / etf_1hour / 2023-06-05

all etf 1-hour files

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

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-05 04:00:00	SPY	ETF	427.98	428.18	427.76	427.84	16206.0
2023-06-05 05:00:00	SPY	ETF	427.84	427.95	427.72	427.81	9306.0
2023-06-05 06:00:00	SPY	ETF	427.8	428.15	427.71	428.14	15894.0
2023-06-05 07:00:00	SPY	ETF	428.12	428.24	427.93	428.01	71037.0
2023-06-05 08:00:00	SPY	ETF	428.1212	428.24	427.29	427.93	188054.0
2023-06-05 09:00:00	SPY	ETF	427.94	429.67	427.89	428.2799	3956350.0
2023-06-05 10:00:00	SPY	ETF	428.26	429.46	427.63	428.58	7877158.0
2023-06-05 11:00:00	SPY	ETF	428.575	429.16	428.38	428.934	5146204.0
2023-06-05 12:00:00	SPY	ETF	428.95	429.5699	428.51	429.5603	3984875.0
2023-06-05 13:00:00	SPY	ETF	429.56	429.62	428.04	428.4999	6327205.0
2023-06-05 14:00:00	SPY	ETF	428.51	428.56	426.38	427.65	8948139.0
2023-06-05 15:00:00	SPY	ETF	427.66	427.79	426.37	427.1	12738220.0
2023-06-05 16:00:00	SPY	ETF	427.08	427.38	427.04	427.05	2155718.0
2023-06-05 17:00:00	SPY	ETF	427.02	427.27	427.01	427.11	118616.0
2023-06-05 18:00:00	SPY	ETF	427.11	427.11	426.62	426.7	96010.0
2023-06-05 19:00:00	SPY	ETF	426.69	426.89	426.5	426.64	22058.0
2023-06-05 04:00:00	QQQ	ETF	353.52	354.65	353.52	353.7	19135.0
2023-06-05 05:00:00	QQQ	ETF	353.79	353.94	353.55	353.64	11701.0
2023-06-05 06:00:00	QQQ	ETF	353.6	354.05	353.5	354.02	30442.0
2023-06-05 07:00:00	QQQ	ETF	354.03	354.33	353.86	354.15	137343.0
2023-06-05 08:00:00	QQQ	ETF	354.05	354.4498	353.1	354.2	276745.0
2023-06-05 09:00:00	QQQ	ETF	354.25	356.45	354.18	355.1301	5526009.0
2023-06-05 10:00:00	QQQ	ETF	355.21	356.935	354.97	356.765	6543082.0
2023-06-05 11:00:00	QQQ	ETF	356.79	357.34	356.27	356.8799	3437789.0
2023-06-05 12:00:00	QQQ	ETF	356.89	357.44	356.365	357.41	3237361.0
2023-06-05 13:00:00	QQQ	ETF	357.41	357.495	355.45	355.99	4146831.0
2023-06-05 14:00:00	QQQ	ETF	356.015	356.1399	353.86	355.41	5919235.0
2023-06-05 15:00:00	QQQ	ETF	355.41	355.54	353.85	354.9	6293070.0
2023-06-05 16:00:00	QQQ	ETF	354.89	355.03	354.8	354.81	966907.0
2023-06-05 17:00:00	QQQ	ETF	354.8	354.96	354.8	354.85	87654.0
2023-06-05 18:00:00	QQQ	ETF	354.86	354.86	354.35	354.35	95201.0
2023-06-05 19:00:00	QQQ	ETF	354.39	354.61	354.2	354.36	41356.0
2023-06-05 04:00:00	IWM	ETF	182.15	182.27	181.8	181.83	7050.0
2023-06-05 05:00:00	IWM	ETF	181.88	181.92	181.6	181.6	6672.0
2023-06-05 06:00:00	IWM	ETF	181.66	181.97	181.52	181.96	22617.0
2023-06-05 07:00:00	IWM	ETF	181.91	181.92	181.51	181.54	45612.0
2023-06-05 08:00:00	IWM	ETF	181.59	182.26	181.2	181.23	294965.0
2023-06-05 09:00:00	IWM	ETF	181.23	181.77	179.87	180.21	4688215.0
2023-06-05 10:00:00	IWM	ETF	180.21	180.71	178.44	179.2491	6449790.0
2023-06-05 11:00:00	IWM	ETF	179.25	180.29	179.23	180.0	3119580.0
2023-06-05 12:00:00	IWM	ETF	180.0	180.63	179.7401	180.6	2084758.0
2023-06-05 13:00:00	IWM	ETF	180.61	180.63	179.7	180.24	2218374.0
2023-06-05 14:00:00	IWM	ETF	180.24	180.245	179.1	179.68	3520994.0
2023-06-05 15:00:00	IWM	ETF	179.695	179.87	179.23	179.54	5859278.0
2023-06-05 16:00:00	IWM	ETF	179.53	179.82	179.39	179.67	1494785.0
2023-06-05 17:00:00	IWM	ETF	179.65	179.9	179.58	179.84	1306976.0
2023-06-05 18:00:00	IWM	ETF	179.76	179.76	179.27	179.27	67019.0
2023-06-05 19:00:00	IWM	ETF	179.28	179.49	179.24	179.3	12079.0
2023-06-05 04:00:00	DIA	ETF	338.68	338.68	338.68	338.68	152.0
2023-06-05 05:00:00	DIA	ETF	338.46	338.46	338.46	338.46	100.0

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

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