PREVIEW / etf_1hour / 2017-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-01.parquet
  size:    300 KB
  rows:    9,853

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
2017-12-01 04:00:00	SPY	ETF	264.11	264.35	264.05	264.35	39313.0
2017-12-01 05:00:00	SPY	ETF	264.43	264.43	263.34	263.58	24303.0
2017-12-01 06:00:00	SPY	ETF	263.48	264.07	263.48	263.77	139376.0
2017-12-01 07:00:00	SPY	ETF	263.86	264.25	263.8	264.18	539758.0
2017-12-01 08:00:00	SPY	ETF	264.0	264.92	263.82	264.66	1796643.0
2017-12-01 09:00:00	SPY	ETF	264.68	265.09	264.5	264.77	8334912.0
2017-12-01 10:00:00	SPY	ETF	264.76	265.31	264.53	265.14	11151938.0
2017-12-01 11:00:00	SPY	ETF	265.15	265.18	260.76	263.2	53768404.0
2017-12-01 12:00:00	SPY	ETF	263.21	263.78	262.81	263.73	24990232.0
2017-12-01 13:00:00	SPY	ETF	263.71	264.25	263.52	263.98	12005073.0
2017-12-01 14:00:00	SPY	ETF	263.99	264.18	263.67	263.865	8281460.0
2017-12-01 15:00:00	SPY	ETF	263.86	264.54	263.58	264.44	25406171.0
2017-12-01 16:00:00	SPY	ETF	264.44	264.74	264.38	264.52	14308127.0
2017-12-01 17:00:00	SPY	ETF	264.51	264.92	264.25	264.3	2123110.0
2017-12-01 18:00:00	SPY	ETF	264.28	264.47	264.1	264.37	234899.0
2017-12-01 19:00:00	SPY	ETF	264.38	264.4	264.3	264.38	12561.0
2017-12-01 04:00:00	QQQ	ETF	154.54	154.63	154.41	154.62	49495.0
2017-12-01 05:00:00	QQQ	ETF	154.58	154.6	153.81	153.94	45358.0
2017-12-01 06:00:00	QQQ	ETF	153.85	154.26	153.85	154.1	22744.0
2017-12-01 07:00:00	QQQ	ETF	154.16	154.36	154.05	154.31	89810.0
2017-12-01 08:00:00	QQQ	ETF	154.13	154.75	154.13	154.5	179283.0
2017-12-01 09:00:00	QQQ	ETF	154.49	154.91	154.1	154.52	5027810.0
2017-12-01 10:00:00	QQQ	ETF	154.525	155.24	154.44	154.99	4850504.0
2017-12-01 11:00:00	QQQ	ETF	154.99	155.11	152.26	153.68	19301280.0
2017-12-01 12:00:00	QQQ	ETF	153.68	154.175	153.24	154.13	7167454.0
2017-12-01 13:00:00	QQQ	ETF	154.13	154.44	153.91	154.18	2449438.0
2017-12-01 14:00:00	QQQ	ETF	154.19	154.47	154.01	154.1646	2517001.0
2017-12-01 15:00:00	QQQ	ETF	154.16	154.63	153.96	154.51	5694046.0
2017-12-01 16:00:00	QQQ	ETF	154.515	154.71	154.49	154.53	3621487.0
2017-12-01 17:00:00	QQQ	ETF	154.7	154.78	154.44	154.45	42432.0
2017-12-01 18:00:00	QQQ	ETF	154.45	154.55	154.26	154.55	7114.0
2017-12-01 19:00:00	QQQ	ETF	154.5	154.58	154.49	154.51	5245.0
2017-12-01 04:00:00	IWM	ETF	153.1	153.1	152.99	153.02	25290.0
2017-12-01 05:00:00	IWM	ETF	153.1	153.1	152.43	152.57	45031.0
2017-12-01 06:00:00	IWM	ETF	152.58	152.96	152.55	152.82	57700.0
2017-12-01 07:00:00	IWM	ETF	152.86	153.03	152.61	152.8	123826.0
2017-12-01 08:00:00	IWM	ETF	152.8	153.54	152.78	153.53	195953.0
2017-12-01 09:00:00	IWM	ETF	153.51	153.76	152.87	152.97	2209370.0
2017-12-01 10:00:00	IWM	ETF	152.94	153.71	152.64	153.15	4048845.0
2017-12-01 11:00:00	IWM	ETF	153.17	153.18	148.75	151.08	19416945.0
2017-12-01 12:00:00	IWM	ETF	151.08	152.08	150.83	152.04	8120450.0
2017-12-01 13:00:00	IWM	ETF	152.01	152.83	151.48	152.45	4539548.0
2017-12-01 14:00:00	IWM	ETF	152.46	152.59	151.8937	152.1	2522294.0
2017-12-01 15:00:00	IWM	ETF	152.1	153.02	151.95	152.97	7180403.0
2017-12-01 16:00:00	IWM	ETF	152.97	153.09	151.798	152.98	6566913.0
2017-12-01 17:00:00	IWM	ETF	153.03	153.14	152.86	152.86	29794.0
2017-12-01 18:00:00	IWM	ETF	152.77	152.88	152.77	152.86	2855.0
2017-12-01 19:00:00	IWM	ETF	152.86	152.95	152.86	152.95	700.0
2017-12-01 04:00:00	DIA	ETF	242.11	242.7	242.11	242.7	391.0
2017-12-01 05:00:00	DIA	ETF	242.16	242.16	241.93	241.93	400.0

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

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