PREVIEW / etf_1hour / 2021-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-14.parquet
  size:    415 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-14 04:00:00	SPY	ETF	412.13	412.99	412.0	412.83	28459.0
2021-05-14 05:00:00	SPY	ETF	412.92	413.42	412.8	412.8	25320.0
2021-05-14 06:00:00	SPY	ETF	412.97	413.02	412.67	412.79	79822.0
2021-05-14 07:00:00	SPY	ETF	412.76	413.4	412.63	413.14	357956.0
2021-05-14 08:00:00	SPY	ETF	412.86	413.37	412.02	413.0	671701.0
2021-05-14 09:00:00	SPY	ETF	413.009	414.92	412.73	414.92	7302333.0
2021-05-14 10:00:00	SPY	ETF	414.9	415.37	414.0714	415.28	10950862.0
2021-05-14 11:00:00	SPY	ETF	415.28	415.75	414.84	415.39	4997022.0
2021-05-14 12:00:00	SPY	ETF	415.39	416.27	415.32	416.24	3567937.0
2021-05-14 13:00:00	SPY	ETF	416.2389	416.5206	416.07	416.43	3786281.0
2021-05-14 14:00:00	SPY	ETF	416.43	417.49	416.31	417.2199	6040234.0
2021-05-14 15:00:00	SPY	ETF	417.215	417.38	416.3	416.55	20086506.0
2021-05-14 16:00:00	SPY	ETF	416.55	417.29	415.9835	417.02	4601860.0
2021-05-14 17:00:00	SPY	ETF	416.99	417.12	416.58	416.96	135137.0
2021-05-14 18:00:00	SPY	ETF	416.96	417.22	416.93	417.14	35067.0
2021-05-14 19:00:00	SPY	ETF	417.13	417.45	417.11	417.44	36922.0
2021-05-14 04:00:00	QQQ	ETF	321.29	322.34	321.28	322.2	57737.0
2021-05-14 05:00:00	QQQ	ETF	322.14	323.29	322.14	322.75	83418.0
2021-05-14 06:00:00	QQQ	ETF	322.8	322.98	322.49	322.49	63249.0
2021-05-14 07:00:00	QQQ	ETF	322.45	323.02	322.33	322.66	281062.0
2021-05-14 08:00:00	QQQ	ETF	322.66	323.17	321.4	322.81	522078.0
2021-05-14 09:00:00	QQQ	ETF	322.77	323.495	322.08	323.48	5485462.0
2021-05-14 10:00:00	QQQ	ETF	323.47	324.95	322.641	324.93	6622312.0
2021-05-14 11:00:00	QQQ	ETF	324.95	325.4	324.51	325.0318	4128595.0
2021-05-14 12:00:00	QQQ	ETF	325.03	325.85	324.91	325.76	2463057.0
2021-05-14 13:00:00	QQQ	ETF	325.76	326.03	325.44	325.95	2423965.0
2021-05-14 14:00:00	QQQ	ETF	325.95	327.33	325.79	327.11	5228963.0
2021-05-14 15:00:00	QQQ	ETF	327.11	327.25	326.13	326.35	8974234.0
2021-05-14 16:00:00	QQQ	ETF	326.33	326.75	326.16	326.73	1410162.0
2021-05-14 17:00:00	QQQ	ETF	326.84	326.84	326.39	326.75	90984.0
2021-05-14 18:00:00	QQQ	ETF	326.75	326.95	326.71	326.8	14200.0
2021-05-14 19:00:00	QQQ	ETF	326.95	327.95	326.85	327.65	36432.0
2021-05-14 04:00:00	IWM	ETF	216.88	217.14	216.5	217.09	19172.0
2021-05-14 05:00:00	IWM	ETF	217.23	217.45	217.2	217.45	9864.0
2021-05-14 06:00:00	IWM	ETF	217.36	217.37	216.97	217.13	20921.0
2021-05-14 07:00:00	IWM	ETF	217.09	217.63	217.08	217.6	61333.0
2021-05-14 08:00:00	IWM	ETF	217.2099	217.8	216.6	217.34	224098.0
2021-05-14 09:00:00	IWM	ETF	217.26	218.93	216.88	218.81	3652929.0
2021-05-14 10:00:00	IWM	ETF	218.79	220.03	218.59	219.79	3502619.0
2021-05-14 11:00:00	IWM	ETF	219.78	219.81	218.7	219.54	1997107.0
2021-05-14 12:00:00	IWM	ETF	219.53	220.01	219.49	219.91	1554148.0
2021-05-14 13:00:00	IWM	ETF	219.91	220.2	219.55	220.1	1365357.0
2021-05-14 14:00:00	IWM	ETF	220.1	221.39	219.92	221.38	2046809.0
2021-05-14 15:00:00	IWM	ETF	221.39	221.41	220.4	221.02	4115762.0
2021-05-14 16:00:00	IWM	ETF	221.02	221.52	219.9079	221.19	1508366.0
2021-05-14 17:00:00	IWM	ETF	221.08	221.46	221.02	221.17	46560.0
2021-05-14 18:00:00	IWM	ETF	220.88	221.59	220.88	221.5	228605.0
2021-05-14 19:00:00	IWM	ETF	221.5	221.59	221.32	221.55	3521.0
2021-05-14 04:00:00	DIA	ETF	341.74	342.12	341.74	342.12	6800.0
2021-05-14 05:00:00	DIA	ETF	342.34	342.35	342.03	342.12	10433.0

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

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