PREVIEW / etf_1hour / 2013-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-15.parquet
  size:    211 KB
  rows:    6,645

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-10-15 04:00:00	SPY	ETF	170.89	171.04	170.88	171.02	137556.0
2013-10-15 05:00:00	SPY	ETF	171.04	171.3	171.02	171.18	81659.0
2013-10-15 06:00:00	SPY	ETF	171.16	171.2	171.06	171.16	47300.0
2013-10-15 07:00:00	SPY	ETF	171.18	171.21	170.65	170.68	507972.0
2013-10-15 08:00:00	SPY	ETF	170.69	171.17	170.54	170.79	1159103.0
2013-10-15 09:00:00	SPY	ETF	170.79	170.92	170.01	170.54	20394543.0
2013-10-15 10:00:00	SPY	ETF	170.54	170.92	170.36	170.44	17945738.0
2013-10-15 11:00:00	SPY	ETF	170.44	171.15	170.22	170.72	22720171.0
2013-10-15 12:00:00	SPY	ETF	170.72	170.745	170.41	170.6	8013889.0
2013-10-15 13:00:00	SPY	ETF	170.59	170.68	170.32	170.54	8219507.0
2013-10-15 14:00:00	SPY	ETF	170.54	170.67	169.47	170.01	36394248.0
2013-10-15 15:00:00	SPY	ETF	170.015	170.44	169.69	169.71	28658664.0
2013-10-15 16:00:00	SPY	ETF	169.71	170.696	169.67	169.93	7647461.0
2013-10-15 17:00:00	SPY	ETF	169.93	170.08	169.7	169.91	1319116.0
2013-10-15 18:00:00	SPY	ETF	169.93	170.36	169.67	169.67	1014027.0
2013-10-15 19:00:00	SPY	ETF	169.69	170.9	169.69	170.86	512927.0
2013-10-15 04:00:00	QQQ	ETF	79.97	79.97	79.78	79.85	30300.0
2013-10-15 05:00:00	QQQ	ETF	79.86	79.98	79.86	79.93	10451.0
2013-10-15 06:00:00	QQQ	ETF	79.92	79.95	79.88	79.93	9432.0
2013-10-15 07:00:00	QQQ	ETF	79.94	79.96	79.77	79.77	88300.0
2013-10-15 08:00:00	QQQ	ETF	79.76	79.91	79.72	79.85	151048.0
2013-10-15 09:00:00	QQQ	ETF	79.86	79.91	79.54	79.85	4590567.0
2013-10-15 10:00:00	QQQ	ETF	79.86	79.97	79.71	79.753	4180665.0
2013-10-15 11:00:00	QQQ	ETF	79.75	80.11	79.69	79.89	5435373.0
2013-10-15 12:00:00	QQQ	ETF	79.8901	79.92	79.67	79.805	3048438.0
2013-10-15 13:00:00	QQQ	ETF	79.8	79.9	79.7	79.842	2416406.0
2013-10-15 14:00:00	QQQ	ETF	79.85	79.94	79.38	79.59	7562924.0
2013-10-15 15:00:00	QQQ	ETF	79.59	79.79	79.43	79.49	7293049.0
2013-10-15 16:00:00	QQQ	ETF	79.48	79.79	79.47	79.6	2285663.0
2013-10-15 17:00:00	QQQ	ETF	79.59	79.68	79.55	79.64	63200.0
2013-10-15 18:00:00	QQQ	ETF	79.55	79.72	79.45	79.45	48311.0
2013-10-15 19:00:00	QQQ	ETF	79.48	79.93	79.42	79.9	188464.0
2013-10-15 07:00:00	IWM	ETF	108.34	108.34	108.13	108.16	19750.0
2013-10-15 08:00:00	IWM	ETF	108.12	108.34	108.02	108.17	57837.0
2013-10-15 09:00:00	IWM	ETF	108.18	108.28	107.52	107.95	5028685.0
2013-10-15 10:00:00	IWM	ETF	107.96	108.225	107.5899	107.634	6589066.0
2013-10-15 11:00:00	IWM	ETF	107.63	108.08	107.48	107.72	5185263.0
2013-10-15 12:00:00	IWM	ETF	107.71	107.73	107.38	107.58	2972400.0
2013-10-15 13:00:00	IWM	ETF	107.57	107.67	107.33	107.55	2743891.0
2013-10-15 14:00:00	IWM	ETF	107.55	107.63	106.92	107.34	5805039.0
2013-10-15 15:00:00	IWM	ETF	107.33	107.56	107.12	107.15	8630489.0
2013-10-15 16:00:00	IWM	ETF	107.16	107.66	107.16	107.45	2911640.0
2013-10-15 17:00:00	IWM	ETF	107.46	107.56	107.46	107.48	17586.0
2013-10-15 18:00:00	IWM	ETF	107.46	107.6	107.39	107.39	16140.0
2013-10-15 19:00:00	IWM	ETF	107.35	107.96	107.35	107.96	23046.0
2013-10-15 08:00:00	DIA	ETF	152.79	152.79	152.7	152.7	650.0
2013-10-15 09:00:00	DIA	ETF	152.8	152.88	151.95	152.401	1002307.0
2013-10-15 10:00:00	DIA	ETF	152.45	152.62	152.12	152.1609	1230889.0
2013-10-15 11:00:00	DIA	ETF	152.17	152.8	152.01	152.43	1336424.0
2013-10-15 12:00:00	DIA	ETF	152.43	152.48	152.2226	152.36	465667.0

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

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