PREVIEW / etf_1hour / 2022-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-08.parquet
  size:    450 KB
  rows:    16,057

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
2022-08-08 04:00:00	SPY	ETF	414.72	415.16	414.07	414.48	31750.0
2022-08-08 05:00:00	SPY	ETF	414.53	414.8	414.28	414.48	14704.0
2022-08-08 06:00:00	SPY	ETF	414.5	415.79	414.46	415.73	46692.0
2022-08-08 07:00:00	SPY	ETF	415.76	416.0	415.12	415.86	209013.0
2022-08-08 08:00:00	SPY	ETF	415.86	416.56	413.2	416.55	297733.0
2022-08-08 09:00:00	SPY	ETF	416.56	417.62	414.89	417.19	6539396.0
2022-08-08 10:00:00	SPY	ETF	417.19	417.62	416.23	416.5	5976440.0
2022-08-08 11:00:00	SPY	ETF	416.51	417.11	413.545	414.88	6370704.0
2022-08-08 12:00:00	SPY	ETF	414.84	415.01	412.35	413.33	5227643.0
2022-08-08 13:00:00	SPY	ETF	413.3294	414.21	412.9	413.9008	3358077.0
2022-08-08 14:00:00	SPY	ETF	413.919	413.9386	411.83	412.5	4501581.0
2022-08-08 15:00:00	SPY	ETF	412.495	413.39	412.06	413.02	6220479.0
2022-08-08 16:00:00	SPY	ETF	413.03	413.97	412.91	413.9	2004477.0
2022-08-08 17:00:00	SPY	ETF	413.9	414.05	413.64	413.64	121506.0
2022-08-08 18:00:00	SPY	ETF	413.7	413.78	413.42	413.47	77510.0
2022-08-08 19:00:00	SPY	ETF	413.5	414.32	413.35	414.13	97000.0
2022-08-08 04:00:00	QQQ	ETF	322.52	323.61	322.52	323.24	75869.0
2022-08-08 05:00:00	QQQ	ETF	323.3	323.5	322.76	323.01	24957.0
2022-08-08 06:00:00	QQQ	ETF	323.02	324.18	323.0	324.14	79143.0
2022-08-08 07:00:00	QQQ	ETF	324.12	324.31	323.46	324.14	191005.0
2022-08-08 08:00:00	QQQ	ETF	324.16	324.79	321.991	324.74	392862.0
2022-08-08 09:00:00	QQQ	ETF	324.74	326.29	321.91	325.81	7547889.0
2022-08-08 10:00:00	QQQ	ETF	325.82	326.47	323.89	324.2	5766258.0
2022-08-08 11:00:00	QQQ	ETF	324.235	324.95	321.075	322.42	5439111.0
2022-08-08 12:00:00	QQQ	ETF	322.41	322.6282	320.14	321.0601	4721120.0
2022-08-08 13:00:00	QQQ	ETF	321.06	321.935	320.47	321.44	2785439.0
2022-08-08 14:00:00	QQQ	ETF	321.43	321.44	319.21	319.88	3855768.0
2022-08-08 15:00:00	QQQ	ETF	319.88	320.86	319.51	320.7	4437318.0
2022-08-08 16:00:00	QQQ	ETF	320.7	321.5333	320.62	321.45	843425.0
2022-08-08 17:00:00	QQQ	ETF	321.44	321.52	321.12	321.3	104036.0
2022-08-08 18:00:00	QQQ	ETF	321.25	321.33	321.06	321.08	74354.0
2022-08-08 19:00:00	QQQ	ETF	321.07	321.92	320.92	321.63	145621.0
2022-08-08 04:00:00	IWM	ETF	191.56	191.57	191.08	191.2	20283.0
2022-08-08 05:00:00	IWM	ETF	191.25	191.46	191.16	191.3	11186.0
2022-08-08 06:00:00	IWM	ETF	191.28	191.77	191.28	191.77	66065.0
2022-08-08 07:00:00	IWM	ETF	191.79	192.07	191.62	191.93	88426.0
2022-08-08 08:00:00	IWM	ETF	191.3104	192.51	191.3104	192.51	68629.0
2022-08-08 09:00:00	IWM	ETF	192.47	194.12	191.85	194.02	2756221.0
2022-08-08 10:00:00	IWM	ETF	194.05	194.59	193.75	194.45	2321242.0
2022-08-08 11:00:00	IWM	ETF	194.47	194.625	192.51	193.24	2135663.0
2022-08-08 12:00:00	IWM	ETF	193.22	193.378	191.89	192.4795	1580701.0
2022-08-08 13:00:00	IWM	ETF	192.46	192.8	192.11	192.76	1008853.0
2022-08-08 14:00:00	IWM	ETF	192.77	192.79	191.99	192.2904	1339333.0
2022-08-08 15:00:00	IWM	ETF	192.3	193.225	192.23	192.83	3423933.0
2022-08-08 16:00:00	IWM	ETF	192.83	193.15	192.75	193.15	629778.0
2022-08-08 17:00:00	IWM	ETF	193.25	193.25	192.88	192.92	22703.0
2022-08-08 18:00:00	IWM	ETF	193.04	193.09	192.87	192.95	32051.0
2022-08-08 19:00:00	IWM	ETF	192.88	193.45	192.88	193.26	24350.0
2022-08-08 04:00:00	DIA	ETF	329.03	329.03	328.7	328.8	527.0
2022-08-08 05:00:00	DIA	ETF	328.8	328.8	328.53	328.53	3835.0

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

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