PREVIEW / etf_1hour / 2014-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-10.parquet
  size:    217 KB
  rows:    6,787

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-01-10 04:00:00	SPY	ETF	183.8	184.14	183.8	184.14	76770.0
2014-01-10 05:00:00	SPY	ETF	184.09	184.25	184.09	184.25	13520.0
2014-01-10 06:00:00	SPY	ETF	184.23	184.32	184.22	184.22	37203.0
2014-01-10 07:00:00	SPY	ETF	184.25	184.45	184.22	184.415	1412619.0
2014-01-10 08:00:00	SPY	ETF	184.42	184.57	183.26	184.17	8406061.0
2014-01-10 09:00:00	SPY	ETF	184.14	184.22	183.67	183.68	14566409.0
2014-01-10 10:00:00	SPY	ETF	183.68	183.68	183.12	183.49	14774958.0
2014-01-10 11:00:00	SPY	ETF	183.49	183.56	183.01	183.17	10511288.0
2014-01-10 12:00:00	SPY	ETF	183.18	183.74	183.07	183.44	8579739.0
2014-01-10 13:00:00	SPY	ETF	183.43	183.72	183.3899	183.44	6828395.0
2014-01-10 14:00:00	SPY	ETF	183.44	183.69	183.42	183.53	6491125.0
2014-01-10 15:00:00	SPY	ETF	183.5351	184.08	183.5351	184.07	18270397.0
2014-01-10 16:00:00	SPY	ETF	184.07	184.21	183.36	184.2	9988457.0
2014-01-10 17:00:00	SPY	ETF	184.2	184.29	184.11	184.11	152202.0
2014-01-10 18:00:00	SPY	ETF	184.12	184.2	184.11	184.19	7150.0
2014-01-10 19:00:00	SPY	ETF	184.18	184.25	184.15	184.19	16470.0
2014-01-10 04:00:00	QQQ	ETF	87.29	87.33	87.29	87.33	4832.0
2014-01-10 05:00:00	QQQ	ETF	87.35	87.4	87.35	87.4	23800.0
2014-01-10 06:00:00	QQQ	ETF	87.42	87.49	87.42	87.46	9060.0
2014-01-10 07:00:00	QQQ	ETF	87.43	87.54	87.43	87.54	29000.0
2014-01-10 08:00:00	QQQ	ETF	87.53	87.6	86.78	87.25	1028436.0
2014-01-10 09:00:00	QQQ	ETF	87.23	87.4	87.0301	87.09	3957997.0
2014-01-10 10:00:00	QQQ	ETF	87.08	87.09	86.74	87.01	6113662.0
2014-01-10 11:00:00	QQQ	ETF	87.02	87.04	86.58	86.72	5020329.0
2014-01-10 12:00:00	QQQ	ETF	86.7199	86.93	86.65	86.785	2988769.0
2014-01-10 13:00:00	QQQ	ETF	86.79	87.02	86.75	86.879	1815611.0
2014-01-10 14:00:00	QQQ	ETF	86.875	87.005	86.86	86.93	2045296.0
2014-01-10 15:00:00	QQQ	ETF	86.93	87.31	86.92	87.3	6226436.0
2014-01-10 16:00:00	QQQ	ETF	87.3	87.4	86.9922	87.391	2672848.0
2014-01-10 17:00:00	QQQ	ETF	87.399	87.41	87.39	87.4	4850.0
2014-01-10 18:00:00	QQQ	ETF	87.4	87.4	87.34	87.35	2500.0
2014-01-10 19:00:00	QQQ	ETF	87.35	87.35	87.35	87.35	650.0
2014-01-10 07:00:00	IWM	ETF	115.31	115.48	115.28	115.46	86800.0
2014-01-10 08:00:00	IWM	ETF	115.45	115.57	114.52	115.16	1356576.0
2014-01-10 09:00:00	IWM	ETF	115.14	115.15	114.74	114.82	4796614.0
2014-01-10 10:00:00	IWM	ETF	114.82	115.12	114.3999	115.07	6503870.0
2014-01-10 11:00:00	IWM	ETF	115.08	115.14	114.49	114.74	3816762.0
2014-01-10 12:00:00	IWM	ETF	114.74	115.18	114.56	114.93	2560198.0
2014-01-10 13:00:00	IWM	ETF	114.939	115.22	114.9	115.05	1541510.0
2014-01-10 14:00:00	IWM	ETF	115.05	115.21	115.03	115.06	1351702.0
2014-01-10 15:00:00	IWM	ETF	115.06	115.53	115.0501	115.5	4643652.0
2014-01-10 16:00:00	IWM	ETF	115.49	115.5402	115.44	115.53	908159.0
2014-01-10 17:00:00	IWM	ETF	115.53	115.56	115.48	115.48	55869.0
2014-01-10 18:00:00	IWM	ETF	115.54	115.54	115.54	115.54	140.0
2014-01-10 19:00:00	IWM	ETF	115.54	115.55	115.54	115.55	630.0
2014-01-10 04:00:00	DIA	ETF	164.63	164.63	164.63	164.63	100.0
2014-01-10 07:00:00	DIA	ETF	164.65	164.88	164.65	164.88	2620.0
2014-01-10 08:00:00	DIA	ETF	164.9	164.9	164.12	164.6	28418.0
2014-01-10 09:00:00	DIA	ETF	164.61	164.69	164.09	164.092	839300.0
2014-01-10 10:00:00	DIA	ETF	164.11	164.11	163.59	163.87	1355993.0

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

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