PREVIEW / etf_1hour / 2023-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-26.parquet
  size:    472 KB
  rows:    17,000

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-26 04:00:00	SPY	ETF	413.84	414.5	413.8	414.48	12097.0
2023-05-26 05:00:00	SPY	ETF	414.4	414.4	413.84	414.12	61461.0
2023-05-26 06:00:00	SPY	ETF	414.1	415.51	413.89	415.34	112619.0
2023-05-26 07:00:00	SPY	ETF	415.44	415.84	415.33	415.71	135278.0
2023-05-26 08:00:00	SPY	ETF	415.4893	415.9	413.81	415.33	615255.0
2023-05-26 09:00:00	SPY	ETF	415.3	417.41	415.23	417.02	6912425.0
2023-05-26 10:00:00	SPY	ETF	417.0	419.81	416.88	419.36	12582416.0
2023-05-26 11:00:00	SPY	ETF	419.37	419.72	418.2799	419.05	7788075.0
2023-05-26 12:00:00	SPY	ETF	419.06	419.97	418.97	419.72	5756005.0
2023-05-26 13:00:00	SPY	ETF	419.725	420.03	419.15	419.565	4745296.0
2023-05-26 14:00:00	SPY	ETF	419.57	420.49	419.05	420.12	4987143.0
2023-05-26 15:00:00	SPY	ETF	420.13	420.77	419.78	419.98	16790828.0
2023-05-26 16:00:00	SPY	ETF	419.98	420.72	419.96	420.55	4993286.0
2023-05-26 17:00:00	SPY	ETF	420.56	420.58	420.02	420.29	67803.0
2023-05-26 18:00:00	SPY	ETF	420.29	420.37	420.02	420.35	92424.0
2023-05-26 19:00:00	SPY	ETF	420.4	421.0	420.38	420.49	30242.0
2023-05-26 04:00:00	QQQ	ETF	339.39	340.15	339.3	340.04	17460.0
2023-05-26 05:00:00	QQQ	ETF	340.09	340.09	339.68	339.82	12636.0
2023-05-26 06:00:00	QQQ	ETF	339.72	340.86	339.51	340.8	27110.0
2023-05-26 07:00:00	QQQ	ETF	340.8	341.38	340.7	341.04	130425.0
2023-05-26 08:00:00	QQQ	ETF	340.76	341.38	339.03	340.86	652084.0
2023-05-26 09:00:00	QQQ	ETF	340.83	343.31	340.66	343.12	5830035.0
2023-05-26 10:00:00	QQQ	ETF	343.14	346.84	343.09	346.49	9881042.0
2023-05-26 11:00:00	QQQ	ETF	346.49	347.61	345.625	347.245	7685205.0
2023-05-26 12:00:00	QQQ	ETF	347.25	348.23	347.09	348.05	4685232.0
2023-05-26 13:00:00	QQQ	ETF	348.072	348.45	347.65	348.02	3710331.0
2023-05-26 14:00:00	QQQ	ETF	348.03	348.8201	347.44	348.45	3290338.0
2023-05-26 15:00:00	QQQ	ETF	348.47	349.245	348.2	348.4	8704811.0
2023-05-26 16:00:00	QQQ	ETF	348.39	349.24	346.074	349.14	2159389.0
2023-05-26 17:00:00	QQQ	ETF	349.16	349.19	348.4	348.92	157437.0
2023-05-26 18:00:00	QQQ	ETF	348.92	349.2	348.4	349.15	125757.0
2023-05-26 19:00:00	QQQ	ETF	349.2	349.5	349.14	349.38	36608.0
2023-05-26 04:00:00	IWM	ETF	173.75	174.18	173.69	174.0	12938.0
2023-05-26 05:00:00	IWM	ETF	174.02	174.03	173.71	173.9	4483.0
2023-05-26 06:00:00	IWM	ETF	173.91	174.66	173.91	174.66	16185.0
2023-05-26 07:00:00	IWM	ETF	174.62	174.85	174.54	174.68	22173.0
2023-05-26 08:00:00	IWM	ETF	174.5408	174.79	173.95	174.41	165043.0
2023-05-26 09:00:00	IWM	ETF	174.42	175.225	174.02	174.54	2833892.0
2023-05-26 10:00:00	IWM	ETF	174.55	176.0	174.31	175.385	4782251.0
2023-05-26 11:00:00	IWM	ETF	175.38	175.6	174.855	174.925	2755272.0
2023-05-26 12:00:00	IWM	ETF	174.93	176.38	174.85	176.15	3225378.0
2023-05-26 13:00:00	IWM	ETF	176.16	176.27	175.49	175.7499	1593506.0
2023-05-26 14:00:00	IWM	ETF	175.75	176.19	175.46	176.02	1819762.0
2023-05-26 15:00:00	IWM	ETF	176.02	176.29	175.9	176.1	4697357.0
2023-05-26 16:00:00	IWM	ETF	176.15	176.3	176.0173	176.27	847926.0
2023-05-26 17:00:00	IWM	ETF	176.2	176.23	176.03	176.15	118794.0
2023-05-26 18:00:00	IWM	ETF	176.18	176.2	176.04	176.15	85363.0
2023-05-26 19:00:00	IWM	ETF	176.22	176.5	176.15	176.5	13409.0
2023-05-26 04:00:00	DIA	ETF	327.49	327.49	327.49	327.49	125.0
2023-05-26 05:00:00	DIA	ETF	327.17	327.17	327.15	327.17	1473.0

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

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