PREVIEW / etf_1hour / 2019-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-11.parquet
  size:    352 KB
  rows:    11,650

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-10-11 04:00:00	SPY	ETF	294.85	296.0	294.85	296.0	43393.0
2019-10-11 05:00:00	SPY	ETF	296.0	296.62	296.0	296.19	73125.0
2019-10-11 06:00:00	SPY	ETF	296.17	296.41	296.0	296.19	113655.0
2019-10-11 07:00:00	SPY	ETF	296.14	296.72	295.98	296.41	451875.0
2019-10-11 08:00:00	SPY	ETF	296.42	296.65	294.48	296.2	826254.0
2019-10-11 09:00:00	SPY	ETF	296.21	297.75	295.97	297.26	9045202.0
2019-10-11 10:00:00	SPY	ETF	297.29	297.96	297.2601	297.7	9276553.0
2019-10-11 11:00:00	SPY	ETF	297.69	298.74	297.61	297.7588	13722238.0
2019-10-11 12:00:00	SPY	ETF	297.76	297.85	296.1448	297.65	9986773.0
2019-10-11 13:00:00	SPY	ETF	297.63	298.23	297.115	298.13	8781514.0
2019-10-11 14:00:00	SPY	ETF	298.12	298.48	297.66	298.29	5070827.0
2019-10-11 15:00:00	SPY	ETF	298.3	298.64	296.16	296.26	27649873.0
2019-10-11 16:00:00	SPY	ETF	296.26	296.97	293.1826	296.47	14137627.0
2019-10-11 17:00:00	SPY	ETF	296.5	296.64	296.28	296.6	456344.0
2019-10-11 18:00:00	SPY	ETF	296.6	296.85	296.52	296.74	76289.0
2019-10-11 19:00:00	SPY	ETF	296.75	296.9	296.6099	296.85	41581.0
2019-10-11 04:00:00	QQQ	ETF	189.99	190.85	189.97	190.8	44613.0
2019-10-11 05:00:00	QQQ	ETF	190.77	191.16	190.77	190.84	47222.0
2019-10-11 06:00:00	QQQ	ETF	190.88	191.02	190.7	190.78	88689.0
2019-10-11 07:00:00	QQQ	ETF	190.76	191.25	190.67	190.89	176038.0
2019-10-11 08:00:00	QQQ	ETF	190.71	191.03	189.49	190.7	207295.0
2019-10-11 09:00:00	QQQ	ETF	190.73	191.85	190.56	191.5308	5571874.0
2019-10-11 10:00:00	QQQ	ETF	191.55	192.11	191.55	191.94	4321665.0
2019-10-11 11:00:00	QQQ	ETF	191.93	192.46	191.73	191.83	5489349.0
2019-10-11 12:00:00	QQQ	ETF	191.84	191.99	190.72	191.91	3619586.0
2019-10-11 13:00:00	QQQ	ETF	191.91	192.34	191.61	192.26	3223204.0
2019-10-11 14:00:00	QQQ	ETF	192.26	192.42	191.96	192.3665	1861904.0
2019-10-11 15:00:00	QQQ	ETF	192.36	192.63	190.98	191.01	9030705.0
2019-10-11 16:00:00	QQQ	ETF	191.07	191.55	190.65	191.18	1779516.0
2019-10-11 17:00:00	QQQ	ETF	191.2	191.44	191.15	191.36	17077.0
2019-10-11 18:00:00	QQQ	ETF	191.39	191.4	191.11	191.33	29815.0
2019-10-11 19:00:00	QQQ	ETF	191.35	191.56	191.33	191.36	13640.0
2019-10-11 04:00:00	IWM	ETF	148.73	149.16	148.73	149.16	6300.0
2019-10-11 05:00:00	IWM	ETF	149.5	149.66	149.44	149.6	8272.0
2019-10-11 06:00:00	IWM	ETF	149.62	149.65	149.5	149.55	27200.0
2019-10-11 07:00:00	IWM	ETF	149.57	149.97	149.45	149.76	97922.0
2019-10-11 08:00:00	IWM	ETF	149.89	150.0	148.54	149.78	38161.0
2019-10-11 09:00:00	IWM	ETF	149.7	150.97	149.51	150.64	4540083.0
2019-10-11 10:00:00	IWM	ETF	150.65	151.96	150.64	151.62	5740898.0
2019-10-11 11:00:00	IWM	ETF	151.63	151.94	150.91	151.16	3649189.0
2019-10-11 12:00:00	IWM	ETF	151.17	151.42	150.53	151.32	2139945.0
2019-10-11 13:00:00	IWM	ETF	151.32	151.55	150.775	151.515	1736875.0
2019-10-11 14:00:00	IWM	ETF	151.515	151.68	151.07	151.4652	1446745.0
2019-10-11 15:00:00	IWM	ETF	151.47	151.57	150.23	150.27	4920624.0
2019-10-11 16:00:00	IWM	ETF	150.22	150.56	150.0	150.39	1305158.0
2019-10-11 17:00:00	IWM	ETF	150.39	150.43	150.24	150.35	31020.0
2019-10-11 18:00:00	IWM	ETF	150.36	150.45	150.36	150.42	7880.0
2019-10-11 19:00:00	IWM	ETF	150.45	150.5	150.42	150.42	3738.0
2019-10-11 04:00:00	DIA	ETF	267.07	267.4	267.07	267.4	1100.0
2019-10-11 05:00:00	DIA	ETF	267.54	267.62	267.54	267.62	211.0

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

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