PREVIEW / etf_1hour / 2019-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-23.parquet
  size:    344 KB
  rows:    11,356

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
2019-08-23 04:00:00	SPY	ETF	293.14	293.5	293.1	293.39	10450.0
2019-08-23 05:00:00	SPY	ETF	293.35	293.48	293.14	293.29	7404.0
2019-08-23 06:00:00	SPY	ETF	293.28	293.29	292.7	292.85	16585.0
2019-08-23 07:00:00	SPY	ETF	292.89	293.45	292.86	293.19	303224.0
2019-08-23 08:00:00	SPY	ETF	292.98	293.57	290.25	291.17	3041240.0
2019-08-23 09:00:00	SPY	ETF	291.13	291.21	290.12	290.93	7044978.0
2019-08-23 10:00:00	SPY	ETF	290.92	292.76	290.43	291.8	17562713.0
2019-08-23 11:00:00	SPY	ETF	291.8	292.06	286.63	286.7	29272013.0
2019-08-23 12:00:00	SPY	ETF	286.71	287.7	286.37	286.8035	12971043.0
2019-08-23 13:00:00	SPY	ETF	286.8	287.0	285.79	286.62	10950699.0
2019-08-23 14:00:00	SPY	ETF	286.62	286.62	285.35	285.88	7979804.0
2019-08-23 15:00:00	SPY	ETF	285.88	286.3	283.47	284.81	33001637.0
2019-08-23 16:00:00	SPY	ETF	284.82	292.749	284.7216	285.11	22745171.0
2019-08-23 17:00:00	SPY	ETF	285.17	285.17	283.33	284.9	1816512.0
2019-08-23 18:00:00	SPY	ETF	284.84	284.99	284.73	284.8	100524.0
2019-08-23 19:00:00	SPY	ETF	284.81	284.87	284.66	284.77	79841.0
2019-08-23 04:00:00	QQQ	ETF	188.74	189.1	188.68	189.03	8889.0
2019-08-23 05:00:00	QQQ	ETF	188.97	189.04	188.76	188.87	13470.0
2019-08-23 06:00:00	QQQ	ETF	188.86	188.9	188.36	188.5	32820.0
2019-08-23 07:00:00	QQQ	ETF	188.54	188.85	188.45	188.7	162387.0
2019-08-23 08:00:00	QQQ	ETF	188.52	189.1	186.21	186.97	1424078.0
2019-08-23 09:00:00	QQQ	ETF	186.96	187.04	185.94	186.57	3531876.0
2019-08-23 10:00:00	QQQ	ETF	186.58	188.45	186.25	187.63	7404016.0
2019-08-23 11:00:00	QQQ	ETF	187.64	187.86	183.38	183.39	10894897.0
2019-08-23 12:00:00	QQQ	ETF	183.39	184.04	183.15	183.55	5156815.0
2019-08-23 13:00:00	QQQ	ETF	183.54	183.54	182.52	183.08	3627667.0
2019-08-23 14:00:00	QQQ	ETF	183.07	183.07	182.27	182.66	2647886.0
2019-08-23 15:00:00	QQQ	ETF	182.6565	183.055	181.56	182.17	10423260.0
2019-08-23 16:00:00	QQQ	ETF	182.18	183.15	182.07	182.6	3248072.0
2019-08-23 17:00:00	QQQ	ETF	182.52	182.59	181.5	182.26	749520.0
2019-08-23 18:00:00	QQQ	ETF	182.17	182.35	182.16	182.21	50571.0
2019-08-23 19:00:00	QQQ	ETF	182.2	182.3	182.16	182.16	25518.0
2019-08-23 04:00:00	IWM	ETF	150.55	150.68	150.55	150.67	10000.0
2019-08-23 05:00:00	IWM	ETF	150.58	150.58	150.54	150.54	8200.0
2019-08-23 06:00:00	IWM	ETF	150.35	150.35	150.35	150.35	2000.0
2019-08-23 07:00:00	IWM	ETF	150.43	150.6	150.43	150.45	63715.0
2019-08-23 08:00:00	IWM	ETF	150.45	150.45	148.91	149.4	337259.0
2019-08-23 09:00:00	IWM	ETF	149.47	149.47	148.41	149.05	2842004.0
2019-08-23 10:00:00	IWM	ETF	149.05	150.11	148.75	149.81	3938927.0
2019-08-23 11:00:00	IWM	ETF	149.82	149.89	146.565	146.655	6754867.0
2019-08-23 12:00:00	IWM	ETF	146.66	147.18	146.24	146.36	3386759.0
2019-08-23 13:00:00	IWM	ETF	146.35	146.58	145.6	146.04	3260274.0
2019-08-23 14:00:00	IWM	ETF	146.01	146.19	145.65	146.07	2281742.0
2019-08-23 15:00:00	IWM	ETF	146.06	146.3	144.93	145.4	8166633.0
2019-08-23 16:00:00	IWM	ETF	145.4	146.1	145.31	145.59	2462198.0
2019-08-23 17:00:00	IWM	ETF	145.55	145.76	145.0	145.43	92489.0
2019-08-23 18:00:00	IWM	ETF	145.43	145.43	145.43	145.43	5722.0
2019-08-23 19:00:00	IWM	ETF	145.54	145.54	145.35	145.35	925.0
2019-08-23 05:00:00	DIA	ETF	263.25	263.25	263.25	263.25	500.0
2019-08-23 06:00:00	DIA	ETF	263.25	263.25	262.74	262.74	300.0

> showing 50 of 11,356 rows — these rows as CSV

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