PREVIEW / etf_1hour / 2013-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-31.parquet
  size:    218 KB
  rows:    6,880

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-12-31 04:00:00	SPY	ETF	183.81	183.82	183.81	183.82	1000.0
2013-12-31 05:00:00	SPY	ETF	183.82	183.82	183.82	183.82	160.0
2013-12-31 06:00:00	SPY	ETF	183.84	183.84	183.84	183.84	400.0
2013-12-31 07:00:00	SPY	ETF	183.81	183.97	183.76	183.97	84278.0
2013-12-31 08:00:00	SPY	ETF	183.95	184.13	183.94	184.07	486924.0
2013-12-31 09:00:00	SPY	ETF	184.07	184.18	183.97	184.125	5806228.0
2013-12-31 10:00:00	SPY	ETF	184.13	184.34	184.125	184.34	8453025.0
2013-12-31 11:00:00	SPY	ETF	184.34	184.6	184.33	184.42	8448342.0
2013-12-31 12:00:00	SPY	ETF	184.42	184.47	184.27	184.38	5734200.0
2013-12-31 13:00:00	SPY	ETF	184.38	184.41	184.25	184.35	3996294.0
2013-12-31 14:00:00	SPY	ETF	184.36	184.38	183.95	184.075	9220517.0
2013-12-31 15:00:00	SPY	ETF	184.08	184.68	183.93	184.56	28078236.0
2013-12-31 16:00:00	SPY	ETF	184.55	184.89	184.51	184.84	12158450.0
2013-12-31 17:00:00	SPY	ETF	184.83	184.97	184.67	184.89	677168.0
2013-12-31 18:00:00	SPY	ETF	184.9	184.94	184.89	184.9	16200.0
2013-12-31 19:00:00	SPY	ETF	184.91	184.98	184.91	184.98	59346.0
2013-12-31 05:00:00	QQQ	ETF	87.41	87.41	87.41	87.41	400.0
2013-12-31 07:00:00	QQQ	ETF	87.43	87.51	87.43	87.5	7920.0
2013-12-31 08:00:00	QQQ	ETF	87.5	87.555	87.5	87.53	24676.0
2013-12-31 09:00:00	QQQ	ETF	87.53	87.67	87.52	87.65	1867362.0
2013-12-31 10:00:00	QQQ	ETF	87.65	87.81	87.56	87.81	2060301.0
2013-12-31 11:00:00	QQQ	ETF	87.809	87.93	87.78	87.805	3480364.0
2013-12-31 12:00:00	QQQ	ETF	87.82	87.84	87.76	87.8129	2218223.0
2013-12-31 13:00:00	QQQ	ETF	87.82	87.84	87.75	87.8	1572893.0
2013-12-31 14:00:00	QQQ	ETF	87.81	87.83	87.65	87.7001	2327964.0
2013-12-31 15:00:00	QQQ	ETF	87.71	87.96	87.64	87.95	5321354.0
2013-12-31 16:00:00	QQQ	ETF	87.96	88.11	87.564	88.04	1779594.0
2013-12-31 17:00:00	QQQ	ETF	88.03	88.06	87.96	88.06	162794.0
2013-12-31 18:00:00	QQQ	ETF	88.05	88.06	88.03	88.06	2025.0
2013-12-31 19:00:00	QQQ	ETF	88.05	88.05	88.02	88.03	1550.0
2013-12-31 07:00:00	IWM	ETF	115.03	115.23	115.03	115.23	37250.0
2013-12-31 08:00:00	IWM	ETF	115.25	115.38	115.25	115.37	209435.0
2013-12-31 09:00:00	IWM	ETF	115.35	115.5	115.3	115.445	1546271.0
2013-12-31 10:00:00	IWM	ETF	115.44	115.71	115.17	115.54	3872868.0
2013-12-31 11:00:00	IWM	ETF	115.54	115.665	115.42	115.55	3337091.0
2013-12-31 12:00:00	IWM	ETF	115.56	115.71	115.45	115.55	3040417.0
2013-12-31 13:00:00	IWM	ETF	115.55	115.66	115.505	115.6	2492186.0
2013-12-31 14:00:00	IWM	ETF	115.61	115.66	115.37	115.43	3278963.0
2013-12-31 15:00:00	IWM	ETF	115.43	115.62	115.255	115.3	7968130.0
2013-12-31 16:00:00	IWM	ETF	115.29	115.55	115.29	115.48	3062374.0
2013-12-31 17:00:00	IWM	ETF	115.47	115.55	115.47	115.55	10360.0
2013-12-31 18:00:00	IWM	ETF	115.66	115.66	115.47	115.47	1050.0
2013-12-31 19:00:00	IWM	ETF	115.62	115.62	115.6	115.6	300.0
2013-12-31 04:00:00	DIA	ETF	164.69	164.69	164.69	164.69	100.0
2013-12-31 07:00:00	DIA	ETF	164.7	164.72	164.7	164.72	200.0
2013-12-31 08:00:00	DIA	ETF	164.92	164.95	164.92	164.93	1040.0
2013-12-31 09:00:00	DIA	ETF	164.94	165.055	164.84	164.91	611510.0
2013-12-31 10:00:00	DIA	ETF	164.9135	165.075	164.9135	165.03	805729.0
2013-12-31 11:00:00	DIA	ETF	165.025	165.2741	165.025	165.2	872226.0
2013-12-31 12:00:00	DIA	ETF	165.22	165.27	165.11	165.2	524680.0

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

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