PREVIEW / etf_1hour / 2019-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-12.parquet
  size:    344 KB
  rows:    11,210

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-09-12 04:00:00	SPY	ETF	301.15	301.22	300.95	300.95	10252.0
2019-09-12 05:00:00	SPY	ETF	301.04	301.05	300.89	300.93	7680.0
2019-09-12 06:00:00	SPY	ETF	300.98	301.02	300.78	300.78	67360.0
2019-09-12 07:00:00	SPY	ETF	300.82	301.57	300.54	301.25	941663.0
2019-09-12 08:00:00	SPY	ETF	300.8499	301.84	300.79	301.22	931828.0
2019-09-12 09:00:00	SPY	ETF	301.23	301.66	300.41	300.89	9604124.0
2019-09-12 10:00:00	SPY	ETF	300.91	302.37	300.46	300.84	18811217.0
2019-09-12 11:00:00	SPY	ETF	300.84	301.85	300.63	301.79	7059936.0
2019-09-12 12:00:00	SPY	ETF	301.78	302.11	301.45	302.05	5117289.0
2019-09-12 13:00:00	SPY	ETF	302.05	302.46	301.9802	302.18	5101723.0
2019-09-12 14:00:00	SPY	ETF	302.19	302.42	301.87	302.15	6999935.0
2019-09-12 15:00:00	SPY	ETF	302.15	302.2	301.13	301.27	12196165.0
2019-09-12 16:00:00	SPY	ETF	301.27	301.55	301.11	301.15	3560985.0
2019-09-12 17:00:00	SPY	ETF	301.28	301.4	301.15	301.37	162226.0
2019-09-12 18:00:00	SPY	ETF	301.33	301.78	301.32	301.67	314162.0
2019-09-12 19:00:00	SPY	ETF	301.69	301.75	301.59	301.75	42391.0
2019-09-12 04:00:00	QQQ	ETF	193.49	193.49	193.06	193.09	19644.0
2019-09-12 05:00:00	QQQ	ETF	193.1	193.21	193.04	193.16	12877.0
2019-09-12 06:00:00	QQQ	ETF	193.18	193.18	192.95	192.99	26620.0
2019-09-12 07:00:00	QQQ	ETF	193.05	193.74	192.9	193.56	202752.0
2019-09-12 08:00:00	QQQ	ETF	193.21	193.9	193.05	193.69	409689.0
2019-09-12 09:00:00	QQQ	ETF	193.71	194.1	192.97	193.5	4203409.0
2019-09-12 10:00:00	QQQ	ETF	193.52	194.71	193.1127	193.57	7355515.0
2019-09-12 11:00:00	QQQ	ETF	193.55	194.0	193.29	193.91	2146146.0
2019-09-12 12:00:00	QQQ	ETF	193.92	194.04	193.53	194.0	1386650.0
2019-09-12 13:00:00	QQQ	ETF	194.0	194.32	193.86	194.02	1890809.0
2019-09-12 14:00:00	QQQ	ETF	194.0299	194.23	193.8	194.0299	1367019.0
2019-09-12 15:00:00	QQQ	ETF	194.03	194.05	193.15	193.21	3779336.0
2019-09-12 16:00:00	QQQ	ETF	193.21	193.32	192.43	193.0	2331562.0
2019-09-12 17:00:00	QQQ	ETF	193.07	193.18	192.96	193.18	10791.0
2019-09-12 18:00:00	QQQ	ETF	193.2	193.45	193.2	193.4	45831.0
2019-09-12 19:00:00	QQQ	ETF	193.44	193.5	193.35	193.5	51791.0
2019-09-12 04:00:00	IWM	ETF	157.3	157.32	157.23	157.26	715.0
2019-09-12 05:00:00	IWM	ETF	157.32	157.32	157.21	157.21	6600.0
2019-09-12 06:00:00	IWM	ETF	157.23	157.25	157.16	157.19	8500.0
2019-09-12 07:00:00	IWM	ETF	157.19	157.55	156.99	157.26	124071.0
2019-09-12 08:00:00	IWM	ETF	157.4599	157.4599	156.91	157.07	559714.0
2019-09-12 09:00:00	IWM	ETF	157.08	157.3	155.57	156.54	4748148.0
2019-09-12 10:00:00	IWM	ETF	156.54	157.9	155.99	155.995	6699862.0
2019-09-12 11:00:00	IWM	ETF	156.0	157.3	155.725	157.05	2993715.0
2019-09-12 12:00:00	IWM	ETF	157.04	157.19	156.54	157.11	1695061.0
2019-09-12 13:00:00	IWM	ETF	157.1	157.24	156.84	156.89	1335359.0
2019-09-12 14:00:00	IWM	ETF	156.895	157.34	156.67	157.065	1678564.0
2019-09-12 15:00:00	IWM	ETF	157.06	157.62	156.92	157.0	6039592.0
2019-09-12 16:00:00	IWM	ETF	157.0	157.38	156.9321	157.13	2332813.0
2019-09-12 17:00:00	IWM	ETF	157.1	157.15	157.1	157.15	5277.0
2019-09-12 18:00:00	IWM	ETF	157.16	157.51	157.11	157.42	43800.0
2019-09-12 19:00:00	IWM	ETF	157.39	157.47	157.34	157.47	3595.0
2019-09-12 04:00:00	DIA	ETF	272.54	272.54	272.54	272.54	100.0
2019-09-12 06:00:00	DIA	ETF	272.27	272.27	272.27	272.27	100.0

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

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