PREVIEW / etf_1hour / 2013-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-20.parquet
  size:    219 KB
  rows:    6,899

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-20 04:00:00	SPY	ETF	180.68	181.02	180.68	180.79	10031.0
2013-12-20 05:00:00	SPY	ETF	180.82	180.85	180.7	180.73	6737.0
2013-12-20 06:00:00	SPY	ETF	180.79	180.81	180.63	180.67	10140.0
2013-12-20 07:00:00	SPY	ETF	180.68	181.6	180.51	180.58	494467.0
2013-12-20 08:00:00	SPY	ETF	180.59	180.86	180.53	180.79	1940841.0
2013-12-20 09:00:00	SPY	ETF	180.79	181.44	180.66	181.33	21028072.0
2013-12-20 10:00:00	SPY	ETF	181.32	181.55	181.11	181.35	20381336.0
2013-12-20 11:00:00	SPY	ETF	181.35	181.79	181.32	181.75	18877176.0
2013-12-20 12:00:00	SPY	ETF	181.75	181.91	181.64	181.8	16128631.0
2013-12-20 13:00:00	SPY	ETF	181.7901	181.97	181.72	181.94	12161252.0
2013-12-20 14:00:00	SPY	ETF	181.94	181.99	181.84	181.89	12990720.0
2013-12-20 15:00:00	SPY	ETF	181.88	181.924	181.46	181.55	34516903.0
2013-12-20 16:00:00	SPY	ETF	181.57	181.96	180.5486	181.85	19619479.0
2013-12-20 17:00:00	SPY	ETF	181.86	181.96	180.5683	181.81	28017174.0
2013-12-20 18:00:00	SPY	ETF	181.81	182.0	181.64	181.75	271600.0
2013-12-20 19:00:00	SPY	ETF	181.74	181.97	181.7	181.9	135272.0
2013-12-20 04:00:00	QQQ	ETF	85.86	85.86	85.8	85.8	1762.0
2013-12-20 05:00:00	QQQ	ETF	85.78	85.78	85.74	85.77	1968.0
2013-12-20 06:00:00	QQQ	ETF	85.78	85.8	85.76	85.76	2900.0
2013-12-20 07:00:00	QQQ	ETF	85.77	85.77	85.7	85.72	6475.0
2013-12-20 08:00:00	QQQ	ETF	85.74	86.12	85.7	85.82	78209.0
2013-12-20 09:00:00	QQQ	ETF	85.84	86.15	85.73	86.08	7043205.0
2013-12-20 10:00:00	QQQ	ETF	86.07	86.345	86.0199	86.3	5672998.0
2013-12-20 11:00:00	QQQ	ETF	86.29	86.53	86.27	86.5225	3977371.0
2013-12-20 12:00:00	QQQ	ETF	86.519	86.6	86.46	86.5399	3226474.0
2013-12-20 13:00:00	QQQ	ETF	86.53	86.6	86.49	86.59	2031857.0
2013-12-20 14:00:00	QQQ	ETF	86.6	86.68	86.56	86.64	2637255.0
2013-12-20 15:00:00	QQQ	ETF	86.64	86.64	86.46	86.48	8565179.0
2013-12-20 16:00:00	QQQ	ETF	86.48	86.6246	85.6348	86.61	5726311.0
2013-12-20 17:00:00	QQQ	ETF	86.59	86.67	86.59	86.64	61920.0
2013-12-20 18:00:00	QQQ	ETF	86.67	86.69	86.64	86.64	30288.0
2013-12-20 19:00:00	QQQ	ETF	86.64	86.71	86.63	86.63	17664.0
2013-12-20 07:00:00	IWM	ETF	112.15	112.25	112.03	112.25	50866.0
2013-12-20 08:00:00	IWM	ETF	112.26	112.4	112.21	112.33	140301.0
2013-12-20 09:00:00	IWM	ETF	112.31	112.62	112.07	112.51	4174763.0
2013-12-20 10:00:00	IWM	ETF	112.52	113.08	112.49	112.97	6570629.0
2013-12-20 11:00:00	IWM	ETF	112.96	113.71	112.92	113.62	6762988.0
2013-12-20 12:00:00	IWM	ETF	113.62	113.75	113.55	113.66	2956870.0
2013-12-20 13:00:00	IWM	ETF	113.66	113.98	113.65	113.97	4542993.0
2013-12-20 14:00:00	IWM	ETF	113.96	114.13	113.95	114.01	4194512.0
2013-12-20 15:00:00	IWM	ETF	114.02	114.22	113.9	113.9	11394488.0
2013-12-20 16:00:00	IWM	ETF	113.905	114.27	113.85	114.14	3537257.0
2013-12-20 17:00:00	IWM	ETF	114.2	114.25	114.08	114.08	40197.0
2013-12-20 18:00:00	IWM	ETF	114.09	114.09	114.03	114.03	1156.0
2013-12-20 19:00:00	IWM	ETF	114.2	114.2	114.06	114.06	1528.0
2013-12-20 08:00:00	DIA	ETF	161.69	161.69	161.63	161.63	3886.0
2013-12-20 09:00:00	DIA	ETF	161.64	162.19	161.61	162.13	1473387.0
2013-12-20 10:00:00	DIA	ETF	162.14	162.19	161.93	162.07	738908.0
2013-12-20 11:00:00	DIA	ETF	162.06	162.38	162.03	162.32	789138.0
2013-12-20 12:00:00	DIA	ETF	162.3199	162.47	162.23	162.341	1210830.0

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

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