PREVIEW / etf_1hour / 2013-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-01.parquet
  size:    210 KB
  rows:    6,613

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-01 04:00:00	SPY	ETF	175.9	175.9	175.73	175.78	349000.0
2013-11-01 05:00:00	SPY	ETF	175.83	175.83	175.74	175.82	10079.0
2013-11-01 06:00:00	SPY	ETF	175.8	175.89	175.68	175.82	79200.0
2013-11-01 07:00:00	SPY	ETF	175.83	175.98	175.81	175.92	217453.0
2013-11-01 08:00:00	SPY	ETF	175.9	176.09	175.73	175.97	690803.0
2013-11-01 09:00:00	SPY	ETF	175.99	176.38	175.89	176.24	13553692.0
2013-11-01 10:00:00	SPY	ETF	176.26	176.61	175.7597	176.1	21163994.0
2013-11-01 11:00:00	SPY	ETF	176.105	176.13	175.27	175.3	17724450.0
2013-11-01 12:00:00	SPY	ETF	175.3	175.69	175.22	175.57	11569322.0
2013-11-01 13:00:00	SPY	ETF	175.56	175.95	175.38	175.91	9907706.0
2013-11-01 14:00:00	SPY	ETF	175.91	176.0	175.75	175.83	9300139.0
2013-11-01 15:00:00	SPY	ETF	175.83	176.42	175.8	176.15	29451273.0
2013-11-01 16:00:00	SPY	ETF	176.15	176.26	175.6536	175.95	9765323.0
2013-11-01 17:00:00	SPY	ETF	175.96	176.02	175.93	175.93	9752291.0
2013-11-01 18:00:00	SPY	ETF	175.97	176.01	175.97	176.0	12550.0
2013-11-01 19:00:00	SPY	ETF	175.98	176.0	175.91	176.0	17084.0
2013-11-01 04:00:00	QQQ	ETF	82.85	82.86	82.78	82.84	10100.0
2013-11-01 05:00:00	QQQ	ETF	82.86	82.89	82.84	82.89	8500.0
2013-11-01 06:00:00	QQQ	ETF	82.87	82.89	82.84	82.86	33400.0
2013-11-01 07:00:00	QQQ	ETF	82.89	82.95	82.89	82.93	59700.0
2013-11-01 08:00:00	QQQ	ETF	82.95	83.01	82.78	83.0	89590.0
2013-11-01 09:00:00	QQQ	ETF	82.99	83.13	82.95	83.05	3548931.0
2013-11-01 10:00:00	QQQ	ETF	83.06	83.169	82.69	82.885	6770515.0
2013-11-01 11:00:00	QQQ	ETF	82.87	82.885	82.45	82.48	5271411.0
2013-11-01 12:00:00	QQQ	ETF	82.47	82.73	82.45	82.59	3088131.0
2013-11-01 13:00:00	QQQ	ETF	82.58	82.635	82.4	82.605	2839156.0
2013-11-01 14:00:00	QQQ	ETF	82.6099	82.67	82.55	82.59	1609803.0
2013-11-01 15:00:00	QQQ	ETF	82.59	82.86	82.58	82.78	5544471.0
2013-11-01 16:00:00	QQQ	ETF	82.78	83.106	82.62	82.65	1327765.0
2013-11-01 17:00:00	QQQ	ETF	82.66	82.7	82.66	82.7	23050.0
2013-11-01 18:00:00	QQQ	ETF	82.63	82.76	82.63	82.76	4022.0
2013-11-01 19:00:00	QQQ	ETF	82.76	82.76	82.75	82.76	1368.0
2013-11-01 06:00:00	IWM	ETF	109.1	109.1	109.1	109.1	500.0
2013-11-01 07:00:00	IWM	ETF	109.22	109.34	109.22	109.31	132620.0
2013-11-01 08:00:00	IWM	ETF	109.3148	109.44	109.22	109.4	249545.0
2013-11-01 09:00:00	IWM	ETF	109.42	109.63	108.89	109.36	11398863.0
2013-11-01 10:00:00	IWM	ETF	109.35	109.58	108.6	108.68	13580181.0
2013-11-01 11:00:00	IWM	ETF	108.685	108.7	108.0	108.02	11683939.0
2013-11-01 12:00:00	IWM	ETF	108.01	108.36	107.92	108.21	6116197.0
2013-11-01 13:00:00	IWM	ETF	108.2	108.57	108.14	108.49	6712162.0
2013-11-01 14:00:00	IWM	ETF	108.49	108.71	108.31	108.31	8836414.0
2013-11-01 15:00:00	IWM	ETF	108.32	109.0	108.29	108.69	19010000.0
2013-11-01 16:00:00	IWM	ETF	108.68	109.2675	108.459	108.58	12459834.0
2013-11-01 17:00:00	IWM	ETF	108.58	108.61	108.53	108.53	24325.0
2013-11-01 19:00:00	IWM	ETF	108.51	108.51	108.51	108.51	180.0
2013-11-01 08:00:00	DIA	ETF	155.56	155.6	155.52	155.52	2500.0
2013-11-01 09:00:00	DIA	ETF	155.55	155.96	155.47	155.91	457409.0
2013-11-01 10:00:00	DIA	ETF	155.91	156.15	155.45	155.79	986094.0
2013-11-01 11:00:00	DIA	ETF	155.78	155.8	155.08	155.1	830719.0
2013-11-01 12:00:00	DIA	ETF	155.09	155.43	155.08	155.33	651198.0

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

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