PREVIEW / etf_1hour / 2018-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-30.parquet
  size:    317 KB
  rows:    10,534

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-30 04:00:00	SPY	ETF	265.22	265.78	264.98	265.18	60899.0
2018-10-30 05:00:00	SPY	ETF	265.02	265.02	263.93	264.73	94384.0
2018-10-30 06:00:00	SPY	ETF	264.85	265.22	264.59	264.65	28469.0
2018-10-30 07:00:00	SPY	ETF	264.74	265.2	264.38	265.05	354134.0
2018-10-30 08:00:00	SPY	ETF	264.83	266.0	264.2	264.26	1109310.0
2018-10-30 09:00:00	SPY	ETF	264.24	267.02	262.86	266.68	18238638.0
2018-10-30 10:00:00	SPY	ETF	266.7	266.92	264.18	264.59	22721314.0
2018-10-30 11:00:00	SPY	ETF	264.6	266.88	264.09	265.57	18041929.0
2018-10-30 12:00:00	SPY	ETF	265.58	266.31	264.66	264.69	12056095.0
2018-10-30 13:00:00	SPY	ETF	264.69	265.46	263.58	265.32	13818809.0
2018-10-30 14:00:00	SPY	ETF	265.34	266.61	264.12	266.29	16883366.0
2018-10-30 15:00:00	SPY	ETF	266.28	268.12	265.44	267.81	37314051.0
2018-10-30 16:00:00	SPY	ETF	267.82	268.51	263.6858	268.39	12897027.0
2018-10-30 17:00:00	SPY	ETF	268.37	268.46	267.58	268.41	813408.0
2018-10-30 18:00:00	SPY	ETF	268.46	268.6	268.07	268.17	286610.0
2018-10-30 19:00:00	SPY	ETF	268.08	268.39	268.05	268.21	99679.0
2018-10-30 04:00:00	QQQ	ETF	164.88	165.14	164.63	164.73	32329.0
2018-10-30 05:00:00	QQQ	ETF	164.75	164.75	163.46	164.38	73955.0
2018-10-30 06:00:00	QQQ	ETF	164.25	164.56	164.04	164.27	54183.0
2018-10-30 07:00:00	QQQ	ETF	164.22	164.68	163.83	164.5	174451.0
2018-10-30 08:00:00	QQQ	ETF	164.18	165.28	163.49	163.55	828298.0
2018-10-30 09:00:00	QQQ	ETF	163.55	165.52	162.015	165.13	16753839.0
2018-10-30 10:00:00	QQQ	ETF	165.14	165.279	162.87	163.46	16488955.0
2018-10-30 11:00:00	QQQ	ETF	163.47	165.7	163.11	164.66	11123282.0
2018-10-30 12:00:00	QQQ	ETF	164.66	165.21	163.79	163.84	6831545.0
2018-10-30 13:00:00	QQQ	ETF	163.85	164.14	162.42	164.05	8340893.0
2018-10-30 14:00:00	QQQ	ETF	164.04	164.98	163.02	164.8	6992487.0
2018-10-30 15:00:00	QQQ	ETF	164.8	166.035	164.23	165.86	12923704.0
2018-10-30 16:00:00	QQQ	ETF	165.85	166.99	163.4	166.41	3841050.0
2018-10-30 17:00:00	QQQ	ETF	166.35	166.73	165.08	166.7	374350.0
2018-10-30 18:00:00	QQQ	ETF	166.89	166.99	165.92	166.19	626307.0
2018-10-30 19:00:00	QQQ	ETF	166.17	166.45	166.12	166.29	99078.0
2018-10-30 04:00:00	IWM	ETF	148.0	148.13	147.74	147.74	4000.0
2018-10-30 05:00:00	IWM	ETF	147.73	147.73	147.42	147.49	3750.0
2018-10-30 06:00:00	IWM	ETF	147.55	147.74	147.22	147.31	4404.0
2018-10-30 07:00:00	IWM	ETF	147.28	147.55	147.19	147.42	22640.0
2018-10-30 08:00:00	IWM	ETF	147.31	148.14	147.14	147.16	173549.0
2018-10-30 09:00:00	IWM	ETF	147.13	149.19	146.48	149.028	3751547.0
2018-10-30 10:00:00	IWM	ETF	149.02	149.23	147.31	147.95	5406960.0
2018-10-30 11:00:00	IWM	ETF	147.96	149.69	147.75	149.1	3646855.0
2018-10-30 12:00:00	IWM	ETF	149.12	149.46	148.59	148.66	2782036.0
2018-10-30 13:00:00	IWM	ETF	148.66	148.78	147.6	148.58	2289967.0
2018-10-30 14:00:00	IWM	ETF	148.58	149.2	148.05	149.06	2942186.0
2018-10-30 15:00:00	IWM	ETF	149.07	149.89	148.7	149.64	5188073.0
2018-10-30 16:00:00	IWM	ETF	149.65	150.32	149.64	150.27	936337.0
2018-10-30 17:00:00	IWM	ETF	150.09	150.36	149.91	149.95	4579.0
2018-10-30 18:00:00	IWM	ETF	150.22	150.22	149.73	150.07	17565.0
2018-10-30 19:00:00	IWM	ETF	150.03	150.18	149.96	150.08	10168.0
2018-10-30 04:00:00	DIA	ETF	245.42	245.56	245.26	245.26	1880.0
2018-10-30 06:00:00	DIA	ETF	245.44	245.44	245.44	245.44	200.0

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

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