PREVIEW / etf_1hour / 2014-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-28.parquet
  size:    213 KB
  rows:    6,826

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
2014-05-28 04:00:00	SPY	ETF	191.55	191.7	191.55	191.67	2574.0
2014-05-28 05:00:00	SPY	ETF	191.66	191.86	191.62	191.86	19166.0
2014-05-28 06:00:00	SPY	ETF	191.84	191.98	191.83	191.84	27834.0
2014-05-28 07:00:00	SPY	ETF	191.84	191.97	191.77	191.79	185480.0
2014-05-28 08:00:00	SPY	ETF	191.78	191.9	191.43	191.46	977964.0
2014-05-28 09:00:00	SPY	ETF	191.46	191.73	191.34	191.41	9447817.0
2014-05-28 10:00:00	SPY	ETF	191.41	191.44	191.06	191.32	11843438.0
2014-05-28 11:00:00	SPY	ETF	191.32	191.68	191.29	191.55	5872715.0
2014-05-28 12:00:00	SPY	ETF	191.55	191.74	191.42	191.53	5331652.0
2014-05-28 13:00:00	SPY	ETF	191.53	191.82	191.5	191.765	5455890.0
2014-05-28 14:00:00	SPY	ETF	191.76	191.82	191.53	191.66	7646499.0
2014-05-28 15:00:00	SPY	ETF	191.66	191.8	191.32	191.35	14865049.0
2014-05-28 16:00:00	SPY	ETF	191.35	191.59	191.32	191.52	3665633.0
2014-05-28 17:00:00	SPY	ETF	191.52	191.55	191.5	191.53	48520.0
2014-05-28 18:00:00	SPY	ETF	191.52	191.54	191.46	191.54	9715.0
2014-05-28 19:00:00	SPY	ETF	191.47	191.48	191.42	191.44	10514.0
2014-05-28 04:00:00	QQQ	ETF	91.01	91.07	91.01	91.07	400.0
2014-05-28 05:00:00	QQQ	ETF	91.16	91.16	91.16	91.16	10042.0
2014-05-28 06:00:00	QQQ	ETF	91.17	91.19	91.14	91.14	5250.0
2014-05-28 07:00:00	QQQ	ETF	91.17	91.17	91.04	91.04	94385.0
2014-05-28 08:00:00	QQQ	ETF	91.09	91.09	90.89	90.9	194649.0
2014-05-28 09:00:00	QQQ	ETF	90.9	91.04	90.76	90.85	6008397.0
2014-05-28 10:00:00	QQQ	ETF	90.85	90.94	90.645	90.8	5584050.0
2014-05-28 11:00:00	QQQ	ETF	90.79	91.07	90.77	90.95	3077708.0
2014-05-28 12:00:00	QQQ	ETF	90.959	91.1	90.85	90.93	1817710.0
2014-05-28 13:00:00	QQQ	ETF	90.94	91.1	90.92	91.0501	2182424.0
2014-05-28 14:00:00	QQQ	ETF	91.05	91.0782	90.83	90.89	2947128.0
2014-05-28 15:00:00	QQQ	ETF	90.89	91.005	90.69	90.71	4992312.0
2014-05-28 16:00:00	QQQ	ETF	90.7	90.9984	90.7	90.85	1568266.0
2014-05-28 17:00:00	QQQ	ETF	90.87	90.88	90.82	90.82	1900.0
2014-05-28 18:00:00	QQQ	ETF	90.83	90.86	90.79	90.79	3282.0
2014-05-28 19:00:00	QQQ	ETF	90.8	90.84	90.8	90.84	9765.0
2014-05-28 04:00:00	IWM	ETF	113.86	113.86	113.86	113.86	200.0
2014-05-28 07:00:00	IWM	ETF	113.58	113.58	113.32	113.37	118499.0
2014-05-28 08:00:00	IWM	ETF	113.44	113.51	113.15	113.15	175106.0
2014-05-28 09:00:00	IWM	ETF	113.15	113.46	112.81	112.83	6611892.0
2014-05-28 10:00:00	IWM	ETF	112.822	112.97	112.525	112.67	7299653.0
2014-05-28 11:00:00	IWM	ETF	112.66	113.28	112.62	113.03	3087353.0
2014-05-28 12:00:00	IWM	ETF	113.025	113.19	112.81	112.9	2668737.0
2014-05-28 13:00:00	IWM	ETF	112.9	113.22	112.88	113.174	2092406.0
2014-05-28 14:00:00	IWM	ETF	113.18	113.25	112.97	113.19	2307096.0
2014-05-28 15:00:00	IWM	ETF	113.18	113.4	112.96	112.98	5217241.0
2014-05-28 16:00:00	IWM	ETF	112.97	113.1	112.9094	113.01	877265.0
2014-05-28 17:00:00	IWM	ETF	113.05	113.05	112.99	112.99	357006.0
2014-05-28 19:00:00	IWM	ETF	112.98	112.98	112.98	112.98	500.0
2014-05-28 05:00:00	DIA	ETF	166.66	166.66	166.66	166.66	500.0
2014-05-28 06:00:00	DIA	ETF	166.75	166.79	166.75	166.79	6200.0
2014-05-28 07:00:00	DIA	ETF	166.8	166.8	166.68	166.68	700.0
2014-05-28 08:00:00	DIA	ETF	166.66	166.74	166.49	166.49	8555.0
2014-05-28 09:00:00	DIA	ETF	166.54	166.58	166.13	166.2	1300801.0

> showing 50 of 6,826 rows — these rows as CSV

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