PREVIEW / etf_1hour / 2016-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-11.parquet
  size:    266 KB
  rows:    8,524

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
2016-02-11 04:00:00	SPY	ETF	182.41	182.79	181.5	182.03	206887.0
2016-02-11 05:00:00	SPY	ETF	181.98	182.27	181.57	182.06	102414.0
2016-02-11 06:00:00	SPY	ETF	182.2	182.25	181.3	181.33	513521.0
2016-02-11 07:00:00	SPY	ETF	181.31	182.44	180.91	181.75	1522607.0
2016-02-11 08:00:00	SPY	ETF	181.79	182.57	181.22	182.1	2211735.0
2016-02-11 09:00:00	SPY	ETF	182.1	183.95	182.01	183.51	23526943.0
2016-02-11 10:00:00	SPY	ETF	183.51	183.86	182.13	182.2689	24770038.0
2016-02-11 11:00:00	SPY	ETF	182.25	182.57	181.39	182.135	30707226.0
2016-02-11 12:00:00	SPY	ETF	182.135	182.62	181.66	182.495	16737710.0
2016-02-11 13:00:00	SPY	ETF	182.51	182.87	181.79	182.0	19746050.0
2016-02-11 14:00:00	SPY	ETF	181.995	183.86	181.09	183.1611	43121275.0
2016-02-11 15:00:00	SPY	ETF	183.16	184.1	182.29	183.06	40444012.0
2016-02-11 16:00:00	SPY	ETF	183.05	183.379	182.64	183.16	14233030.0
2016-02-11 17:00:00	SPY	ETF	183.22	183.35	183.13	183.35	134957.0
2016-02-11 18:00:00	SPY	ETF	183.35	183.66	183.35	183.65	341129.0
2016-02-11 19:00:00	SPY	ETF	183.6	183.79	183.28	183.67	144313.0
2016-02-11 20:00:00	SPY	ETF	183.0518	183.0518	183.0518	183.0518	90884.0
2016-02-11 04:00:00	QQQ	ETF	95.25	95.25	94.68	94.9	23155.0
2016-02-11 05:00:00	QQQ	ETF	94.88	94.97	94.68	94.94	6800.0
2016-02-11 06:00:00	QQQ	ETF	94.97	95.15	94.58	94.58	82500.0
2016-02-11 07:00:00	QQQ	ETF	94.5	95.23	94.5	94.9	169346.0
2016-02-11 08:00:00	QQQ	ETF	94.95	95.56	94.47	95.29	469808.0
2016-02-11 09:00:00	QQQ	ETF	95.31	96.62	95.21	96.4	9643373.0
2016-02-11 10:00:00	QQQ	ETF	96.37	96.58	95.64	95.7	8249829.0
2016-02-11 11:00:00	QQQ	ETF	95.7	95.96	95.19	95.8	7574929.0
2016-02-11 12:00:00	QQQ	ETF	95.8	96.275	95.52	96.2	4748208.0
2016-02-11 13:00:00	QQQ	ETF	96.2	96.41	95.67	95.81	5408653.0
2016-02-11 14:00:00	QQQ	ETF	95.801	96.9	95.28	96.59	13426523.0
2016-02-11 15:00:00	QQQ	ETF	96.6	97.32	96.21	96.61	15513711.0
2016-02-11 16:00:00	QQQ	ETF	96.6	96.83	96.52	96.78	1812744.0
2016-02-11 17:00:00	QQQ	ETF	96.78	96.79	96.68	96.7	15438.0
2016-02-11 18:00:00	QQQ	ETF	96.79	96.99	96.79	96.99	54490.0
2016-02-11 19:00:00	QQQ	ETF	96.99	97.04	96.8	97.0	11534.0
2016-02-11 04:00:00	IWM	ETF	94.17	94.17	93.7	93.7	8953.0
2016-02-11 05:00:00	IWM	ETF	93.88	94.12	93.68	94.0	8700.0
2016-02-11 06:00:00	IWM	ETF	93.98	94.21	93.37	93.54	73812.0
2016-02-11 07:00:00	IWM	ETF	93.46	94.33	93.42	93.82	286246.0
2016-02-11 08:00:00	IWM	ETF	93.88	94.11	93.74	93.82	470795.0
2016-02-11 09:00:00	IWM	ETF	93.82	95.08	93.82	94.905	6424222.0
2016-02-11 10:00:00	IWM	ETF	94.905	95.16	94.16	94.25	7459560.0
2016-02-11 11:00:00	IWM	ETF	94.24	94.44	93.64	93.99	5786960.0
2016-02-11 12:00:00	IWM	ETF	93.98	94.97	93.86	94.84	5082368.0
2016-02-11 13:00:00	IWM	ETF	94.84	95.04	94.18	94.33	5143135.0
2016-02-11 14:00:00	IWM	ETF	94.32	95.39	93.85	95.1492	10304843.0
2016-02-11 15:00:00	IWM	ETF	95.13	95.4	94.5171	94.8	10065161.0
2016-02-11 16:00:00	IWM	ETF	94.81	94.86	94.65	94.79	1855642.0
2016-02-11 17:00:00	IWM	ETF	94.79	94.85	94.79	94.85	72390.0
2016-02-11 18:00:00	IWM	ETF	94.88	95.16	94.87	95.07	12757.0
2016-02-11 19:00:00	IWM	ETF	95.15	95.15	95.03	95.05	3800.0
2016-02-11 20:00:00	IWM	ETF	94.8138	94.8138	94.8138	94.8138	200000.0

> showing 50 of 8,524 rows — these rows as CSV

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