PREVIEW / etf_1hour / 2021-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-24.parquet
  size:    407 KB
  rows:    14,446

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-24 04:00:00	SPY	ETF	415.9	416.99	415.9	416.51	38023.0
2021-05-24 05:00:00	SPY	ETF	416.45	417.04	416.39	416.96	24567.0
2021-05-24 06:00:00	SPY	ETF	417.06	417.06	416.81	416.97	93626.0
2021-05-24 07:00:00	SPY	ETF	416.88	416.97	416.57	416.83	88741.0
2021-05-24 08:00:00	SPY	ETF	416.74	417.27	416.26	417.21	292407.0
2021-05-24 09:00:00	SPY	ETF	417.22	418.21	417.08	418.21	5306616.0
2021-05-24 10:00:00	SPY	ETF	418.2	419.5	418.2	419.3	7056469.0
2021-05-24 11:00:00	SPY	ETF	419.3	419.68	419.09	419.23	3203402.0
2021-05-24 12:00:00	SPY	ETF	419.225	419.4485	418.91	419.2819	2762142.0
2021-05-24 13:00:00	SPY	ETF	419.29	419.84	419.14	419.7481	2533449.0
2021-05-24 14:00:00	SPY	ETF	419.75	420.32	419.74	420.0519	4273741.0
2021-05-24 15:00:00	SPY	ETF	420.055	420.28	418.94	419.13	12905829.0
2021-05-24 16:00:00	SPY	ETF	419.13	419.62	419.06	419.57	2674482.0
2021-05-24 17:00:00	SPY	ETF	419.58	419.59	419.43	419.58	44468.0
2021-05-24 18:00:00	SPY	ETF	419.58	419.95	419.17	419.9	62793.0
2021-05-24 19:00:00	SPY	ETF	419.92	420.0	419.68	419.81	59741.0
2021-05-24 04:00:00	QQQ	ETF	328.74	328.74	328.21	328.37	40929.0
2021-05-24 05:00:00	QQQ	ETF	328.29	329.1	328.29	329.0	31127.0
2021-05-24 06:00:00	QQQ	ETF	329.04	329.1	328.8	328.97	56617.0
2021-05-24 07:00:00	QQQ	ETF	328.96	329.11	328.62	329.05	107412.0
2021-05-24 08:00:00	QQQ	ETF	329.07	329.6	327.15	329.34	247773.0
2021-05-24 09:00:00	QQQ	ETF	329.45	331.17	329.0	331.08	3892189.0
2021-05-24 10:00:00	QQQ	ETF	331.08	332.77	331.08	332.48	4199647.0
2021-05-24 11:00:00	QQQ	ETF	332.48	333.01	332.33	332.81	2295825.0
2021-05-24 12:00:00	QQQ	ETF	332.81	333.12	332.3	332.52	2082809.0
2021-05-24 13:00:00	QQQ	ETF	332.5201	333.17	332.4299	332.97	1608898.0
2021-05-24 14:00:00	QQQ	ETF	332.97	333.67	332.94	333.5	2015606.0
2021-05-24 15:00:00	QQQ	ETF	333.5	333.62	332.36	332.53	6437407.0
2021-05-24 16:00:00	QQQ	ETF	332.525	332.95	332.39	332.81	1306927.0
2021-05-24 17:00:00	QQQ	ETF	332.92	332.94	332.51	332.74	41106.0
2021-05-24 18:00:00	QQQ	ETF	332.77	333.15	332.58	333.13	93834.0
2021-05-24 19:00:00	QQQ	ETF	333.16	333.26	332.86	333.0	95208.0
2021-05-24 04:00:00	IWM	ETF	221.26	221.26	220.97	221.08	10758.0
2021-05-24 05:00:00	IWM	ETF	221.07	221.22	220.95	220.95	1310.0
2021-05-24 06:00:00	IWM	ETF	221.13	221.17	221.03	221.03	4489.0
2021-05-24 07:00:00	IWM	ETF	221.01	221.05	220.61	220.77	40299.0
2021-05-24 08:00:00	IWM	ETF	220.66	221.22	220.63	221.06	64792.0
2021-05-24 09:00:00	IWM	ETF	221.12	221.87	220.0	221.69	2877778.0
2021-05-24 10:00:00	IWM	ETF	221.7	221.99	220.81	220.91	2483004.0
2021-05-24 11:00:00	IWM	ETF	220.9	221.565	220.89	221.02	1347185.0
2021-05-24 12:00:00	IWM	ETF	221.03	221.09	220.58	220.81	1235646.0
2021-05-24 13:00:00	IWM	ETF	220.82	221.785	220.8	221.72	1442897.0
2021-05-24 14:00:00	IWM	ETF	221.721	222.16	221.56	222.04	1051126.0
2021-05-24 15:00:00	IWM	ETF	222.04	222.45	221.175	221.42	3414926.0
2021-05-24 16:00:00	IWM	ETF	221.4	221.8	221.31	221.38	1488825.0
2021-05-24 17:00:00	IWM	ETF	221.41	221.41	221.1	221.33	101318.0
2021-05-24 18:00:00	IWM	ETF	221.33	221.6	221.26	221.55	39005.0
2021-05-24 19:00:00	IWM	ETF	221.5	221.62	221.41	221.55	19851.0
2021-05-24 04:00:00	DIA	ETF	343.45	343.45	343.45	343.45	500.0
2021-05-24 05:00:00	DIA	ETF	343.09	343.2	343.09	343.2	736.0

> showing 50 of 14,446 rows — these rows as CSV

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