PREVIEW / etf_1hour / 2013-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-04.parquet
  size:    205 KB
  rows:    6,547

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-11-04 04:00:00	SPY	ETF	176.21	176.35	176.21	176.22	39543.0
2013-11-04 05:00:00	SPY	ETF	176.18	176.25	176.15	176.25	19742.0
2013-11-04 06:00:00	SPY	ETF	176.25	176.42	176.25	176.42	42709.0
2013-11-04 07:00:00	SPY	ETF	176.4	176.62	176.36	176.59	363832.0
2013-11-04 08:00:00	SPY	ETF	176.56	176.71	176.0	176.69	1431779.0
2013-11-04 09:00:00	SPY	ETF	176.67	176.8	176.32	176.45	11685637.0
2013-11-04 10:00:00	SPY	ETF	176.451	176.62	176.22	176.2224	10333592.0
2013-11-04 11:00:00	SPY	ETF	176.23	176.46	176.1499	176.3849	9557844.0
2013-11-04 12:00:00	SPY	ETF	176.39	176.5	176.34	176.34	8411865.0
2013-11-04 13:00:00	SPY	ETF	176.34	176.55	176.33	176.53	8902027.0
2013-11-04 14:00:00	SPY	ETF	176.54	176.71	176.51	176.6029	5985970.0
2013-11-04 15:00:00	SPY	ETF	176.609	176.9	176.46	176.82	14966219.0
2013-11-04 16:00:00	SPY	ETF	176.83	176.91	176.164	176.81	8411375.0
2013-11-04 17:00:00	SPY	ETF	176.81	176.82	176.73	176.79	192993.0
2013-11-04 18:00:00	SPY	ETF	176.79	176.81	176.66	176.81	168355.0
2013-11-04 19:00:00	SPY	ETF	176.82	176.84	176.785	176.81	21551.0
2013-11-04 04:00:00	QQQ	ETF	82.88	82.89	82.87	82.87	12400.0
2013-11-04 05:00:00	QQQ	ETF	82.85	82.86	82.84	82.85	18100.0
2013-11-04 06:00:00	QQQ	ETF	82.89	82.98	82.89	82.98	6470.0
2013-11-04 07:00:00	QQQ	ETF	82.98	83.07	82.97	83.06	21260.0
2013-11-04 08:00:00	QQQ	ETF	83.05	83.11	83.0	83.1	286945.0
2013-11-04 09:00:00	QQQ	ETF	83.1	83.13	82.64	82.73	3531608.0
2013-11-04 10:00:00	QQQ	ETF	82.74	82.95	82.655	82.6901	3169314.0
2013-11-04 11:00:00	QQQ	ETF	82.7	82.89	82.665	82.86	2209717.0
2013-11-04 12:00:00	QQQ	ETF	82.86	82.875	82.72	82.72	1237881.0
2013-11-04 13:00:00	QQQ	ETF	82.71	82.79	82.65	82.735	1032674.0
2013-11-04 14:00:00	QQQ	ETF	82.74	82.87	82.73	82.8001	1045413.0
2013-11-04 15:00:00	QQQ	ETF	82.81	82.93	82.7	82.92	2471447.0
2013-11-04 16:00:00	QQQ	ETF	82.92	82.94	82.824	82.9	802856.0
2013-11-04 17:00:00	QQQ	ETF	82.93	82.94	82.92	82.92	4800.0
2013-11-04 18:00:00	QQQ	ETF	82.92	82.94	82.88	82.9	4650.0
2013-11-04 19:00:00	QQQ	ETF	82.91	82.93	82.91	82.91	3000.0
2013-11-04 07:00:00	IWM	ETF	109.02	109.14	109.02	109.14	23054.0
2013-11-04 08:00:00	IWM	ETF	109.13	109.29	109.0	109.28	303062.0
2013-11-04 09:00:00	IWM	ETF	109.3	109.34	108.925	109.08	3575578.0
2013-11-04 10:00:00	IWM	ETF	109.08	109.68	108.9551	109.36	4961939.0
2013-11-04 11:00:00	IWM	ETF	109.36	109.66	109.25	109.6099	3453251.0
2013-11-04 12:00:00	IWM	ETF	109.61	109.75	109.48	109.62	3122165.0
2013-11-04 13:00:00	IWM	ETF	109.62	109.81	109.6	109.8	1967954.0
2013-11-04 14:00:00	IWM	ETF	109.81	110.06	109.8	109.94	2792566.0
2013-11-04 15:00:00	IWM	ETF	109.94	110.15	109.8	109.99	5231254.0
2013-11-04 16:00:00	IWM	ETF	109.99	110.0786	108.8282	109.92	2723006.0
2013-11-04 17:00:00	IWM	ETF	109.9	109.97	109.9	109.97	2400.0
2013-11-04 18:00:00	IWM	ETF	109.89	109.89	109.83	109.83	500.0
2013-11-04 19:00:00	IWM	ETF	109.92	109.92	109.92	109.92	850.0
2013-11-04 06:00:00	DIA	ETF	155.99	155.99	155.99	155.99	100.0
2013-11-04 07:00:00	DIA	ETF	156.1	156.2	156.1	156.2	1500.0
2013-11-04 08:00:00	DIA	ETF	156.28	156.28	156.15	156.25	1249.0
2013-11-04 09:00:00	DIA	ETF	156.3	156.36	155.93	156.1199	851031.0
2013-11-04 10:00:00	DIA	ETF	156.08	156.1	155.625	155.625	755530.0

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

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