PREVIEW / etf_1hour / 2021-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-06.parquet
  size:    405 KB
  rows:    14,162

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-08-06 04:00:00	SPY	ETF	441.41	441.93	441.4	441.88	8325.0
2021-08-06 05:00:00	SPY	ETF	441.85	441.9	441.81	441.89	5682.0
2021-08-06 06:00:00	SPY	ETF	441.87	442.07	441.83	441.93	37561.0
2021-08-06 07:00:00	SPY	ETF	441.94	442.11	441.93	441.95	60183.0
2021-08-06 08:00:00	SPY	ETF	441.9501	442.6	441.36	441.85	860505.0
2021-08-06 09:00:00	SPY	ETF	441.86	442.94	441.81	442.04	4948687.0
2021-08-06 10:00:00	SPY	ETF	442.05	442.64	441.8	442.11	6145916.0
2021-08-06 11:00:00	SPY	ETF	442.1	442.57	441.8511	442.55	4593227.0
2021-08-06 12:00:00	SPY	ETF	442.55	442.79	442.3201	442.76	1965191.0
2021-08-06 13:00:00	SPY	ETF	442.76	442.83	442.5	442.65	2337119.0
2021-08-06 14:00:00	SPY	ETF	442.65	442.73	442.06	442.0611	2977724.0
2021-08-06 15:00:00	SPY	ETF	442.06	442.67	441.945	442.53	8967039.0
2021-08-06 16:00:00	SPY	ETF	442.52	442.67	442.3375	442.63	2696127.0
2021-08-06 17:00:00	SPY	ETF	442.52	442.69	442.52	442.62	64248.0
2021-08-06 18:00:00	SPY	ETF	442.62	442.68	442.31	442.39	54949.0
2021-08-06 19:00:00	SPY	ETF	442.49	442.54	442.2	442.37	205017.0
2021-08-06 04:00:00	QQQ	ETF	369.45	369.45	369.18	369.45	23914.0
2021-08-06 05:00:00	QQQ	ETF	369.53	369.54	369.4	369.46	12876.0
2021-08-06 06:00:00	QQQ	ETF	369.46	369.48	369.26	369.33	36239.0
2021-08-06 07:00:00	QQQ	ETF	369.32	369.48	369.32	369.36	50385.0
2021-08-06 08:00:00	QQQ	ETF	369.34	369.947	367.74	368.36	841005.0
2021-08-06 09:00:00	QQQ	ETF	368.36	369.37	368.01	368.4423	4601885.0
2021-08-06 10:00:00	QQQ	ETF	368.45	368.92	367.39	367.61	4284783.0
2021-08-06 11:00:00	QQQ	ETF	367.62	368.235	366.905	368.23	3111199.0
2021-08-06 12:00:00	QQQ	ETF	368.23	368.31	367.61	368.11	1694973.0
2021-08-06 13:00:00	QQQ	ETF	368.12	368.39	367.91	368.06	1409185.0
2021-08-06 14:00:00	QQQ	ETF	368.08	368.29	367.57	367.655	1451878.0
2021-08-06 15:00:00	QQQ	ETF	367.63	368.175	367.505	368.06	3471433.0
2021-08-06 16:00:00	QQQ	ETF	368.06	368.06	367.82	367.99	633523.0
2021-08-06 17:00:00	QQQ	ETF	368.0	368.05	367.91	368.04	28834.0
2021-08-06 18:00:00	QQQ	ETF	367.92	367.97	367.76	367.9	5055.0
2021-08-06 19:00:00	QQQ	ETF	367.81	367.9	367.7	367.88	9969.0
2021-08-06 04:00:00	IWM	ETF	222.0	222.31	221.85	222.26	4832.0
2021-08-06 05:00:00	IWM	ETF	222.22	222.33	222.22	222.24	8578.0
2021-08-06 06:00:00	IWM	ETF	222.25	222.63	222.25	222.63	12184.0
2021-08-06 07:00:00	IWM	ETF	222.59	222.64	222.38	222.4	24077.0
2021-08-06 08:00:00	IWM	ETF	222.5899	223.84	222.15	223.4	602539.0
2021-08-06 09:00:00	IWM	ETF	223.6	225.21	222.3	222.99	4716083.0
2021-08-06 10:00:00	IWM	ETF	222.97	223.46	222.14	222.8	3327791.0
2021-08-06 11:00:00	IWM	ETF	222.79	223.79	222.55	223.51	2628928.0
2021-08-06 12:00:00	IWM	ETF	223.51	223.855	223.19	223.39	1524487.0
2021-08-06 13:00:00	IWM	ETF	223.39	223.58	222.97	223.22	1659663.0
2021-08-06 14:00:00	IWM	ETF	223.21	223.79	223.0	223.36	1579444.0
2021-08-06 15:00:00	IWM	ETF	223.36	223.535	223.1001	223.44	3133626.0
2021-08-06 16:00:00	IWM	ETF	223.45	223.45	223.15	223.31	1489481.0
2021-08-06 17:00:00	IWM	ETF	223.35	223.39	223.23	223.35	34793.0
2021-08-06 18:00:00	IWM	ETF	223.33	223.35	223.27	223.3	8681.0
2021-08-06 19:00:00	IWM	ETF	223.21	223.21	223.13	223.13	1270.0
2021-08-06 04:00:00	DIA	ETF	350.49	350.49	350.49	350.49	300.0
2021-08-06 05:00:00	DIA	ETF	350.8	350.8	350.65	350.65	1050.0

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

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