PREVIEW / etf_1hour / 2018-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-27.parquet
  size:    305 KB
  rows:    10,000

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-09-27 04:00:00	SPY	ETF	289.63	289.77	289.56	289.63	23090.0
2018-09-27 05:00:00	SPY	ETF	289.66	289.92	289.56	289.82	9640.0
2018-09-27 06:00:00	SPY	ETF	290.0	290.3	290.0	290.15	39743.0
2018-09-27 07:00:00	SPY	ETF	290.15	290.18	290.01	290.01	85768.0
2018-09-27 08:00:00	SPY	ETF	290.08	290.37	289.5	290.32	390240.0
2018-09-27 09:00:00	SPY	ETF	290.34	290.78	290.1	290.6315	5057106.0
2018-09-27 10:00:00	SPY	ETF	290.63	291.51	290.62	291.41	7975233.0
2018-09-27 11:00:00	SPY	ETF	291.41	291.69	291.22	291.69	3795554.0
2018-09-27 12:00:00	SPY	ETF	291.68	291.91	291.5936	291.755	3655485.0
2018-09-27 13:00:00	SPY	ETF	291.76	291.76	291.37	291.43	4158538.0
2018-09-27 14:00:00	SPY	ETF	291.43	291.445	290.89	290.93	7801996.0
2018-09-27 15:00:00	SPY	ETF	290.93	291.08	290.41	290.65	16688415.0
2018-09-27 16:00:00	SPY	ETF	290.65	291.0397	290.49	290.88	8461105.0
2018-09-27 17:00:00	SPY	ETF	290.86	290.9	290.81	290.89	56164.0
2018-09-27 18:00:00	SPY	ETF	290.91	290.95	290.81	290.86	35966.0
2018-09-27 19:00:00	SPY	ETF	290.9	290.98	290.83	290.83	32882.0
2018-09-27 04:00:00	QQQ	ETF	184.27	184.32	184.2	184.29	9792.0
2018-09-27 05:00:00	QQQ	ETF	184.25	184.44	184.21	184.44	21672.0
2018-09-27 06:00:00	QQQ	ETF	184.44	184.74	184.44	184.63	34584.0
2018-09-27 07:00:00	QQQ	ETF	184.63	184.75	184.56	184.66	112299.0
2018-09-27 08:00:00	QQQ	ETF	184.6	184.89	184.07	184.84	207174.0
2018-09-27 09:00:00	QQQ	ETF	184.87	185.78	184.81	185.63	3698525.0
2018-09-27 10:00:00	QQQ	ETF	185.64	186.29	185.63	186.27	5609099.0
2018-09-27 11:00:00	QQQ	ETF	186.27	186.4499	185.9399	186.28	3344549.0
2018-09-27 12:00:00	QQQ	ETF	186.27	186.49	186.15	186.4	2246039.0
2018-09-27 13:00:00	QQQ	ETF	186.4	186.41	186.24	186.34	1578491.0
2018-09-27 14:00:00	QQQ	ETF	186.339	186.35	185.92	185.97	2425228.0
2018-09-27 15:00:00	QQQ	ETF	185.97	186.09	185.64	185.82	5678157.0
2018-09-27 16:00:00	QQQ	ETF	185.82	186.1944	185.63	185.92	1952057.0
2018-09-27 17:00:00	QQQ	ETF	185.84	185.92	185.84	185.88	2287.0
2018-09-27 18:00:00	QQQ	ETF	185.89	185.93	185.83	185.88	12642.0
2018-09-27 19:00:00	QQQ	ETF	185.86	185.99	185.86	185.9	26548.0
2018-09-27 06:00:00	IWM	ETF	168.0	168.23	168.0	168.23	2400.0
2018-09-27 07:00:00	IWM	ETF	168.11	168.18	168.11	168.16	12000.0
2018-09-27 08:00:00	IWM	ETF	168.18	168.38	168.15	168.29	13393.0
2018-09-27 09:00:00	IWM	ETF	168.31	168.53	167.76	168.24	2429475.0
2018-09-27 10:00:00	IWM	ETF	168.24	168.475	167.935	168.21	2722237.0
2018-09-27 11:00:00	IWM	ETF	168.22	168.66	167.95	168.61	1551505.0
2018-09-27 12:00:00	IWM	ETF	168.6	168.7	168.33	168.44	1042689.0
2018-09-27 13:00:00	IWM	ETF	168.43	168.53	168.2	168.32	749346.0
2018-09-27 14:00:00	IWM	ETF	168.32	168.33	168.09	168.115	790474.0
2018-09-27 15:00:00	IWM	ETF	168.1	168.22	167.86	167.98	2465163.0
2018-09-27 16:00:00	IWM	ETF	167.99	168.22	167.887	168.19	1125286.0
2018-09-27 18:00:00	IWM	ETF	168.19	168.21	168.14	168.14	4300.0
2018-09-27 19:00:00	IWM	ETF	168.18	168.2	168.18	168.2	1500.0
2018-09-27 06:00:00	DIA	ETF	263.92	264.02	263.92	264.02	200.0
2018-09-27 07:00:00	DIA	ETF	263.82	263.82	263.82	263.82	100.0
2018-09-27 08:00:00	DIA	ETF	263.88	264.22	263.8	264.18	3632.0
2018-09-27 09:00:00	DIA	ETF	264.18	264.38	263.59	264.0	361507.0
2018-09-27 10:00:00	DIA	ETF	263.99	264.89	263.98	264.62	423746.0

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

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