PREVIEW / etf_1hour / 2015-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-24.parquet
  size:    243 KB
  rows:    7,708

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
2015-07-24 04:00:00	SPY	ETF	210.74	210.97	210.74	210.94	3271.0
2015-07-24 05:00:00	SPY	ETF	210.88	210.93	210.75	210.85	9292.0
2015-07-24 06:00:00	SPY	ETF	210.95	210.95	210.77	210.77	3565.0
2015-07-24 07:00:00	SPY	ETF	210.81	210.86	210.53	210.56	98434.0
2015-07-24 08:00:00	SPY	ETF	210.59	210.83	210.2	210.25	472556.0
2015-07-24 09:00:00	SPY	ETF	210.26	210.37	209.73	210.109	9932478.0
2015-07-24 10:00:00	SPY	ETF	210.1	210.135	209.21	209.2199	12107426.0
2015-07-24 11:00:00	SPY	ETF	209.22	209.48	209.14	209.25	10154980.0
2015-07-24 12:00:00	SPY	ETF	209.246	209.265	208.64	208.66	9287475.0
2015-07-24 13:00:00	SPY	ETF	208.66	208.82	207.96	208.31	17788628.0
2015-07-24 14:00:00	SPY	ETF	208.3101	210.1253	207.6	207.92	15295630.0
2015-07-24 15:00:00	SPY	ETF	207.92	208.235	207.7	207.98	23991650.0
2015-07-24 16:00:00	SPY	ETF	207.97	208.52	207.8904	208.477	12630124.0
2015-07-24 17:00:00	SPY	ETF	208.47	208.71	208.42	208.48	278046.0
2015-07-24 18:00:00	SPY	ETF	208.5	208.54	208.48	208.48	83195.0
2015-07-24 19:00:00	SPY	ETF	208.49	208.5	208.42	208.47	39075.0
2015-07-24 04:00:00	QQQ	ETF	113.02	113.25	113.01	113.16	5600.0
2015-07-24 05:00:00	QQQ	ETF	113.14	113.25	113.14	113.25	400.0
2015-07-24 06:00:00	QQQ	ETF	113.13	113.2	113.11	113.11	10100.0
2015-07-24 07:00:00	QQQ	ETF	113.12	113.14	112.9	112.9	157359.0
2015-07-24 08:00:00	QQQ	ETF	113.28	113.28	112.8	112.82	236178.0
2015-07-24 09:00:00	QQQ	ETF	112.83	112.88	112.3	112.57	3706533.0
2015-07-24 10:00:00	QQQ	ETF	112.57	112.66	112.055	112.15	3131064.0
2015-07-24 11:00:00	QQQ	ETF	112.15	112.33	112.04	112.1459	1751241.0
2015-07-24 12:00:00	QQQ	ETF	112.15	112.16	111.72	111.735	2255433.0
2015-07-24 13:00:00	QQQ	ETF	111.72	111.82	111.24	111.55	3783333.0
2015-07-24 14:00:00	QQQ	ETF	111.54	111.58	110.96	111.15	3305157.0
2015-07-24 15:00:00	QQQ	ETF	111.14	111.31	110.93	111.11	7497444.0
2015-07-24 16:00:00	QQQ	ETF	111.1	111.39	111.08	111.37	2122972.0
2015-07-24 17:00:00	QQQ	ETF	111.36	111.42	111.33	111.33	22597.0
2015-07-24 18:00:00	QQQ	ETF	111.33	111.35	111.3	111.34	13613.0
2015-07-24 19:00:00	QQQ	ETF	111.35	111.36	111.27	111.27	4125.0
2015-07-24 07:00:00	IWM	ETF	123.92	123.92	123.6	123.6	30000.0
2015-07-24 08:00:00	IWM	ETF	123.68	123.72	123.45	123.45	38046.0
2015-07-24 09:00:00	IWM	ETF	123.5	123.71	122.94	123.34	3611635.0
2015-07-24 10:00:00	IWM	ETF	123.34	123.43	122.69	122.75	4789861.0
2015-07-24 11:00:00	IWM	ETF	122.76	122.99	122.63	122.755	2906141.0
2015-07-24 12:00:00	IWM	ETF	122.755	122.78	122.41	122.4436	2295297.0
2015-07-24 13:00:00	IWM	ETF	122.44	122.5	121.63	121.95	6199634.0
2015-07-24 14:00:00	IWM	ETF	121.955	121.96	121.49	121.8	4316283.0
2015-07-24 15:00:00	IWM	ETF	121.8	121.99	121.54	121.61	7131530.0
2015-07-24 16:00:00	IWM	ETF	121.6	121.87	121.55	121.87	2510443.0
2015-07-24 19:00:00	IWM	ETF	121.65	121.65	121.65	121.65	1000.0
2015-07-24 04:00:00	DIA	ETF	177.57	177.57	177.57	177.57	700.0
2015-07-24 05:00:00	DIA	ETF	177.57	177.57	177.57	177.57	100.0
2015-07-24 07:00:00	DIA	ETF	177.52	177.52	177.45	177.45	5780.0
2015-07-24 08:00:00	DIA	ETF	177.47	177.5	177.02	177.05	18424.0
2015-07-24 09:00:00	DIA	ETF	177.01	177.26	176.82	177.13	468675.0
2015-07-24 10:00:00	DIA	ETF	177.14	177.21	176.31	176.31	586910.0
2015-07-24 11:00:00	DIA	ETF	176.31	176.49	176.17	176.27	584145.0

> showing 50 of 7,708 rows — these rows as CSV

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