PREVIEW / etf_1hour / 2014-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-10.parquet
  size:    224 KB
  rows:    6,999

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-04-10 04:00:00	SPY	ETF	187.17	187.2	186.88	186.9	15300.0
2014-04-10 05:00:00	SPY	ETF	186.85	186.85	186.29	186.48	108526.0
2014-04-10 06:00:00	SPY	ETF	186.5	186.75	186.37	186.75	189143.0
2014-04-10 07:00:00	SPY	ETF	186.75	187.09	186.7	186.75	750453.0
2014-04-10 08:00:00	SPY	ETF	186.89	187.08	186.62	186.85	1049605.0
2014-04-10 09:00:00	SPY	ETF	186.89	187.17	186.59	186.77	11494683.0
2014-04-10 10:00:00	SPY	ETF	186.77	186.95	186.05	186.055	15906455.0
2014-04-10 11:00:00	SPY	ETF	186.05	186.063	185.37	185.44	21317532.0
2014-04-10 12:00:00	SPY	ETF	185.43	185.54	184.4	184.41	21225284.0
2014-04-10 13:00:00	SPY	ETF	184.41	184.66	183.86	184.42	19167523.0
2014-04-10 14:00:00	SPY	ETF	184.419	184.66	183.68	183.78	17277441.0
2014-04-10 15:00:00	SPY	ETF	183.79	183.81	182.93	183.15	46919209.0
2014-04-10 16:00:00	SPY	ETF	183.14	187.1004	183.14	183.46	14620775.0
2014-04-10 17:00:00	SPY	ETF	183.49	187.1003	183.3	183.42	1772602.0
2014-04-10 18:00:00	SPY	ETF	183.42	183.48	183.25	183.3	114996.0
2014-04-10 19:00:00	SPY	ETF	183.3	183.35	183.23	183.31	48699.0
2014-04-10 04:00:00	QQQ	ETF	87.92	87.95	87.86	87.86	3900.0
2014-04-10 05:00:00	QQQ	ETF	87.82	87.84	87.41	87.5	40950.0
2014-04-10 06:00:00	QQQ	ETF	87.48	87.66	87.43	87.62	43350.0
2014-04-10 07:00:00	QQQ	ETF	87.66	87.84	87.66	87.66	225910.0
2014-04-10 08:00:00	QQQ	ETF	87.74	87.77	87.58	87.74	147401.0
2014-04-10 09:00:00	QQQ	ETF	87.77	87.88	87.0899	87.21	6873736.0
2014-04-10 10:00:00	QQQ	ETF	87.22	87.3	86.64	86.64	9154482.0
2014-04-10 11:00:00	QQQ	ETF	86.64	86.66	86.17	86.25	8854317.0
2014-04-10 12:00:00	QQQ	ETF	86.23	86.3	85.67	85.671	7938319.0
2014-04-10 13:00:00	QQQ	ETF	85.68	85.84	85.375	85.699	8143349.0
2014-04-10 14:00:00	QQQ	ETF	85.6999	85.82	85.19	85.31	8106411.0
2014-04-10 15:00:00	QQQ	ETF	85.3199	85.4	84.86	85.11	14288902.0
2014-04-10 16:00:00	QQQ	ETF	85.1	85.9445	85.0859	85.21	4267070.0
2014-04-10 17:00:00	QQQ	ETF	85.23	87.8319	85.21	85.21	1517241.0
2014-04-10 18:00:00	QQQ	ETF	85.22	85.22	85.14	85.14	14758.0
2014-04-10 19:00:00	QQQ	ETF	85.2	85.2	85.07	85.12	26757.0
2014-04-10 05:00:00	IWM	ETF	114.93	114.93	114.66	114.66	400.0
2014-04-10 06:00:00	IWM	ETF	114.65	114.81	114.6	114.81	15300.0
2014-04-10 07:00:00	IWM	ETF	115.0	115.16	114.88	114.88	174025.0
2014-04-10 08:00:00	IWM	ETF	114.94	115.0	114.74	114.88	973235.0
2014-04-10 09:00:00	IWM	ETF	114.88	115.11	114.26	114.44	4515854.0
2014-04-10 10:00:00	IWM	ETF	114.445	114.65	113.32	113.32	8166564.0
2014-04-10 11:00:00	IWM	ETF	113.32	113.45	112.69	112.76	11080077.0
2014-04-10 12:00:00	IWM	ETF	112.74	112.87	112.25	112.29	8329446.0
2014-04-10 13:00:00	IWM	ETF	112.2996	112.66	111.85	112.37	7828433.0
2014-04-10 14:00:00	IWM	ETF	112.36	112.5	111.78	111.98	6817094.0
2014-04-10 15:00:00	IWM	ETF	111.98	112.42	111.4	111.9	14600357.0
2014-04-10 16:00:00	IWM	ETF	111.92	115.1513	111.85	112.07	3394409.0
2014-04-10 17:00:00	IWM	ETF	112.06	112.06	111.97	111.97	4982.0
2014-04-10 18:00:00	IWM	ETF	111.95	111.95	111.95	111.95	614.0
2014-04-10 19:00:00	IWM	ETF	112.04	112.04	111.82	111.83	3292.0
2014-04-10 08:00:00	DIA	ETF	164.12	164.12	163.8	163.96	2751.0
2014-04-10 09:00:00	DIA	ETF	164.0	164.31	163.85	164.08	852600.0
2014-04-10 10:00:00	DIA	ETF	164.1	164.2551	163.65	163.65	869915.0

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

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