PREVIEW / etf_1hour / 2013-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-28.parquet
  size:    207 KB
  rows:    6,675

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-10-28 04:00:00	SPY	ETF	175.89	176.35	175.79	176.24	46132.0
2013-10-28 05:00:00	SPY	ETF	176.26	176.3	176.24	176.28	5419.0
2013-10-28 06:00:00	SPY	ETF	176.28	176.32	176.09	176.09	127918.0
2013-10-28 07:00:00	SPY	ETF	176.08	176.14	175.97	176.05	212807.0
2013-10-28 08:00:00	SPY	ETF	175.93	176.06	175.67	175.81	706593.0
2013-10-28 09:00:00	SPY	ETF	175.81	176.065	175.72	175.93	10917282.0
2013-10-28 10:00:00	SPY	ETF	175.93	176.27	175.7	175.77	12393072.0
2013-10-28 11:00:00	SPY	ETF	175.78	176.12	175.71	176.1	8356203.0
2013-10-28 12:00:00	SPY	ETF	176.09	176.38	176.06	176.34	6409240.0
2013-10-28 13:00:00	SPY	ETF	176.34	176.38	176.21	176.265	4562344.0
2013-10-28 14:00:00	SPY	ETF	176.27	176.47	176.21	176.42	6073737.0
2013-10-28 15:00:00	SPY	ETF	176.43	176.43	175.92	176.21	22535904.0
2013-10-28 16:00:00	SPY	ETF	176.22	176.48	175.937	176.25	7838204.0
2013-10-28 17:00:00	SPY	ETF	176.25	176.43	176.21	176.4	174955.0
2013-10-28 18:00:00	SPY	ETF	176.37	176.37	176.11	176.18	165669.0
2013-10-28 19:00:00	SPY	ETF	176.16	176.19	176.1	176.16	81673.0
2013-10-28 04:00:00	QQQ	ETF	83.1	83.1	83.02	83.05	29880.0
2013-10-28 05:00:00	QQQ	ETF	83.06	83.13	83.06	83.12	10400.0
2013-10-28 06:00:00	QQQ	ETF	83.13	83.14	83.01	83.01	18065.0
2013-10-28 07:00:00	QQQ	ETF	83.02	83.02	82.94	83.0	27425.0
2013-10-28 08:00:00	QQQ	ETF	83.0	83.01	82.82	82.88	128483.0
2013-10-28 09:00:00	QQQ	ETF	82.89	82.95	82.71	82.8	3436640.0
2013-10-28 10:00:00	QQQ	ETF	82.79	82.97	82.55	82.62	4096748.0
2013-10-28 11:00:00	QQQ	ETF	82.61	82.79	82.56	82.76	2348323.0
2013-10-28 12:00:00	QQQ	ETF	82.76	83.019	82.74	82.99	2363255.0
2013-10-28 13:00:00	QQQ	ETF	83.0	83.0101	82.91	82.96	1544845.0
2013-10-28 14:00:00	QQQ	ETF	82.96	83.05	82.91	83.0	1687713.0
2013-10-28 15:00:00	QQQ	ETF	83.005	83.01	82.695	82.91	5618424.0
2013-10-28 16:00:00	QQQ	ETF	82.9	83.33	82.48	82.73	4540078.0
2013-10-28 17:00:00	QQQ	ETF	82.7	82.97	82.66	82.86	1428299.0
2013-10-28 18:00:00	QQQ	ETF	82.9	82.92	82.79	82.81	50419.0
2013-10-28 19:00:00	QQQ	ETF	82.82	82.83	82.78	82.78	9837.0
2013-10-28 07:00:00	IWM	ETF	111.08	111.08	111.05	111.05	1100.0
2013-10-28 08:00:00	IWM	ETF	111.01	111.04	110.95	111.04	37959.0
2013-10-28 09:00:00	IWM	ETF	111.06	111.21	110.88	111.07	3498369.0
2013-10-28 10:00:00	IWM	ETF	111.07	111.285	110.56	110.66	3234749.0
2013-10-28 11:00:00	IWM	ETF	110.65	110.77	110.46	110.76	3577584.0
2013-10-28 12:00:00	IWM	ETF	110.76	111.15	110.69	111.06	2088918.0
2013-10-28 13:00:00	IWM	ETF	111.06	111.13	110.9	110.95	1009448.0
2013-10-28 14:00:00	IWM	ETF	110.95	111.08	110.92	111.01	1187125.0
2013-10-28 15:00:00	IWM	ETF	111.005	111.06	110.7	111.02	5285029.0
2013-10-28 16:00:00	IWM	ETF	111.02	111.2	110.96	111.12	1893905.0
2013-10-28 17:00:00	IWM	ETF	111.1	111.25	111.0	111.15	84023.0
2013-10-28 18:00:00	IWM	ETF	111.15	111.15	111.13	111.15	127081.0
2013-10-28 19:00:00	IWM	ETF	111.06	111.08	111.04	111.07	16328.0
2013-10-28 08:00:00	DIA	ETF	155.48	155.55	155.1	155.1	4350.0
2013-10-28 09:00:00	DIA	ETF	155.2	155.33	155.03	155.184	596156.0
2013-10-28 10:00:00	DIA	ETF	155.19	155.44	154.99	155.03	920130.0
2013-10-28 11:00:00	DIA	ETF	155.03	155.34	154.99	155.3	686727.0
2013-10-28 12:00:00	DIA	ETF	155.31	155.57	155.29	155.54	575825.0

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

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