PREVIEW / etf_1hour / 2018-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-06.parquet
  size:    348 KB
  rows:    11,333

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-06 04:00:00	SPY	ETF	263.5	264.98	261.51	261.71	350356.0
2018-02-06 05:00:00	SPY	ETF	261.82	262.27	259.71	261.93	779935.0
2018-02-06 06:00:00	SPY	ETF	261.94	262.17	257.6	258.0	484524.0
2018-02-06 07:00:00	SPY	ETF	258.0	261.38	256.98	260.1	1852090.0
2018-02-06 08:00:00	SPY	ETF	260.02	262.66	257.0	260.46	4411541.0
2018-02-06 09:00:00	SPY	ETF	260.44	267.78	257.67	265.79	53409056.0
2018-02-06 10:00:00	SPY	ETF	265.82	267.83	261.38	263.75	68001827.0
2018-02-06 11:00:00	SPY	ETF	263.77	264.2	261.57	263.19	38926089.0
2018-02-06 12:00:00	SPY	ETF	263.2	266.47	263.19	264.99	34099621.0
2018-02-06 13:00:00	SPY	ETF	265.01	265.17	262.64	262.845	30622284.0
2018-02-06 14:00:00	SPY	ETF	262.845	267.0	262.22	266.77	36761011.0
2018-02-06 15:00:00	SPY	ETF	266.76	269.7	266.7	269.18	56011632.0
2018-02-06 16:00:00	SPY	ETF	269.19	269.63	265.1012	268.04	24384560.0
2018-02-06 17:00:00	SPY	ETF	268.07	269.1301	259.5119	268.45	1360642.0
2018-02-06 18:00:00	SPY	ETF	268.45	269.43	267.84	268.5	650433.0
2018-02-06 19:00:00	SPY	ETF	268.49	269.3	265.1954	268.89	108630.0
2018-02-06 04:00:00	QQQ	ETF	158.27	158.96	157.43	157.6	135850.0
2018-02-06 05:00:00	QQQ	ETF	157.6	157.85	156.61	157.49	86446.0
2018-02-06 06:00:00	QQQ	ETF	157.21	157.5	154.83	155.2	239923.0
2018-02-06 07:00:00	QQQ	ETF	155.09	156.72	154.77	156.14	530022.0
2018-02-06 08:00:00	QQQ	ETF	156.18	157.9	154.76	156.8	1337226.0
2018-02-06 09:00:00	QQQ	ETF	156.8	160.66	155.1	159.35	18873191.0
2018-02-06 10:00:00	QQQ	ETF	159.3799	160.68	156.35	158.11	21002310.0
2018-02-06 11:00:00	QQQ	ETF	158.12	158.78	156.95	158.2	12878684.0
2018-02-06 12:00:00	QQQ	ETF	158.2	160.54	158.2	159.77	12118511.0
2018-02-06 13:00:00	QQQ	ETF	159.77	160.025	158.18	158.35	8151719.0
2018-02-06 14:00:00	QQQ	ETF	158.3534	160.89	157.84	160.73	10430030.0
2018-02-06 15:00:00	QQQ	ETF	160.73	162.51	153.63	162.31	15707337.0
2018-02-06 16:00:00	QQQ	ETF	162.31	162.53	158.5615	161.5	2839161.0
2018-02-06 17:00:00	QQQ	ETF	161.6	162.31	161.6	161.84	196233.0
2018-02-06 18:00:00	QQQ	ETF	161.84	162.45	161.3	161.6	140388.0
2018-02-06 19:00:00	QQQ	ETF	161.68	162.14	161.41	162.12	80591.0
2018-02-06 04:00:00	IWM	ETF	147.27	147.79	146.33	146.49	120522.0
2018-02-06 05:00:00	IWM	ETF	146.35	146.46	145.0	146.27	112993.0
2018-02-06 06:00:00	IWM	ETF	146.2	146.2	143.52	143.91	74459.0
2018-02-06 07:00:00	IWM	ETF	143.88	145.71	143.01	145.35	381748.0
2018-02-06 08:00:00	IWM	ETF	145.35	146.5	143.49	145.57	989912.0
2018-02-06 09:00:00	IWM	ETF	145.6	149.42	144.24	148.76	11351340.0
2018-02-06 10:00:00	IWM	ETF	148.76	149.77	146.82	147.5	10484880.0
2018-02-06 11:00:00	IWM	ETF	147.51	147.83	146.34	147.51	6840023.0
2018-02-06 12:00:00	IWM	ETF	147.505	149.1184	147.5	148.32	5568308.0
2018-02-06 13:00:00	IWM	ETF	148.32	148.33	147.36	147.44	3765623.0
2018-02-06 14:00:00	IWM	ETF	147.43	149.25	147.34	149.18	5602383.0
2018-02-06 15:00:00	IWM	ETF	149.175	150.37	142.89	149.7	8852748.0
2018-02-06 16:00:00	IWM	ETF	149.68	150.07	149.21	149.41	1770577.0
2018-02-06 17:00:00	IWM	ETF	149.01	149.69	149.01	149.65	220511.0
2018-02-06 18:00:00	IWM	ETF	149.31	149.71	148.95	149.14	62817.0
2018-02-06 19:00:00	IWM	ETF	149.46	149.66	149.13	149.63	6936.0
2018-02-06 04:00:00	DIA	ETF	241.13	241.5	239.5	240.12	3561.0
2018-02-06 05:00:00	DIA	ETF	239.46	240.4	237.35	240.0	5550.0

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

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