PREVIEW / etf_1hour / 2015-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-27.parquet
  size:    231 KB
  rows:    7,359

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-03-27 04:00:00	SPY	ETF	205.44	205.64	205.17	205.24	41050.0
2015-03-27 05:00:00	SPY	ETF	205.2	205.29	204.6	204.72	41434.0
2015-03-27 06:00:00	SPY	ETF	204.84	205.1	204.84	204.99	25629.0
2015-03-27 07:00:00	SPY	ETF	204.99	205.36	204.99	205.18	270730.0
2015-03-27 08:00:00	SPY	ETF	204.61	205.33	204.61	205.16	584866.0
2015-03-27 09:00:00	SPY	ETF	205.15	205.66	204.88	205.59	17071314.0
2015-03-27 10:00:00	SPY	ETF	205.58	205.92	204.9	205.88	20775726.0
2015-03-27 11:00:00	SPY	ETF	205.8849	205.95	205.27	205.57	10479545.0
2015-03-27 12:00:00	SPY	ETF	205.58	205.65	205.25	205.61	9401384.0
2015-03-27 13:00:00	SPY	ETF	205.62	205.66	205.305	205.55	6237230.0
2015-03-27 14:00:00	SPY	ETF	205.545	205.67	205.37	205.53	8229079.0
2015-03-27 15:00:00	SPY	ETF	205.52	205.95	205.375	205.72	28233236.0
2015-03-27 16:00:00	SPY	ETF	205.71	205.79	205.54	205.68	13320168.0
2015-03-27 17:00:00	SPY	ETF	205.74	205.78	205.7	205.751	1759980.0
2015-03-27 18:00:00	SPY	ETF	205.79	206.87	205.79	205.8	121748.0
2015-03-27 19:00:00	SPY	ETF	205.8	205.85	205.77	205.85	25291.0
2015-03-27 04:00:00	QQQ	ETF	105.25	105.26	105.25	105.26	10100.0
2015-03-27 05:00:00	QQQ	ETF	105.01	105.01	104.78	104.78	1750.0
2015-03-27 06:00:00	QQQ	ETF	105.22	105.22	104.97	105.12	23658.0
2015-03-27 07:00:00	QQQ	ETF	105.13	105.25	105.12	105.2	25702.0
2015-03-27 08:00:00	QQQ	ETF	105.19	105.51	105.02	105.08	74199.0
2015-03-27 09:00:00	QQQ	ETF	105.07	105.56	104.95	105.42	4511591.0
2015-03-27 10:00:00	QQQ	ETF	105.42	105.61	104.92	105.53	4805993.0
2015-03-27 11:00:00	QQQ	ETF	105.535	105.61	105.15	105.27	1850807.0
2015-03-27 12:00:00	QQQ	ETF	105.28	105.32	105.0935	105.29	1742234.0
2015-03-27 13:00:00	QQQ	ETF	105.3	105.34	105.13	105.266	1462780.0
2015-03-27 14:00:00	QQQ	ETF	105.26	105.32	105.15	105.26	1415007.0
2015-03-27 15:00:00	QQQ	ETF	105.251	105.77	105.2	105.52	12313860.0
2015-03-27 16:00:00	QQQ	ETF	105.52	105.6	105.0939	105.52	2112113.0
2015-03-27 17:00:00	QQQ	ETF	105.56	105.57	105.5	105.52	62357.0
2015-03-27 18:00:00	QQQ	ETF	105.52	105.55	105.5	105.5	3935.0
2015-03-27 19:00:00	QQQ	ETF	105.5	105.51	105.43	105.46	2083.0
2015-03-27 04:00:00	IWM	ETF	122.22	122.22	122.22	122.22	200.0
2015-03-27 05:00:00	IWM	ETF	122.18	122.18	121.69	121.69	2900.0
2015-03-27 06:00:00	IWM	ETF	122.05	122.05	122.05	122.05	100.0
2015-03-27 07:00:00	IWM	ETF	122.23	122.23	122.22	122.22	600.0
2015-03-27 08:00:00	IWM	ETF	122.26	122.34	122.21	122.25	31870.0
2015-03-27 09:00:00	IWM	ETF	122.16	122.81	122.12	122.77	2952561.0
2015-03-27 10:00:00	IWM	ETF	122.77	122.94	121.86	122.78	4366544.0
2015-03-27 11:00:00	IWM	ETF	122.78	122.87	122.35	122.52	2342915.0
2015-03-27 12:00:00	IWM	ETF	122.53	122.88	122.48	122.86	1265897.0
2015-03-27 13:00:00	IWM	ETF	122.88	122.89	122.6	122.745	1727181.0
2015-03-27 14:00:00	IWM	ETF	122.75	122.85	122.66	122.82	831424.0
2015-03-27 15:00:00	IWM	ETF	122.82	123.23	122.81	123.11	6028013.0
2015-03-27 16:00:00	IWM	ETF	123.1	123.14	122.98	122.99	1823751.0
2015-03-27 17:00:00	IWM	ETF	123.01	123.14	122.96	123.1	316353.0
2015-03-27 19:00:00	IWM	ETF	123.05	123.1	123.04	123.04	1605.0
2015-03-27 08:00:00	DIA	ETF	176.25	176.25	176.25	176.25	1000.0
2015-03-27 09:00:00	DIA	ETF	176.21	176.78	176.14	176.59	571429.0
2015-03-27 10:00:00	DIA	ETF	176.58	176.93	175.97	176.91	816920.0

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

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