PREVIEW / etf_1hour / 2018-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-01.parquet
  size:    314 KB
  rows:    10,328

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-02-01 04:00:00	SPY	ETF	282.63	282.71	282.38	282.47	5220.0
2018-02-01 05:00:00	SPY	ETF	282.42	282.57	282.27	282.29	12630.0
2018-02-01 06:00:00	SPY	ETF	282.14	282.34	282.03	282.19	63188.0
2018-02-01 07:00:00	SPY	ETF	282.22	282.25	281.89	282.25	232676.0
2018-02-01 08:00:00	SPY	ETF	282.22	282.94	280.75	281.11	1477882.0
2018-02-01 09:00:00	SPY	ETF	281.12	281.92	280.37	281.66	9708310.0
2018-02-01 10:00:00	SPY	ETF	281.66	281.98	281.225	281.625	8359407.0
2018-02-01 11:00:00	SPY	ETF	281.62	282.87	281.54	282.845	9340710.0
2018-02-01 12:00:00	SPY	ETF	282.8554	282.98	282.6	282.69	6282644.0
2018-02-01 13:00:00	SPY	ETF	282.69	283.06	281.91	282.03	6665442.0
2018-02-01 14:00:00	SPY	ETF	282.03	282.17	281.08	282.13	12505636.0
2018-02-01 15:00:00	SPY	ETF	282.13	282.21	280.68	281.6	20730222.0
2018-02-01 16:00:00	SPY	ETF	281.59	281.96	281.18	281.78	11854288.0
2018-02-01 17:00:00	SPY	ETF	281.74	282.1	281.58	282.1	2145454.0
2018-02-01 18:00:00	SPY	ETF	282.1	282.47	281.94	282.09	246594.0
2018-02-01 19:00:00	SPY	ETF	282.14	282.21	281.75	281.8	41052.0
2018-02-01 04:00:00	QQQ	ETF	169.55	169.55	169.39	169.48	11874.0
2018-02-01 05:00:00	QQQ	ETF	169.41	169.54	169.32	169.32	7589.0
2018-02-01 06:00:00	QQQ	ETF	169.23	169.46	169.21	169.27	16650.0
2018-02-01 07:00:00	QQQ	ETF	169.24	169.24	168.98	169.18	124504.0
2018-02-01 08:00:00	QQQ	ETF	169.19	169.84	167.91	168.16	487567.0
2018-02-01 09:00:00	QQQ	ETF	168.18	169.14	167.78	168.995	4747530.0
2018-02-01 10:00:00	QQQ	ETF	168.98	169.565	168.76	169.43	4316663.0
2018-02-01 11:00:00	QQQ	ETF	169.425	169.555	168.985	169.47	2447005.0
2018-02-01 12:00:00	QQQ	ETF	169.48	169.58	169.24	169.456	1838972.0
2018-02-01 13:00:00	QQQ	ETF	169.4577	169.73	168.76	168.8	2914110.0
2018-02-01 14:00:00	QQQ	ETF	168.8	168.95	168.15	168.8	4769192.0
2018-02-01 15:00:00	QQQ	ETF	168.79	168.84	167.42	167.97	7831287.0
2018-02-01 16:00:00	QQQ	ETF	167.97	169.0795	167.51	168.69	3506256.0
2018-02-01 17:00:00	QQQ	ETF	168.7	169.11	168.42	169.08	300617.0
2018-02-01 18:00:00	QQQ	ETF	169.08	169.31	168.97	169.09	73405.0
2018-02-01 19:00:00	QQQ	ETF	169.06	169.09	168.81	168.88	16805.0
2018-02-01 04:00:00	IWM	ETF	157.17	157.19	157.12	157.12	7618.0
2018-02-01 05:00:00	IWM	ETF	156.89	156.89	156.89	156.89	300.0
2018-02-01 06:00:00	IWM	ETF	156.79	156.88	156.75	156.84	1272.0
2018-02-01 07:00:00	IWM	ETF	156.77	156.88	156.57	156.8	24430.0
2018-02-01 08:00:00	IWM	ETF	156.81	157.05	155.73	155.89	199168.0
2018-02-01 09:00:00	IWM	ETF	155.9	156.385	155.41	156.0	2629400.0
2018-02-01 10:00:00	IWM	ETF	155.96	156.55	155.85	155.985	3462047.0
2018-02-01 11:00:00	IWM	ETF	155.99	156.76	155.695	156.51	1944920.0
2018-02-01 12:00:00	IWM	ETF	156.53	156.98	156.37	156.9	1440307.0
2018-02-01 13:00:00	IWM	ETF	156.91	157.21	156.58	156.65	1324446.0
2018-02-01 14:00:00	IWM	ETF	156.63	156.93	156.18	156.84	1796338.0
2018-02-01 15:00:00	IWM	ETF	156.835	156.93	156.26	156.88	3457798.0
2018-02-01 16:00:00	IWM	ETF	156.85	157.24	156.71	156.96	2918203.0
2018-02-01 17:00:00	IWM	ETF	157.09	157.14	156.91	157.13	1530.0
2018-02-01 18:00:00	IWM	ETF	157.2	157.32	156.99	157.1	11256.0
2018-02-01 19:00:00	IWM	ETF	157.01	157.1	156.85	156.85	12342.0
2018-02-01 06:00:00	DIA	ETF	261.01	261.01	261.01	261.01	9995.0
2018-02-01 07:00:00	DIA	ETF	261.13	261.13	261.13	261.13	108.0

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

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