PREVIEW / etf_1hour / 2018-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-01.parquet
  size:    316 KB
  rows:    10,422

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
2018-10-01 04:00:00	SPY	ETF	292.21	292.47	292.21	292.47	11084.0
2018-10-01 05:00:00	SPY	ETF	292.41	292.46	292.33	292.41	65290.0
2018-10-01 06:00:00	SPY	ETF	292.46	292.46	292.2	292.37	47282.0
2018-10-01 07:00:00	SPY	ETF	292.33	292.48	292.11	292.29	199117.0
2018-10-01 08:00:00	SPY	ETF	292.33	292.4101	290.72	292.05	305237.0
2018-10-01 09:00:00	SPY	ETF	292.05	292.65	292.0	292.5795	7040374.0
2018-10-01 10:00:00	SPY	ETF	292.575	292.93	292.49	292.68	8314653.0
2018-10-01 11:00:00	SPY	ETF	292.68	292.75	292.35	292.52	4145231.0
2018-10-01 12:00:00	SPY	ETF	292.52	292.535	291.86	291.98	5605702.0
2018-10-01 13:00:00	SPY	ETF	291.975	292.26	291.91	292.04	5133954.0
2018-10-01 14:00:00	SPY	ETF	292.04	292.05	291.67	291.985	5771569.0
2018-10-01 15:00:00	SPY	ETF	291.98	292.08	290.98	291.67	18119613.0
2018-10-01 16:00:00	SPY	ETF	291.68	291.81	291.49	291.67	5853496.0
2018-10-01 17:00:00	SPY	ETF	291.7	291.73	291.66	291.7	57407.0
2018-10-01 18:00:00	SPY	ETF	291.68	291.75	291.6	291.7	47849.0
2018-10-01 19:00:00	SPY	ETF	291.6601	291.75	291.63	291.69	26185.0
2018-10-01 04:00:00	QQQ	ETF	186.8	187.23	186.8	187.17	25945.0
2018-10-01 05:00:00	QQQ	ETF	187.21	187.32	187.13	187.31	31700.0
2018-10-01 06:00:00	QQQ	ETF	187.31	187.31	187.15	187.18	14050.0
2018-10-01 07:00:00	QQQ	ETF	187.11	187.19	186.95	187.0	104370.0
2018-10-01 08:00:00	QQQ	ETF	187.0799	187.16	185.79	186.85	250133.0
2018-10-01 09:00:00	QQQ	ETF	186.83	187.46	186.65	187.32	3504299.0
2018-10-01 10:00:00	QQQ	ETF	187.33	187.53	187.11	187.3	3127805.0
2018-10-01 11:00:00	QQQ	ETF	187.31	187.31	186.88	187.05	2231432.0
2018-10-01 12:00:00	QQQ	ETF	187.05	187.08	186.42	186.51	3009122.0
2018-10-01 13:00:00	QQQ	ETF	186.51	186.77	186.44	186.621	2173086.0
2018-10-01 14:00:00	QQQ	ETF	186.63	186.63	186.0	186.365	2660691.0
2018-10-01 15:00:00	QQQ	ETF	186.37	186.42	185.7	186.14	5250277.0
2018-10-01 16:00:00	QQQ	ETF	186.14	186.32	186.01	186.2	896504.0
2018-10-01 17:00:00	QQQ	ETF	186.34	186.34	186.2	186.29	6444.0
2018-10-01 18:00:00	QQQ	ETF	186.23	186.29	186.17	186.23	20343.0
2018-10-01 19:00:00	QQQ	ETF	186.24	186.3	186.21	186.26	27044.0
2018-10-01 05:00:00	IWM	ETF	169.52	169.52	169.49	169.49	4599.0
2018-10-01 06:00:00	IWM	ETF	169.46	169.49	169.31	169.41	4667.0
2018-10-01 07:00:00	IWM	ETF	169.32	169.38	169.26	169.26	47275.0
2018-10-01 08:00:00	IWM	ETF	169.29	169.49	168.55	169.27	225805.0
2018-10-01 09:00:00	IWM	ETF	169.29	169.39	168.19	168.7	3561396.0
2018-10-01 10:00:00	IWM	ETF	168.71	168.91	168.03	168.08	3189236.0
2018-10-01 11:00:00	IWM	ETF	168.09	168.11	167.42	167.49	2013524.0
2018-10-01 12:00:00	IWM	ETF	167.495	167.63	167.0	167.07	2197808.0
2018-10-01 13:00:00	IWM	ETF	167.065	167.48	167.01	167.09	1463391.0
2018-10-01 14:00:00	IWM	ETF	167.1	167.11	166.7	166.88	2103806.0
2018-10-01 15:00:00	IWM	ETF	166.87	166.92	165.77	166.25	5898257.0
2018-10-01 16:00:00	IWM	ETF	166.1791	168.5205	166.06	166.4	1713334.0
2018-10-01 17:00:00	IWM	ETF	166.4	166.45	166.33	166.44	4285.0
2018-10-01 18:00:00	IWM	ETF	166.45	166.5	166.37	166.42	5409.0
2018-10-01 19:00:00	IWM	ETF	166.45	166.46	166.36	166.43	2650.0
2018-10-01 06:00:00	DIA	ETF	266.23	266.33	266.23	266.33	800.0
2018-10-01 07:00:00	DIA	ETF	266.22	266.42	266.06	266.42	1686.0
2018-10-01 08:00:00	DIA	ETF	266.4	266.4	264.4	266.07	8689.0

> showing 50 of 10,422 rows — these rows as CSV

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