PREVIEW / etf_1hour / 2019-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-04.parquet
  size:    355 KB
  rows:    11,759

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-11-04 04:00:00	SPY	ETF	307.01	307.35	307.01	307.31	50825.0
2019-11-04 05:00:00	SPY	ETF	307.36	307.68	307.36	307.53	21544.0
2019-11-04 06:00:00	SPY	ETF	307.53	307.62	307.42	307.49	45064.0
2019-11-04 07:00:00	SPY	ETF	307.45	307.5	307.32	307.4	66873.0
2019-11-04 08:00:00	SPY	ETF	307.39	308.05	306.66	307.89	428571.0
2019-11-04 09:00:00	SPY	ETF	307.86	308.0	307.535	307.63	5692178.0
2019-11-04 10:00:00	SPY	ETF	307.625	307.87	307.32	307.53	15405037.0
2019-11-04 11:00:00	SPY	ETF	307.53	307.81	307.34	307.36	7536060.0
2019-11-04 12:00:00	SPY	ETF	307.36	307.55	307.23	307.52	5477582.0
2019-11-04 13:00:00	SPY	ETF	307.52	307.65	307.39	307.59	2923736.0
2019-11-04 14:00:00	SPY	ETF	307.6	307.65	307.37	307.415	4363605.0
2019-11-04 15:00:00	SPY	ETF	307.41	307.51	306.96	307.34	11767760.0
2019-11-04 16:00:00	SPY	ETF	307.33	307.44	307.14	307.29	5504470.0
2019-11-04 17:00:00	SPY	ETF	307.29	307.42	307.27	307.42	114511.0
2019-11-04 18:00:00	SPY	ETF	307.38	308.35	307.14	307.92	274819.0
2019-11-04 19:00:00	SPY	ETF	307.92	307.92	307.5	307.58	58228.0
2019-11-04 04:00:00	QQQ	ETF	199.52	199.81	199.52	199.75	23252.0
2019-11-04 05:00:00	QQQ	ETF	199.8	200.15	199.8	200.03	36631.0
2019-11-04 06:00:00	QQQ	ETF	200.04	200.09	199.88	199.97	22869.0
2019-11-04 07:00:00	QQQ	ETF	199.98	200.0	199.85	199.89	59352.0
2019-11-04 08:00:00	QQQ	ETF	199.89	200.44	199.23	200.25	175910.0
2019-11-04 09:00:00	QQQ	ETF	200.23	200.5251	200.0475	200.18	2994400.0
2019-11-04 10:00:00	QQQ	ETF	200.19	200.285	199.81	199.92	2041945.0
2019-11-04 11:00:00	QQQ	ETF	199.93	200.15	199.74	199.78	1568999.0
2019-11-04 12:00:00	QQQ	ETF	199.7801	200.1	199.75	200.09	1142104.0
2019-11-04 13:00:00	QQQ	ETF	200.09	200.31	200.01	200.26	1289490.0
2019-11-04 14:00:00	QQQ	ETF	200.25	200.37	200.1	200.27	1555359.0
2019-11-04 15:00:00	QQQ	ETF	200.26	200.27	199.91	200.07	3087547.0
2019-11-04 16:00:00	QQQ	ETF	200.09	200.2	199.89	200.17	661785.0
2019-11-04 17:00:00	QQQ	ETF	200.15	200.2	200.13	200.2	22890.0
2019-11-04 18:00:00	QQQ	ETF	200.21	200.79	200.0	200.69	135592.0
2019-11-04 19:00:00	QQQ	ETF	200.66	200.66	200.37	200.4	54144.0
2019-11-04 04:00:00	IWM	ETF	158.66	158.92	158.66	158.85	1081.0
2019-11-04 05:00:00	IWM	ETF	158.91	159.12	158.91	159.12	863.0
2019-11-04 06:00:00	IWM	ETF	159.06	159.07	159.0	159.02	10954.0
2019-11-04 07:00:00	IWM	ETF	159.06	159.21	159.06	159.19	25566.0
2019-11-04 08:00:00	IWM	ETF	159.0999	159.57	159.0999	159.52	146838.0
2019-11-04 09:00:00	IWM	ETF	159.48	159.7	158.92	159.02	2510030.0
2019-11-04 10:00:00	IWM	ETF	159.02	159.0529	158.47	158.68	1936285.0
2019-11-04 11:00:00	IWM	ETF	158.688	159.08	158.57	158.74	1202960.0
2019-11-04 12:00:00	IWM	ETF	158.745	159.12	158.72	159.12	1222929.0
2019-11-04 13:00:00	IWM	ETF	159.1029	159.3	158.99	159.22	1151156.0
2019-11-04 14:00:00	IWM	ETF	159.225	159.23	158.9	158.95	1010267.0
2019-11-04 15:00:00	IWM	ETF	158.95	159.12	158.6	158.89	3211864.0
2019-11-04 16:00:00	IWM	ETF	158.95	159.06	158.78	158.85	1228739.0
2019-11-04 17:00:00	IWM	ETF	158.81	158.93	158.75	158.93	201150.0
2019-11-04 18:00:00	IWM	ETF	158.85	159.4	158.7	159.23	66605.0
2019-11-04 19:00:00	IWM	ETF	159.24	159.24	158.99	159.01	7100.0
2019-11-04 06:00:00	DIA	ETF	274.44	274.44	274.42	274.42	700.0
2019-11-04 07:00:00	DIA	ETF	274.41	274.46	274.38	274.4	6896.0

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

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