PREVIEW / etf_1hour / 2021-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-12.parquet
  size:    432 KB
  rows:    15,342

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
2021-05-12 04:00:00	SPY	ETF	414.0	414.25	412.8	412.94	12686.0
2021-05-12 05:00:00	SPY	ETF	413.09	413.49	412.54	412.87	6449.0
2021-05-12 06:00:00	SPY	ETF	412.95	413.6	412.35	412.53	71503.0
2021-05-12 07:00:00	SPY	ETF	412.53	413.06	412.25	413.06	153175.0
2021-05-12 08:00:00	SPY	ETF	412.4899	414.22	409.29	411.61	1653128.0
2021-05-12 09:00:00	SPY	ETF	411.67	412.59	410.91	411.13	9818733.0
2021-05-12 10:00:00	SPY	ETF	411.12	411.52	408.74	409.43	15420403.0
2021-05-12 11:00:00	SPY	ETF	409.43	410.14	407.565	407.79	10317153.0
2021-05-12 12:00:00	SPY	ETF	407.8	408.18	406.72	407.77	10897989.0
2021-05-12 13:00:00	SPY	ETF	407.75	408.61	406.86	407.28	9887336.0
2021-05-12 14:00:00	SPY	ETF	407.27	408.25	406.32	407.47	10203368.0
2021-05-12 15:00:00	SPY	ETF	407.44	407.6	404.0	405.44	32659174.0
2021-05-12 16:00:00	SPY	ETF	405.44	406.2135	404.81	404.92	5450668.0
2021-05-12 17:00:00	SPY	ETF	404.99	405.41	404.76	405.05	432438.0
2021-05-12 18:00:00	SPY	ETF	405.15	406.1	405.15	405.92	211014.0
2021-05-12 19:00:00	SPY	ETF	405.95	406.25	405.8	406.14	71086.0
2021-05-12 04:00:00	QQQ	ETF	324.79	324.99	323.51	323.7	25855.0
2021-05-12 05:00:00	QQQ	ETF	323.76	324.29	323.15	323.71	57068.0
2021-05-12 06:00:00	QQQ	ETF	323.52	324.29	323.1	323.12	156385.0
2021-05-12 07:00:00	QQQ	ETF	323.3	323.83	323.129	323.61	225904.0
2021-05-12 08:00:00	QQQ	ETF	323.22	324.38	319.11	320.84	2846241.0
2021-05-12 09:00:00	QQQ	ETF	320.85	322.62	319.97	320.82	9840890.0
2021-05-12 10:00:00	QQQ	ETF	320.81	320.96	317.88	318.4728	11836951.0
2021-05-12 11:00:00	QQQ	ETF	318.46	319.65	317.19	317.32	7071899.0
2021-05-12 12:00:00	QQQ	ETF	317.33	318.27	316.5	318.17	8467703.0
2021-05-12 13:00:00	QQQ	ETF	318.17	319.19	317.18	317.515	5998818.0
2021-05-12 14:00:00	QQQ	ETF	317.49	318.75	316.68	317.85	7544017.0
2021-05-12 15:00:00	QQQ	ETF	317.83	318.02	316.0	316.9	15003295.0
2021-05-12 16:00:00	QQQ	ETF	316.91	318.6402	316.07	316.08	3823906.0
2021-05-12 17:00:00	QQQ	ETF	316.07	316.89	316.07	316.43	722999.0
2021-05-12 18:00:00	QQQ	ETF	316.31	317.35	316.31	317.18	218299.0
2021-05-12 19:00:00	QQQ	ETF	317.19	317.5	317.05	317.34	87922.0
2021-05-12 04:00:00	IWM	ETF	218.45	218.45	217.2	217.28	15000.0
2021-05-12 05:00:00	IWM	ETF	217.17	217.55	216.52	216.73	46400.0
2021-05-12 06:00:00	IWM	ETF	216.72	217.25	216.45	216.52	7450.0
2021-05-12 07:00:00	IWM	ETF	216.55	217.13	216.37	217.13	79281.0
2021-05-12 08:00:00	IWM	ETF	216.85	218.16	214.45	216.49	454457.0
2021-05-12 09:00:00	IWM	ETF	216.59	218.77	216.21	216.82	3641060.0
2021-05-12 10:00:00	IWM	ETF	216.81	217.94	215.94	216.51	4169333.0
2021-05-12 11:00:00	IWM	ETF	216.48	217.77	215.19	215.275	2969759.0
2021-05-12 12:00:00	IWM	ETF	215.26	215.75	214.46	215.6	3219711.0
2021-05-12 13:00:00	IWM	ETF	215.58	216.53	215.38	215.61	3053759.0
2021-05-12 14:00:00	IWM	ETF	215.59	215.88	213.98	214.03	3663501.0
2021-05-12 15:00:00	IWM	ETF	214.0	214.13	211.54	211.86	8893351.0
2021-05-12 16:00:00	IWM	ETF	211.85	212.35	211.25	211.39	1362359.0
2021-05-12 17:00:00	IWM	ETF	211.49	211.93	211.4	211.75	520008.0
2021-05-12 18:00:00	IWM	ETF	211.78	212.47	211.78	212.37	61528.0
2021-05-12 19:00:00	IWM	ETF	212.39	212.66	212.35	212.45	64593.0
2021-05-12 04:00:00	DIA	ETF	342.54	342.54	341.82	341.82	22550.0
2021-05-12 05:00:00	DIA	ETF	341.93	342.06	341.65	341.83	1500.0

> showing 50 of 15,342 rows — these rows as CSV

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