PREVIEW / etf_1hour / 2014-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-06.parquet
  size:    219 KB
  rows:    6,830

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-02-06 04:00:00	SPY	ETF	175.26	175.9	175.25	175.85	21554.0
2014-02-06 05:00:00	SPY	ETF	175.79	176.07	175.79	175.81	232513.0
2014-02-06 06:00:00	SPY	ETF	175.78	175.9	175.71	175.75	72191.0
2014-02-06 07:00:00	SPY	ETF	175.73	175.78	174.97	175.4	1038250.0
2014-02-06 08:00:00	SPY	ETF	175.4	176.01	174.96	175.36	4274579.0
2014-02-06 09:00:00	SPY	ETF	175.36	176.47	175.22	176.42	15831130.0
2014-02-06 10:00:00	SPY	ETF	176.42	177.135	176.35	176.92	22233453.0
2014-02-06 11:00:00	SPY	ETF	176.91	177.18	175.2209	176.85	16245976.0
2014-02-06 12:00:00	SPY	ETF	176.855	177.16	176.855	176.95	8780633.0
2014-02-06 13:00:00	SPY	ETF	176.95	177.05	176.67	176.842	7082117.0
2014-02-06 14:00:00	SPY	ETF	176.845	177.4	176.84	177.285	17874282.0
2014-02-06 15:00:00	SPY	ETF	177.29	177.48	177.16	177.42	24336678.0
2014-02-06 16:00:00	SPY	ETF	177.42	177.48	175.2209	177.27	9683748.0
2014-02-06 17:00:00	SPY	ETF	177.31	177.34	177.2	177.25	2249105.0
2014-02-06 18:00:00	SPY	ETF	177.25	177.48	177.2	177.33	468755.0
2014-02-06 19:00:00	SPY	ETF	177.32	177.32	177.23	177.24	53373.0
2014-02-06 04:00:00	QQQ	ETF	84.75	84.97	84.75	84.97	4100.0
2014-02-06 05:00:00	QQQ	ETF	85.13	85.13	85.0	85.0	6860.0
2014-02-06 06:00:00	QQQ	ETF	84.99	85.02	84.95	85.0	30120.0
2014-02-06 07:00:00	QQQ	ETF	85.0	85.0	84.71	84.85	138076.0
2014-02-06 08:00:00	QQQ	ETF	85.0	85.11	84.72	84.9	356263.0
2014-02-06 09:00:00	QQQ	ETF	84.89	85.49	84.79	85.45	5003430.0
2014-02-06 10:00:00	QQQ	ETF	85.45	85.88	85.44	85.76	5339477.0
2014-02-06 11:00:00	QQQ	ETF	85.75	85.81	85.59	85.591	3761382.0
2014-02-06 12:00:00	QQQ	ETF	85.591	85.749	85.591	85.66	2447679.0
2014-02-06 13:00:00	QQQ	ETF	85.66	85.7199	85.5	85.61	1793475.0
2014-02-06 14:00:00	QQQ	ETF	85.61	85.8404	85.609	85.78	3048899.0
2014-02-06 15:00:00	QQQ	ETF	85.78	85.82	85.67	85.75	6015299.0
2014-02-06 16:00:00	QQQ	ETF	85.75	85.77	84.6987	85.68	2252998.0
2014-02-06 17:00:00	QQQ	ETF	85.68	85.69	85.62	85.62	400.0
2014-02-06 18:00:00	QQQ	ETF	85.68	85.68	85.63	85.68	13401.0
2014-02-06 19:00:00	QQQ	ETF	85.68	85.68	85.61	85.64	15781.0
2014-02-06 04:00:00	IWM	ETF	108.97	108.97	108.97	108.97	100.0
2014-02-06 06:00:00	IWM	ETF	109.0	109.15	108.97	109.15	1800.0
2014-02-06 07:00:00	IWM	ETF	108.95	109.09	108.68	108.82	211485.0
2014-02-06 08:00:00	IWM	ETF	108.82	109.22	108.54	108.82	482068.0
2014-02-06 09:00:00	IWM	ETF	108.77	109.6	108.7	109.48	4984799.0
2014-02-06 10:00:00	IWM	ETF	109.48	109.97	109.25	109.82	8605631.0
2014-02-06 11:00:00	IWM	ETF	109.81	109.95	109.48	109.51	4729669.0
2014-02-06 12:00:00	IWM	ETF	109.505	109.75	109.46	109.56	2724707.0
2014-02-06 13:00:00	IWM	ETF	109.555	109.64	109.09	109.17	3975704.0
2014-02-06 14:00:00	IWM	ETF	109.165	109.74	109.15	109.53	5029320.0
2014-02-06 15:00:00	IWM	ETF	109.53	109.62	109.4	109.5	8537931.0
2014-02-06 16:00:00	IWM	ETF	109.5	109.5841	108.5593	109.31	9229959.0
2014-02-06 17:00:00	IWM	ETF	109.32	109.33	109.29	109.33	15540.0
2014-02-06 18:00:00	IWM	ETF	109.37	109.41	109.37	109.38	2036.0
2014-02-06 19:00:00	IWM	ETF	109.34	109.38	109.33	109.33	2200.0
2014-02-06 06:00:00	DIA	ETF	154.75	154.75	154.75	154.75	200.0
2014-02-06 08:00:00	DIA	ETF	154.55	154.95	154.24	154.47	34084.0
2014-02-06 09:00:00	DIA	ETF	154.45	155.41	154.36	155.37	1404998.0

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

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