PREVIEW / etf_1hour / 2017-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-13.parquet
  size:    289 KB
  rows:    9,512

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-13 04:00:00	SPY	ETF	266.57	266.72	266.57	266.72	483.0
2017-12-13 05:00:00	SPY	ETF	266.73	266.73	266.73	266.73	101.0
2017-12-13 06:00:00	SPY	ETF	266.9	266.92	266.82	266.9	6004.0
2017-12-13 07:00:00	SPY	ETF	266.75	266.77	266.55	266.64	166918.0
2017-12-13 08:00:00	SPY	ETF	266.72	267.1	266.62	267.01	572997.0
2017-12-13 09:00:00	SPY	ETF	267.04	267.47	266.99	267.39	14922318.0
2017-12-13 10:00:00	SPY	ETF	267.3999	267.51	267.2	267.43	8703089.0
2017-12-13 11:00:00	SPY	ETF	267.44	267.56	267.32	267.495	9128132.0
2017-12-13 12:00:00	SPY	ETF	267.49	267.495	266.96	267.09	7004376.0
2017-12-13 13:00:00	SPY	ETF	267.08	267.2134	266.79	266.97	7532035.0
2017-12-13 14:00:00	SPY	ETF	266.97	267.54	266.97	267.48	13448110.0
2017-12-13 15:00:00	SPY	ETF	267.485	267.49	266.65	266.73	21302801.0
2017-12-13 16:00:00	SPY	ETF	266.75	267.2	266.6205	266.94	17736945.0
2017-12-13 17:00:00	SPY	ETF	266.93	266.97	266.89	266.92	87172.0
2017-12-13 18:00:00	SPY	ETF	266.92	266.99	266.86	266.97	27611.0
2017-12-13 19:00:00	SPY	ETF	266.98	267.21	266.97	267.21	40982.0
2017-12-13 04:00:00	QQQ	ETF	155.83	155.84	155.8	155.83	5287.0
2017-12-13 05:00:00	QQQ	ETF	155.81	155.86	155.81	155.86	1099.0
2017-12-13 06:00:00	QQQ	ETF	155.88	155.89	155.8	155.8	8899.0
2017-12-13 07:00:00	QQQ	ETF	155.82	155.83	155.65	155.67	12620.0
2017-12-13 08:00:00	QQQ	ETF	155.64	156.25	155.64	156.16	117928.0
2017-12-13 09:00:00	QQQ	ETF	156.18	156.49	156.17	156.33	2564765.0
2017-12-13 10:00:00	QQQ	ETF	156.33	156.37	156.03	156.37	3070699.0
2017-12-13 11:00:00	QQQ	ETF	156.365	156.47	156.1301	156.1764	1418367.0
2017-12-13 12:00:00	QQQ	ETF	156.17	156.17	155.77	156.0144	1935870.0
2017-12-13 13:00:00	QQQ	ETF	156.01	156.046	155.76	155.87	1435245.0
2017-12-13 14:00:00	QQQ	ETF	155.87	156.4	155.87	156.345	3058614.0
2017-12-13 15:00:00	QQQ	ETF	156.345	156.39	155.9	155.99	5203746.0
2017-12-13 16:00:00	QQQ	ETF	155.98	156.46	155.9	156.02	930923.0
2017-12-13 17:00:00	QQQ	ETF	156.07	156.15	155.95	155.95	3672.0
2017-12-13 18:00:00	QQQ	ETF	156.0	156.09	156.0	156.03	13448.0
2017-12-13 19:00:00	QQQ	ETF	156.11	156.25	156.11	156.24	12500.0
2017-12-13 04:00:00	IWM	ETF	150.77	150.77	150.71	150.72	4447.0
2017-12-13 05:00:00	IWM	ETF	150.72	150.87	150.68	150.87	3270.0
2017-12-13 06:00:00	IWM	ETF	150.88	150.88	150.86	150.87	6200.0
2017-12-13 07:00:00	IWM	ETF	150.82	150.89	150.8	150.82	38005.0
2017-12-13 08:00:00	IWM	ETF	150.69	151.02	150.64	150.73	128599.0
2017-12-13 09:00:00	IWM	ETF	150.75	152.21	150.67	152.13	2421362.0
2017-12-13 10:00:00	IWM	ETF	152.13	152.21	151.8	151.925	3020279.0
2017-12-13 11:00:00	IWM	ETF	151.92	152.67	151.77	152.67	3197622.0
2017-12-13 12:00:00	IWM	ETF	152.665	152.71	151.8	151.9	2986340.0
2017-12-13 13:00:00	IWM	ETF	151.9	152.03	151.66	151.95	1478963.0
2017-12-13 14:00:00	IWM	ETF	152.0	152.28	151.88	152.13	2433335.0
2017-12-13 15:00:00	IWM	ETF	152.1301	152.14	151.6299	151.77	3837820.0
2017-12-13 16:00:00	IWM	ETF	151.79	152.1	151.7424	151.84	2359840.0
2017-12-13 17:00:00	IWM	ETF	151.94	151.94	151.88	151.88	642.0
2017-12-13 18:00:00	IWM	ETF	151.82	151.85	151.79	151.85	8400.0
2017-12-13 19:00:00	IWM	ETF	151.94	152.02	151.94	152.02	5000.0
2017-12-13 07:00:00	DIA	ETF	245.6	245.61	245.5	245.5	4655.0
2017-12-13 08:00:00	DIA	ETF	245.65	245.77	245.6	245.77	800.0

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

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