PREVIEW / etf_1hour / 2014-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-11.parquet
  size:    220 KB
  rows:    6,995

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-08-11 04:00:00	SPY	ETF	193.51	193.65	193.42	193.63	10594.0
2014-08-11 05:00:00	SPY	ETF	193.61	193.63	193.59	193.6	20495.0
2014-08-11 06:00:00	SPY	ETF	193.55	193.77	193.55	193.71	61181.0
2014-08-11 07:00:00	SPY	ETF	193.7	193.9	193.7	193.84	247643.0
2014-08-11 08:00:00	SPY	ETF	193.84	194.11	193.1	193.86	1172555.0
2014-08-11 09:00:00	SPY	ETF	193.85	194.22	193.7701	194.1549	11409111.0
2014-08-11 10:00:00	SPY	ETF	194.16	194.4	194.07	194.195	14434766.0
2014-08-11 11:00:00	SPY	ETF	194.18	194.66	194.13	194.43	10249180.0
2014-08-11 12:00:00	SPY	ETF	194.44	194.46	194.22	194.28	6383239.0
2014-08-11 13:00:00	SPY	ETF	194.281	194.39	193.82	193.92	6461493.0
2014-08-11 14:00:00	SPY	ETF	193.91	194.02	193.72	193.905	7429612.0
2014-08-11 15:00:00	SPY	ETF	193.905	194.12	193.71	193.79	11994314.0
2014-08-11 16:00:00	SPY	ETF	193.8	193.9	193.75	193.89	3387717.0
2014-08-11 17:00:00	SPY	ETF	193.89	193.95	193.86	193.89	146642.0
2014-08-11 18:00:00	SPY	ETF	193.92	193.97	193.91	193.97	72174.0
2014-08-11 19:00:00	SPY	ETF	193.97	193.97	193.93	193.97	19646.0
2014-08-11 04:00:00	QQQ	ETF	95.06	95.11	94.99	95.07	2600.0
2014-08-11 05:00:00	QQQ	ETF	95.16	95.16	95.16	95.16	1000.0
2014-08-11 06:00:00	QQQ	ETF	95.12	95.22	95.12	95.2	39280.0
2014-08-11 07:00:00	QQQ	ETF	95.19	95.33	95.19	95.24	92066.0
2014-08-11 08:00:00	QQQ	ETF	95.28	95.29	95.17	95.21	206657.0
2014-08-11 09:00:00	QQQ	ETF	95.2	95.55	95.19	95.52	4250459.0
2014-08-11 10:00:00	QQQ	ETF	95.53	95.68	95.44	95.58	3943928.0
2014-08-11 11:00:00	QQQ	ETF	95.57	95.76	95.52	95.65	3184811.0
2014-08-11 12:00:00	QQQ	ETF	95.65	95.68	95.55	95.5601	1659963.0
2014-08-11 13:00:00	QQQ	ETF	95.56	95.66	95.41	95.475	2223556.0
2014-08-11 14:00:00	QQQ	ETF	95.47	95.54	95.361	95.48	2261074.0
2014-08-11 15:00:00	QQQ	ETF	95.5	95.61	95.43	95.47	3953602.0
2014-08-11 16:00:00	QQQ	ETF	95.47	95.5978	95.41	95.49	2507780.0
2014-08-11 17:00:00	QQQ	ETF	95.49	95.53	95.49	95.52	9937.0
2014-08-11 18:00:00	QQQ	ETF	95.52	95.53	95.5	95.53	4725.0
2014-08-11 19:00:00	QQQ	ETF	95.52	95.53	95.51	95.53	5228.0
2014-08-11 04:00:00	IWM	ETF	112.65	112.65	112.65	112.65	298.0
2014-08-11 06:00:00	IWM	ETF	112.67	112.88	112.67	112.84	11700.0
2014-08-11 07:00:00	IWM	ETF	112.88	112.88	112.77	112.82	54600.0
2014-08-11 08:00:00	IWM	ETF	112.77	112.9	112.73	112.87	250728.0
2014-08-11 09:00:00	IWM	ETF	112.88	113.06	112.62	113.03	3168925.0
2014-08-11 10:00:00	IWM	ETF	113.04	113.695	113.03	113.49	5391758.0
2014-08-11 11:00:00	IWM	ETF	113.48	114.22	113.45	113.89	5396675.0
2014-08-11 12:00:00	IWM	ETF	113.89	113.91	113.68	113.74	1634812.0
2014-08-11 13:00:00	IWM	ETF	113.745	113.84	113.35	113.46	1711123.0
2014-08-11 14:00:00	IWM	ETF	113.46	113.5299	113.29	113.39	2418907.0
2014-08-11 15:00:00	IWM	ETF	113.4	113.565	113.32	113.35	4700809.0
2014-08-11 16:00:00	IWM	ETF	113.35	113.4282	113.1889	113.29	1606018.0
2014-08-11 17:00:00	IWM	ETF	113.3	113.32	113.27	113.27	54290.0
2014-08-11 18:00:00	IWM	ETF	113.26	113.34	113.26	113.33	1106.0
2014-08-11 19:00:00	IWM	ETF	113.32	113.34	113.32	113.34	400.0
2014-08-11 04:00:00	DIA	ETF	165.56	165.56	165.56	165.56	200.0
2014-08-11 06:00:00	DIA	ETF	165.42	165.42	165.42	165.42	120.0
2014-08-11 08:00:00	DIA	ETF	165.89	166.0	165.7	165.99	4950.0

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

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