PREVIEW / etf_1hour / 2018-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-19.parquet
  size:    296 KB
  rows:    9,633

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-04-19 04:00:00	SPY	ETF	270.41	270.41	269.94	269.94	11465.0
2018-04-19 05:00:00	SPY	ETF	270.0	270.28	270.0	270.23	3700.0
2018-04-19 06:00:00	SPY	ETF	270.2	270.24	269.98	270.03	17720.0
2018-04-19 07:00:00	SPY	ETF	270.08	270.33	270.03	270.21	53727.0
2018-04-19 08:00:00	SPY	ETF	270.22	270.81	269.56	269.6	729767.0
2018-04-19 09:00:00	SPY	ETF	269.56	270.4982	268.81	269.35	6839123.0
2018-04-19 10:00:00	SPY	ETF	269.37	269.88	268.76	269.125	9458380.0
2018-04-19 11:00:00	SPY	ETF	269.12	269.179	268.27	268.28	6402279.0
2018-04-19 12:00:00	SPY	ETF	268.27	268.57	267.99	268.11	6499708.0
2018-04-19 13:00:00	SPY	ETF	268.11	268.51	267.72	268.3	8213403.0
2018-04-19 14:00:00	SPY	ETF	268.29	268.56	267.84	268.5	6628593.0
2018-04-19 15:00:00	SPY	ETF	268.49	269.47	268.21	268.86	20890874.0
2018-04-19 16:00:00	SPY	ETF	268.86	268.98	268.68	268.91	7950239.0
2018-04-19 17:00:00	SPY	ETF	268.88	268.99	268.81	268.81	128930.0
2018-04-19 18:00:00	SPY	ETF	268.85	269.0	268.8	268.85	27592.0
2018-04-19 19:00:00	SPY	ETF	268.85	268.88	268.35	268.86	29035.0
2018-04-19 04:00:00	QQQ	ETF	166.51	166.6	166.27	166.27	16160.0
2018-04-19 05:00:00	QQQ	ETF	166.33	166.46	166.33	166.43	44120.0
2018-04-19 06:00:00	QQQ	ETF	166.36	166.36	166.03	166.09	159905.0
2018-04-19 07:00:00	QQQ	ETF	166.1	166.28	166.06	166.25	84730.0
2018-04-19 08:00:00	QQQ	ETF	166.14	166.26	165.68	165.68	289327.0
2018-04-19 09:00:00	QQQ	ETF	165.68	165.8	165.1	165.68	2998070.0
2018-04-19 10:00:00	QQQ	ETF	165.68	165.99	165.02	165.26	4453191.0
2018-04-19 11:00:00	QQQ	ETF	165.27	165.305	164.54	164.56	4428356.0
2018-04-19 12:00:00	QQQ	ETF	164.53	164.969	164.36	164.635	3368307.0
2018-04-19 13:00:00	QQQ	ETF	164.62	164.96	164.38	164.8	3329075.0
2018-04-19 14:00:00	QQQ	ETF	164.8	164.9499	164.34	164.82	2726220.0
2018-04-19 15:00:00	QQQ	ETF	164.82	165.44	164.68	164.97	6472966.0
2018-04-19 16:00:00	QQQ	ETF	164.97	165.0	164.7421	164.91	1157240.0
2018-04-19 17:00:00	QQQ	ETF	164.86	164.92	164.82	164.83	5371.0
2018-04-19 18:00:00	QQQ	ETF	164.9	165.0	164.8	164.91	240717.0
2018-04-19 19:00:00	QQQ	ETF	164.91	164.91	164.54	164.86	50883.0
2018-04-19 04:00:00	IWM	ETF	157.45	157.45	157.42	157.42	365.0
2018-04-19 05:00:00	IWM	ETF	157.45	157.48	157.45	157.47	7306.0
2018-04-19 06:00:00	IWM	ETF	157.48	157.48	157.22	157.29	5200.0
2018-04-19 07:00:00	IWM	ETF	157.32	157.5	157.31	157.43	4452.0
2018-04-19 08:00:00	IWM	ETF	157.47	157.47	157.08	157.08	27132.0
2018-04-19 09:00:00	IWM	ETF	157.02	157.52	156.77	157.04	1565012.0
2018-04-19 10:00:00	IWM	ETF	157.05	157.54	156.61	156.8	2430280.0
2018-04-19 11:00:00	IWM	ETF	156.8	156.93	156.41	156.66	2696240.0
2018-04-19 12:00:00	IWM	ETF	156.65	156.66	156.33	156.36	1094102.0
2018-04-19 13:00:00	IWM	ETF	156.34	156.4	155.88	156.29	2015036.0
2018-04-19 14:00:00	IWM	ETF	156.29	156.62	156.22	156.55	1281442.0
2018-04-19 15:00:00	IWM	ETF	156.54	156.88	156.24	156.41	2951368.0
2018-04-19 16:00:00	IWM	ETF	156.39	156.45	156.24	156.35	777247.0
2018-04-19 17:00:00	IWM	ETF	156.39	156.44	156.32	156.37	12947.0
2018-04-19 18:00:00	IWM	ETF	156.35	156.51	156.34	156.39	61412.0
2018-04-19 19:00:00	IWM	ETF	156.3	156.39	156.16	156.39	7537.0
2018-04-19 06:00:00	DIA	ETF	247.47	247.47	247.31	247.34	2185.0
2018-04-19 07:00:00	DIA	ETF	247.32	247.49	247.32	247.49	534.0

> showing 50 of 9,633 rows — these rows as CSV

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