PREVIEW / etf_1hour / 2019-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-27.parquet
  size:    316 KB
  rows:    10,519

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-02-27 04:00:00	SPY	ETF	278.1	278.28	278.01	278.27	9129.0
2019-02-27 05:00:00	SPY	ETF	278.22	278.52	278.17	278.45	8827.0
2019-02-27 06:00:00	SPY	ETF	278.49	278.57	278.41	278.48	35587.0
2019-02-27 07:00:00	SPY	ETF	278.48	278.71	278.44	278.6	132544.0
2019-02-27 08:00:00	SPY	ETF	278.6	279.22	278.23	278.46	214409.0
2019-02-27 09:00:00	SPY	ETF	278.48	279.23	278.45	278.75	4847450.0
2019-02-27 10:00:00	SPY	ETF	278.735	278.87	277.48	278.105	14452205.0
2019-02-27 11:00:00	SPY	ETF	278.1	278.79	278.0	278.66	6109955.0
2019-02-27 12:00:00	SPY	ETF	278.665	279.08	278.6375	278.88	3764261.0
2019-02-27 13:00:00	SPY	ETF	278.8701	279.46	278.87	279.18	5784162.0
2019-02-27 14:00:00	SPY	ETF	279.185	279.59	279.06	279.29	4496863.0
2019-02-27 15:00:00	SPY	ETF	279.28	279.54	278.89	279.23	11378369.0
2019-02-27 16:00:00	SPY	ETF	279.21	279.69	279.17	279.58	3507320.0
2019-02-27 17:00:00	SPY	ETF	279.58	279.58	279.4	279.45	854625.0
2019-02-27 18:00:00	SPY	ETF	279.49	279.52	279.33	279.41	124093.0
2019-02-27 19:00:00	SPY	ETF	279.34	279.34	279.06	279.07	93189.0
2019-02-27 04:00:00	QQQ	ETF	172.81	172.98	172.8	172.98	22756.0
2019-02-27 05:00:00	QQQ	ETF	172.95	173.17	172.93	173.13	39542.0
2019-02-27 06:00:00	QQQ	ETF	173.13	173.16	173.03	173.11	9700.0
2019-02-27 07:00:00	QQQ	ETF	173.09	173.24	173.05	173.07	93046.0
2019-02-27 08:00:00	QQQ	ETF	173.19	173.34	172.88	172.91	353208.0
2019-02-27 09:00:00	QQQ	ETF	172.91	173.49	172.71	172.795	2581055.0
2019-02-27 10:00:00	QQQ	ETF	172.8	172.92	171.76	172.27	6420633.0
2019-02-27 11:00:00	QQQ	ETF	172.27	173.1699	172.19	172.99	2909623.0
2019-02-27 12:00:00	QQQ	ETF	173.0	173.29	173.0	173.1	1315292.0
2019-02-27 13:00:00	QQQ	ETF	173.1	173.54	173.09	173.4499	2262270.0
2019-02-27 14:00:00	QQQ	ETF	173.44	173.8	173.35	173.5	1924101.0
2019-02-27 15:00:00	QQQ	ETF	173.5	173.7	173.25	173.57	4035518.0
2019-02-27 16:00:00	QQQ	ETF	173.56	173.66	173.43	173.61	936554.0
2019-02-27 17:00:00	QQQ	ETF	173.61	173.68	173.48	173.5	217593.0
2019-02-27 18:00:00	QQQ	ETF	173.42	173.54	173.42	173.46	33505.0
2019-02-27 19:00:00	QQQ	ETF	173.47	173.47	173.2	173.24	53370.0
2019-02-27 04:00:00	IWM	ETF	156.32	156.38	156.32	156.38	6950.0
2019-02-27 05:00:00	IWM	ETF	156.41	157.1	156.41	156.53	29200.0
2019-02-27 06:00:00	IWM	ETF	156.54	156.54	156.45	156.5	5800.0
2019-02-27 07:00:00	IWM	ETF	156.54	156.63	156.51	156.55	61390.0
2019-02-27 08:00:00	IWM	ETF	156.5	156.82	156.5	156.56	60874.0
2019-02-27 09:00:00	IWM	ETF	156.55	157.14	156.45	156.74	2722413.0
2019-02-27 10:00:00	IWM	ETF	156.74	156.89	156.12	156.34	4342598.0
2019-02-27 11:00:00	IWM	ETF	156.35	157.01	156.23	156.94	1781827.0
2019-02-27 12:00:00	IWM	ETF	156.94	157.17	156.84	157.015	896191.0
2019-02-27 13:00:00	IWM	ETF	157.01	157.37	156.99	157.2706	1025556.0
2019-02-27 14:00:00	IWM	ETF	157.27	157.41	157.205	157.38	1161058.0
2019-02-27 15:00:00	IWM	ETF	157.38	157.44	156.97	157.33	3226021.0
2019-02-27 16:00:00	IWM	ETF	157.3256	157.53	157.32	157.5	981213.0
2019-02-27 17:00:00	IWM	ETF	157.51	157.51	157.37	157.45	3071.0
2019-02-27 18:00:00	IWM	ETF	157.36	157.37	157.32	157.37	9896.0
2019-02-27 19:00:00	IWM	ETF	157.32	157.32	157.19	157.21	17600.0
2019-02-27 04:00:00	DIA	ETF	259.43	259.5	259.43	259.5	700.0
2019-02-27 05:00:00	DIA	ETF	259.51	259.64	259.51	259.64	1500.0

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

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