PREVIEW / etf_1hour / 2013-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-18.parquet
  size:    215 KB
  rows:    6,747

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
2013-12-18 04:00:00	SPY	ETF	178.71	179.17	178.71	179.04	73264.0
2013-12-18 05:00:00	SPY	ETF	179.05	179.2	178.98	179.17	47183.0
2013-12-18 06:00:00	SPY	ETF	179.15	179.15	178.86	178.96	25697.0
2013-12-18 07:00:00	SPY	ETF	178.93	178.93	178.75	178.82	119984.0
2013-12-18 08:00:00	SPY	ETF	178.83	178.91	178.72	178.86	658827.0
2013-12-18 09:00:00	SPY	ETF	178.86	179.09	178.74	178.9	12766173.0
2013-12-18 10:00:00	SPY	ETF	178.9	179.07	178.64	178.8091	12011837.0
2013-12-18 11:00:00	SPY	ETF	178.805	178.88	178.42	178.49	11089994.0
2013-12-18 12:00:00	SPY	ETF	178.49	178.61	178.32	178.36	11653697.0
2013-12-18 13:00:00	SPY	ETF	178.35	178.75	177.87	178.44	20553999.0
2013-12-18 14:00:00	SPY	ETF	178.44	180.795	177.32	180.52	78880076.0
2013-12-18 15:00:00	SPY	ETF	180.52	181.73	180.37	181.7	63978728.0
2013-12-18 16:00:00	SPY	ETF	181.69	181.84	178.3982	181.59	16562993.0
2013-12-18 17:00:00	SPY	ETF	181.59	181.66	181.56	181.62	221422.0
2013-12-18 18:00:00	SPY	ETF	181.62	181.82	181.59	181.69	234870.0
2013-12-18 19:00:00	SPY	ETF	181.67	181.67	181.51	181.52	142984.0
2013-12-18 04:00:00	QQQ	ETF	85.22	85.31	85.22	85.31	13500.0
2013-12-18 05:00:00	QQQ	ETF	85.33	85.39	85.31	85.39	7300.0
2013-12-18 06:00:00	QQQ	ETF	85.37	85.37	85.23	85.25	7000.0
2013-12-18 07:00:00	QQQ	ETF	85.23	85.23	85.17	85.22	72520.0
2013-12-18 08:00:00	QQQ	ETF	85.19	85.23	85.15	85.23	372881.0
2013-12-18 09:00:00	QQQ	ETF	85.23	85.29	84.91	84.95	3743676.0
2013-12-18 10:00:00	QQQ	ETF	84.95	85.16	84.87	84.98	2796343.0
2013-12-18 11:00:00	QQQ	ETF	84.98	85.04	84.62	84.69	2926148.0
2013-12-18 12:00:00	QQQ	ETF	84.69	84.78	84.51	84.55	3882262.0
2013-12-18 13:00:00	QQQ	ETF	84.55	84.66	84.27	84.6	7507584.0
2013-12-18 14:00:00	QQQ	ETF	84.6	85.63	84.05	85.485	26812303.0
2013-12-18 15:00:00	QQQ	ETF	85.48	86.22	85.41	86.17	14374919.0
2013-12-18 16:00:00	QQQ	ETF	86.17	86.28	84.5697	86.22	2670895.0
2013-12-18 17:00:00	QQQ	ETF	86.23	86.29	86.22	86.26	100241.0
2013-12-18 18:00:00	QQQ	ETF	86.27	86.36	86.27	86.32	44015.0
2013-12-18 19:00:00	QQQ	ETF	86.3	86.31	86.22	86.22	69070.0
2013-12-18 05:00:00	IWM	ETF	112.24	112.24	112.05	112.05	700.0
2013-12-18 07:00:00	IWM	ETF	111.47	111.48	111.38	111.42	82300.0
2013-12-18 08:00:00	IWM	ETF	111.45	111.52	111.39	111.49	48393.0
2013-12-18 09:00:00	IWM	ETF	111.49	111.79	111.33	111.51	2994039.0
2013-12-18 10:00:00	IWM	ETF	111.52	111.94	111.42	111.66	3535252.0
2013-12-18 11:00:00	IWM	ETF	111.67	111.76	111.07	111.24	3604219.0
2013-12-18 12:00:00	IWM	ETF	111.23	111.465	111.12	111.16	2083812.0
2013-12-18 13:00:00	IWM	ETF	111.16	111.23	110.86	111.23	4726316.0
2013-12-18 14:00:00	IWM	ETF	111.226	112.62	110.36	112.315	15133353.0
2013-12-18 15:00:00	IWM	ETF	112.315	112.9	112.25	112.88	12218257.0
2013-12-18 16:00:00	IWM	ETF	112.88	113.05	111.0188	112.99	3092379.0
2013-12-18 17:00:00	IWM	ETF	113.0	113.01	112.9	112.93	25498.0
2013-12-18 18:00:00	IWM	ETF	113.0	113.02	112.99	113.0	11248.0
2013-12-18 19:00:00	IWM	ETF	112.9	113.0	112.89	112.89	4125.0
2013-12-18 07:00:00	DIA	ETF	159.06	159.06	159.06	159.06	300.0
2013-12-18 08:00:00	DIA	ETF	159.06	159.06	159.06	159.06	200.0
2013-12-18 09:00:00	DIA	ETF	159.04	159.44	159.04	159.36	927154.0
2013-12-18 10:00:00	DIA	ETF	159.36	159.44	159.05	159.25	562848.0

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

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