PREVIEW / etf_1hour / 2021-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-21.parquet
  size:    415 KB
  rows:    14,538

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-07-21 04:00:00	SPY	ETF	432.86	433.28	432.52	433.05	20402.0
2021-07-21 05:00:00	SPY	ETF	433.11	433.2	432.8	432.97	21315.0
2021-07-21 06:00:00	SPY	ETF	432.9	432.96	432.5	432.62	60027.0
2021-07-21 07:00:00	SPY	ETF	432.59	432.59	431.11	431.33	234986.0
2021-07-21 08:00:00	SPY	ETF	432.5399	432.9196	431.23	431.99	421618.0
2021-07-21 09:00:00	SPY	ETF	432.0	433.69	431.83	433.66	6525659.0
2021-07-21 10:00:00	SPY	ETF	433.66	433.72	432.855	433.44	5886037.0
2021-07-21 11:00:00	SPY	ETF	433.45	434.02	433.11	434.001	4638788.0
2021-07-21 12:00:00	SPY	ETF	434.02	434.02	433.4117	433.455	4907937.0
2021-07-21 13:00:00	SPY	ETF	433.4599	434.04	433.44	433.9117	3323942.0
2021-07-21 14:00:00	SPY	ETF	433.915	434.17	433.62	434.165	3409600.0
2021-07-21 15:00:00	SPY	ETF	434.1699	434.7	433.54	434.56	14469087.0
2021-07-21 16:00:00	SPY	ETF	434.58	435.0	434.48	434.98	2787406.0
2021-07-21 17:00:00	SPY	ETF	434.9	435.05	434.89	434.91	189708.0
2021-07-21 18:00:00	SPY	ETF	434.88	434.9	434.72	434.83	119645.0
2021-07-21 19:00:00	SPY	ETF	434.85	435.16	434.77	434.96	60173.0
2021-07-21 04:00:00	QQQ	ETF	359.03	359.87	358.96	359.28	34792.0
2021-07-21 05:00:00	QQQ	ETF	359.23	359.48	359.02	359.18	41141.0
2021-07-21 06:00:00	QQQ	ETF	359.15	359.21	358.75	358.93	47493.0
2021-07-21 07:00:00	QQQ	ETF	358.83	358.86	357.56	357.83	188722.0
2021-07-21 08:00:00	QQQ	ETF	357.8	359.17	357.6	358.39	302875.0
2021-07-21 09:00:00	QQQ	ETF	358.36	359.72	358.12	359.67	4887146.0
2021-07-21 10:00:00	QQQ	ETF	359.67	359.95	358.95	359.8637	3662961.0
2021-07-21 11:00:00	QQQ	ETF	359.87	360.3901	359.64	360.27	2982895.0
2021-07-21 12:00:00	QQQ	ETF	360.2401	360.28	359.3	359.3899	1590518.0
2021-07-21 13:00:00	QQQ	ETF	359.385	360.48	359.18	360.2382	1901611.0
2021-07-21 14:00:00	QQQ	ETF	360.24	360.465	359.93	360.45	1488259.0
2021-07-21 15:00:00	QQQ	ETF	360.45	361.54	360.1	361.46	4517733.0
2021-07-21 16:00:00	QQQ	ETF	361.45	361.7	361.27	361.66	1639461.0
2021-07-21 17:00:00	QQQ	ETF	361.78	361.78	361.51	361.51	29337.0
2021-07-21 18:00:00	QQQ	ETF	361.58	361.63	361.42	361.58	59573.0
2021-07-21 19:00:00	QQQ	ETF	361.65	361.85	361.515	361.65	44739.0
2021-07-21 04:00:00	IWM	ETF	220.0	220.43	219.76	220.35	48571.0
2021-07-21 05:00:00	IWM	ETF	220.0	220.36	219.9	220.2	27380.0
2021-07-21 06:00:00	IWM	ETF	220.13	220.53	219.78	220.45	69100.0
2021-07-21 07:00:00	IWM	ETF	220.41	220.43	219.19	219.27	87235.0
2021-07-21 08:00:00	IWM	ETF	220.27	220.34	218.19	219.8	150765.0
2021-07-21 09:00:00	IWM	ETF	219.81	221.91	219.36	221.885	3949773.0
2021-07-21 10:00:00	IWM	ETF	221.89	222.04	220.3301	220.52	4435545.0
2021-07-21 11:00:00	IWM	ETF	220.53	221.91	220.52	221.73	2685687.0
2021-07-21 12:00:00	IWM	ETF	221.74	222.145	221.56	221.66	2092419.0
2021-07-21 13:00:00	IWM	ETF	221.67	222.22	221.67	221.86	1661120.0
2021-07-21 14:00:00	IWM	ETF	221.86	222.2	221.22	221.85	2512092.0
2021-07-21 15:00:00	IWM	ETF	221.85	222.13	221.42	222.11	4031545.0
2021-07-21 16:00:00	IWM	ETF	222.06	222.41	221.4442	222.41	1588819.0
2021-07-21 17:00:00	IWM	ETF	222.26	222.46	222.06	222.17	116587.0
2021-07-21 18:00:00	IWM	ETF	222.28	222.35	222.1	222.35	330185.0
2021-07-21 19:00:00	IWM	ETF	222.37	222.38	222.18	222.22	53151.0
2021-07-21 04:00:00	DIA	ETF	347.0	347.32	346.7	347.26	1215.0
2021-07-21 05:00:00	DIA	ETF	347.02	347.1	347.0	347.1	1100.0

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

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