PREVIEW / etf_1hour / 2021-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-17.parquet
  size:    408 KB
  rows:    14,505

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-17 04:00:00	SPY	ETF	415.34	416.12	415.3	416.07	23354.0
2021-05-17 05:00:00	SPY	ETF	415.88	416.05	415.55	415.67	18228.0
2021-05-17 06:00:00	SPY	ETF	415.53	415.55	415.0	415.09	150445.0
2021-05-17 07:00:00	SPY	ETF	415.05	415.45	414.55	414.68	438754.0
2021-05-17 08:00:00	SPY	ETF	415.1099	416.5	414.45	414.95	488821.0
2021-05-17 09:00:00	SPY	ETF	414.9	416.39	414.48	414.94	7513505.0
2021-05-17 10:00:00	SPY	ETF	414.92	415.585	413.94	414.89	9340750.0
2021-05-17 11:00:00	SPY	ETF	414.86	415.08	413.81	414.16	7019391.0
2021-05-17 12:00:00	SPY	ETF	414.14	415.12	413.84	414.47	4503038.0
2021-05-17 13:00:00	SPY	ETF	414.46	414.72	413.36	414.025	4867606.0
2021-05-17 14:00:00	SPY	ETF	414.03	415.22	413.87	415.17	4790554.0
2021-05-17 15:00:00	SPY	ETF	415.17	415.7	414.765	415.54	11805170.0
2021-05-17 16:00:00	SPY	ETF	415.55	415.94	414.025	415.75	2426702.0
2021-05-17 17:00:00	SPY	ETF	415.77	415.84	415.64	415.64	32385.0
2021-05-17 18:00:00	SPY	ETF	415.64	415.87	415.35	415.35	198235.0
2021-05-17 19:00:00	SPY	ETF	415.37	416.23	415.37	416.23	97499.0
2021-05-17 04:00:00	QQQ	ETF	325.37	325.91	325.27	325.8	55392.0
2021-05-17 05:00:00	QQQ	ETF	325.6	325.93	325.31	325.31	52973.0
2021-05-17 06:00:00	QQQ	ETF	325.34	325.41	324.95	325.2	226573.0
2021-05-17 07:00:00	QQQ	ETF	325.12	325.44	324.51	324.55	283467.0
2021-05-17 08:00:00	QQQ	ETF	324.52	326.5	324.32	324.52	234492.0
2021-05-17 09:00:00	QQQ	ETF	324.5	325.35	323.41	323.96	5262905.0
2021-05-17 10:00:00	QQQ	ETF	323.96	324.99	322.79	324.13	6265312.0
2021-05-17 11:00:00	QQQ	ETF	324.09	324.385	322.56	322.8	3364802.0
2021-05-17 12:00:00	QQQ	ETF	322.8	323.5198	322.33	322.7401	2405770.0
2021-05-17 13:00:00	QQQ	ETF	322.73	322.99	321.45	322.0782	3136228.0
2021-05-17 14:00:00	QQQ	ETF	322.05	323.34	321.88	323.29	3147803.0
2021-05-17 15:00:00	QQQ	ETF	323.31	324.47	323.01	324.44	5989783.0
2021-05-17 16:00:00	QQQ	ETF	324.44	324.7	324.16	324.41	850191.0
2021-05-17 17:00:00	QQQ	ETF	324.59	324.75	324.5	324.65	37273.0
2021-05-17 18:00:00	QQQ	ETF	324.64	324.75	324.12	324.12	74303.0
2021-05-17 19:00:00	QQQ	ETF	324.16	325.05	324.09	325.03	92757.0
2021-05-17 04:00:00	IWM	ETF	220.09	220.38	220.09	220.38	19141.0
2021-05-17 05:00:00	IWM	ETF	220.28	220.4	220.0	220.0	14321.0
2021-05-17 06:00:00	IWM	ETF	219.74	219.81	219.12	219.15	23455.0
2021-05-17 07:00:00	IWM	ETF	219.24	219.62	218.86	218.99	88006.0
2021-05-17 08:00:00	IWM	ETF	219.3099	220.8	218.8	219.65	90493.0
2021-05-17 09:00:00	IWM	ETF	219.56	220.65	218.28	218.49	2790177.0
2021-05-17 10:00:00	IWM	ETF	218.43	220.56	217.9	219.89	3703253.0
2021-05-17 11:00:00	IWM	ETF	219.87	220.21	218.86	219.21	1928846.0
2021-05-17 12:00:00	IWM	ETF	219.15	220.24	218.86	220.04	1320737.0
2021-05-17 13:00:00	IWM	ETF	220.04	220.285	219.2001	219.94	1176843.0
2021-05-17 14:00:00	IWM	ETF	219.93	220.59	219.73	220.485	1104706.0
2021-05-17 15:00:00	IWM	ETF	220.5	221.39	220.38	221.33	2814175.0
2021-05-17 16:00:00	IWM	ETF	221.32	221.66	221.13	221.32	1163005.0
2021-05-17 17:00:00	IWM	ETF	221.41	221.6	221.41	221.59	1998.0
2021-05-17 18:00:00	IWM	ETF	221.55	221.64	221.27	221.27	25773.0
2021-05-17 19:00:00	IWM	ETF	221.41	221.85	221.41	221.85	22714.0
2021-05-17 04:00:00	DIA	ETF	343.11	343.65	343.11	343.65	1289.0
2021-05-17 05:00:00	DIA	ETF	343.63	343.63	343.43	343.43	300.0

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

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