PREVIEW / etf_1hour / 2023-05-01

all etf 1-hour files

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

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-01 04:00:00	SPY	ETF	416.15	416.15	415.58	415.7	223482.0
2023-05-01 05:00:00	SPY	ETF	415.81	416.14	415.79	416.0	75273.0
2023-05-01 06:00:00	SPY	ETF	415.99	416.04	415.62	415.9	56750.0
2023-05-01 07:00:00	SPY	ETF	415.9	415.949	415.4	415.42	161099.0
2023-05-01 08:00:00	SPY	ETF	415.91	416.34	415.27	415.73	286420.0
2023-05-01 09:00:00	SPY	ETF	415.69	416.7299	415.2	416.3899	5646296.0
2023-05-01 10:00:00	SPY	ETF	416.36	417.07	415.77	416.9599	7369541.0
2023-05-01 11:00:00	SPY	ETF	416.96	417.14	415.57	416.3499	6332308.0
2023-05-01 12:00:00	SPY	ETF	416.33	417.62	416.295	417.16	4832487.0
2023-05-01 13:00:00	SPY	ETF	417.19	417.33	416.625	417.03	3659740.0
2023-05-01 14:00:00	SPY	ETF	417.03	417.13	415.42	416.08	6708079.0
2023-05-01 15:00:00	SPY	ETF	416.08	416.22	415.265	415.53	12081456.0
2023-05-01 16:00:00	SPY	ETF	415.53	416.2898	414.93	415.05	3054201.0
2023-05-01 17:00:00	SPY	ETF	414.97	415.15	414.96	415.01	151509.0
2023-05-01 18:00:00	SPY	ETF	415.0	415.1	414.78	415.04	40309.0
2023-05-01 19:00:00	SPY	ETF	415.0	415.13	414.96	415.0	30808.0
2023-05-01 04:00:00	QQQ	ETF	322.8	322.93	322.05	322.38	28508.0
2023-05-01 05:00:00	QQQ	ETF	322.43	322.86	322.43	322.5	7863.0
2023-05-01 06:00:00	QQQ	ETF	322.5	322.58	322.17	322.34	75547.0
2023-05-01 07:00:00	QQQ	ETF	322.36	322.5	322.1	322.22	125796.0
2023-05-01 08:00:00	QQQ	ETF	322.33	323.02	321.74	322.18	260571.0
2023-05-01 09:00:00	QQQ	ETF	322.18	322.77	321.75	322.35	3730733.0
2023-05-01 10:00:00	QQQ	ETF	322.34	322.72	321.5497	322.655	6080681.0
2023-05-01 11:00:00	QQQ	ETF	322.66	322.88	321.09	322.0	4728011.0
2023-05-01 12:00:00	QQQ	ETF	322.01	323.31	321.95	323.21	3334610.0
2023-05-01 13:00:00	QQQ	ETF	323.21	323.63	322.99	323.29	3189727.0
2023-05-01 14:00:00	QQQ	ETF	323.28	323.37	321.76	322.46	3994593.0
2023-05-01 15:00:00	QQQ	ETF	322.48	322.6	321.74	322.17	5800039.0
2023-05-01 16:00:00	QQQ	ETF	322.17	322.53	321.74	321.8	1635555.0
2023-05-01 17:00:00	QQQ	ETF	321.8	321.96	321.78	321.82	47333.0
2023-05-01 18:00:00	QQQ	ETF	321.8	321.94	321.6	321.85	59056.0
2023-05-01 19:00:00	QQQ	ETF	321.83	321.96	321.72	321.78	61953.0
2023-05-01 04:00:00	IWM	ETF	175.16	175.16	174.96	174.96	6748.0
2023-05-01 05:00:00	IWM	ETF	174.91	175.19	174.9	175.19	79082.0
2023-05-01 06:00:00	IWM	ETF	175.21	175.25	175.07	175.14	59750.0
2023-05-01 07:00:00	IWM	ETF	175.14	175.21	174.7	174.74	144270.0
2023-05-01 08:00:00	IWM	ETF	175.0095	175.23	174.68	175.16	80685.0
2023-05-01 09:00:00	IWM	ETF	175.14	176.6	174.75	176.31	2624439.0
2023-05-01 10:00:00	IWM	ETF	176.31	177.34	175.7601	176.7401	3547298.0
2023-05-01 11:00:00	IWM	ETF	176.75	176.83	175.24	175.71	2203216.0
2023-05-01 12:00:00	IWM	ETF	175.71	176.42	175.685	176.03	1365775.0
2023-05-01 13:00:00	IWM	ETF	176.03	176.14	175.22	175.57	1721837.0
2023-05-01 14:00:00	IWM	ETF	175.56	175.69	174.78	175.245	1732600.0
2023-05-01 15:00:00	IWM	ETF	175.24	175.61	174.76	175.34	3731153.0
2023-05-01 16:00:00	IWM	ETF	175.3	175.5	174.92	174.93	1544054.0
2023-05-01 17:00:00	IWM	ETF	174.92	175.09	174.8	174.95	33153.0
2023-05-01 18:00:00	IWM	ETF	174.9	174.95	174.85	174.85	15943.0
2023-05-01 19:00:00	IWM	ETF	174.95	174.95	174.83	174.92	37883.0
2023-05-01 07:00:00	DIA	ETF	341.11	341.11	340.83	340.83	2445.0
2023-05-01 08:00:00	DIA	ETF	341.0496	341.11	340.83	341.09	9128.0

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

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