PREVIEW / etf_1hour / 2020-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-29.parquet
  size:    361 KB
  rows:    12,227

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
2020-09-29 04:00:00	SPY	ETF	333.94	334.23	333.14	334.08	50688.0
2020-09-29 05:00:00	SPY	ETF	334.04	334.33	333.5	334.28	30047.0
2020-09-29 06:00:00	SPY	ETF	334.2	334.61	334.1	334.19	32757.0
2020-09-29 07:00:00	SPY	ETF	334.33	334.76	333.92	333.99	197903.0
2020-09-29 08:00:00	SPY	ETF	334.1001	336.0	333.59	334.28	419220.0
2020-09-29 09:00:00	SPY	ETF	334.23	334.44	333.43	333.885	3867856.0
2020-09-29 10:00:00	SPY	ETF	333.88	334.77	332.64	332.95	8356612.0
2020-09-29 11:00:00	SPY	ETF	332.94	333.35	331.8	332.15	6150207.0
2020-09-29 12:00:00	SPY	ETF	332.16	332.75	331.71	332.69	4211663.0
2020-09-29 13:00:00	SPY	ETF	332.695	333.55	331.6209	333.26	4177388.0
2020-09-29 14:00:00	SPY	ETF	333.255	333.885	332.93	333.33	4303614.0
2020-09-29 15:00:00	SPY	ETF	333.32	333.7611	332.37	332.39	10944045.0
2020-09-29 16:00:00	SPY	ETF	332.4	333.64	332.34	332.9	6107662.0
2020-09-29 17:00:00	SPY	ETF	332.74	332.9	332.69	332.79	108124.0
2020-09-29 18:00:00	SPY	ETF	332.79	333.58	332.72	333.38	185751.0
2020-09-29 19:00:00	SPY	ETF	333.38	333.65	333.35	333.55	92772.0
2020-09-29 04:00:00	QQQ	ETF	277.45	277.46	276.45	277.11	29436.0
2020-09-29 05:00:00	QQQ	ETF	277.04	277.48	276.7	277.35	35042.0
2020-09-29 06:00:00	QQQ	ETF	277.24	277.79	277.07	277.3	40310.0
2020-09-29 07:00:00	QQQ	ETF	277.45	277.84	276.79	276.81	181114.0
2020-09-29 08:00:00	QQQ	ETF	277.614	279.02	276.6	277.24	462525.0
2020-09-29 09:00:00	QQQ	ETF	277.29	277.56	276.34	276.78	2631311.0
2020-09-29 10:00:00	QQQ	ETF	276.78	277.71	275.3719	276.06	4438927.0
2020-09-29 11:00:00	QQQ	ETF	276.07	277.17	275.65	276.231	2831716.0
2020-09-29 12:00:00	QQQ	ETF	276.23	276.85	275.9	276.76	1687767.0
2020-09-29 13:00:00	QQQ	ETF	276.76	277.11	275.4657	276.77	2511129.0
2020-09-29 14:00:00	QQQ	ETF	276.76	277.2182	276.38	276.715	1765499.0
2020-09-29 15:00:00	QQQ	ETF	276.74	277.02	275.52	275.86	3743338.0
2020-09-29 16:00:00	QQQ	ETF	275.86	276.76	275.85	276.15	829510.0
2020-09-29 17:00:00	QQQ	ETF	276.06	276.45	276.0	276.18	28579.0
2020-09-29 18:00:00	QQQ	ETF	276.01	276.73	275.97	276.57	76233.0
2020-09-29 19:00:00	QQQ	ETF	276.59	276.81	276.45	276.6	69914.0
2020-09-29 04:00:00	IWM	ETF	149.3	149.59	149.3	149.35	6877.0
2020-09-29 05:00:00	IWM	ETF	149.44	149.75	149.36	149.75	2910.0
2020-09-29 06:00:00	IWM	ETF	149.72	149.89	149.7	149.72	4837.0
2020-09-29 07:00:00	IWM	ETF	149.85	150.06	149.7	149.8	40616.0
2020-09-29 08:00:00	IWM	ETF	149.82	150.65	149.27	149.9399	447041.0
2020-09-29 09:00:00	IWM	ETF	149.9096	149.995	149.15	149.67	2209411.0
2020-09-29 10:00:00	IWM	ETF	149.67	150.28	148.35	148.4561	3600001.0
2020-09-29 11:00:00	IWM	ETF	148.47	149.1599	148.01	148.29	1482609.0
2020-09-29 12:00:00	IWM	ETF	148.3	149.34	148.0	149.01	1675770.0
2020-09-29 13:00:00	IWM	ETF	149.02	149.36	148.36	149.23	1514930.0
2020-09-29 14:00:00	IWM	ETF	149.24	150.06	149.07	149.6734	1355442.0
2020-09-29 15:00:00	IWM	ETF	149.68	149.98	149.25	149.32	2504531.0
2020-09-29 16:00:00	IWM	ETF	149.34	150.18	149.34	149.78	955797.0
2020-09-29 17:00:00	IWM	ETF	149.77	150.09	149.5	149.89	15830.0
2020-09-29 18:00:00	IWM	ETF	149.86	150.19	149.75	150.19	22722.0
2020-09-29 19:00:00	IWM	ETF	150.1	150.2	150.061	150.09	6000.0
2020-09-29 04:00:00	DIA	ETF	275.0	275.71	275.0	275.71	2400.0
2020-09-29 05:00:00	DIA	ETF	275.39	275.67	275.39	275.67	500.0

> showing 50 of 12,227 rows — these rows as CSV

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