PREVIEW / etf_30min / 2013-08-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-02.parquet
  size:    317 KB
  rows:    10,738

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-08-02 04:00:00	SPY	ETF	170.64	170.65	170.59	170.65	4420.0
2013-08-02 04:30:00	SPY	ETF	170.65	170.65	170.65	170.65	150.0
2013-08-02 05:00:00	SPY	ETF	170.61	170.61	170.58	170.58	8000.0
2013-08-02 05:30:00	SPY	ETF	170.54	170.59	170.54	170.54	1700.0
2013-08-02 06:00:00	SPY	ETF	170.59	170.64	170.59	170.64	1600.0
2013-08-02 06:30:00	SPY	ETF	170.64	170.72	170.63	170.63	13550.0
2013-08-02 07:00:00	SPY	ETF	170.62	170.72	170.58	170.69	20500.0
2013-08-02 07:30:00	SPY	ETF	170.7	170.71	170.63	170.67	58100.0
2013-08-02 08:00:00	SPY	ETF	170.62	170.91	170.62	170.81	260025.0
2013-08-02 08:30:00	SPY	ETF	170.81	170.84	170.07	170.28	2926036.0
2013-08-02 09:00:00	SPY	ETF	170.28	170.6886	170.11	170.27	1866015.0
2013-08-02 09:30:00	SPY	ETF	170.28	170.39	170.05	170.22	12477792.0
2013-08-02 10:00:00	SPY	ETF	170.22	170.53	170.12	170.48	7572174.0
2013-08-02 10:30:00	SPY	ETF	170.49	170.53	170.21	170.24	6555226.0
2013-08-02 11:00:00	SPY	ETF	170.25	170.42	170.12	170.39	5501766.0
2013-08-02 11:30:00	SPY	ETF	170.4	170.51	170.37	170.44	3563571.0
2013-08-02 12:00:00	SPY	ETF	170.45	170.54	170.425	170.5	2796964.0
2013-08-02 12:30:00	SPY	ETF	170.5	170.68	170.46	170.63	3362640.0
2013-08-02 13:00:00	SPY	ETF	170.63	170.73	170.51	170.611	3206953.0
2013-08-02 13:30:00	SPY	ETF	170.61	170.64	170.48	170.525	2551197.0
2013-08-02 14:00:00	SPY	ETF	170.523	170.645	170.52	170.5749	2131751.0
2013-08-02 14:30:00	SPY	ETF	170.5712	170.695	170.44	170.62	3339522.0
2013-08-02 15:00:00	SPY	ETF	170.62	170.76	170.58	170.735	3090752.0
2013-08-02 15:30:00	SPY	ETF	170.74	170.96	170.69	170.93	13959994.0
2013-08-02 16:00:00	SPY	ETF	170.92	170.9736	170.83	170.88	6777643.0
2013-08-02 16:30:00	SPY	ETF	170.88	170.9727	170.513	170.82	1832324.0
2013-08-02 17:00:00	SPY	ETF	170.82	170.85	170.8	170.83	18710.0
2013-08-02 17:30:00	SPY	ETF	170.83	170.88	170.72	170.8	88028.0
2013-08-02 18:00:00	SPY	ETF	170.82	170.89	170.81	170.85	3715.0
2013-08-02 18:30:00	SPY	ETF	170.89	170.99	170.87	170.87	31875.0
2013-08-02 19:00:00	SPY	ETF	170.9	170.9	170.85	170.85	850.0
2013-08-02 19:30:00	SPY	ETF	170.86	170.89	170.85	170.89	7066.0
2013-08-02 05:30:00	QQQ	ETF	76.51	76.53	76.51	76.53	1600.0
2013-08-02 06:00:00	QQQ	ETF	76.55	76.55	76.55	76.55	500.0
2013-08-02 06:30:00	QQQ	ETF	76.59	76.59	76.57	76.57	2000.0
2013-08-02 07:00:00	QQQ	ETF	76.59	76.6	76.57	76.57	28711.0
2013-08-02 07:30:00	QQQ	ETF	76.57	76.59	76.57	76.59	550.0
2013-08-02 08:00:00	QQQ	ETF	76.57	76.76	76.57	76.74	622522.0
2013-08-02 08:30:00	QQQ	ETF	76.6821	76.73	76.47	76.58	1651675.0
2013-08-02 09:00:00	QQQ	ETF	76.57	76.64	76.53	76.57	182242.0
2013-08-02 09:30:00	QQQ	ETF	76.57	76.5995	76.3801	76.47	2252297.0
2013-08-02 10:00:00	QQQ	ETF	76.46	76.66	76.43	76.66	1161454.0
2013-08-02 10:30:00	QQQ	ETF	76.66	76.7	76.52	76.52	1156582.0
2013-08-02 11:00:00	QQQ	ETF	76.53	76.63	76.48	76.62	874140.0
2013-08-02 11:30:00	QQQ	ETF	76.6201	76.66	76.59	76.63	492035.0
2013-08-02 12:00:00	QQQ	ETF	76.631	76.69	76.62	76.6699	582003.0
2013-08-02 12:30:00	QQQ	ETF	76.665	76.74	76.651	76.74	574856.0
2013-08-02 13:00:00	QQQ	ETF	76.735	76.83	76.68	76.78	710993.0
2013-08-02 13:30:00	QQQ	ETF	76.7799	76.79	76.69	76.7499	515845.0
2013-08-02 14:00:00	QQQ	ETF	76.7463	76.79	76.74	76.77	568754.0

> showing 50 of 10,738 rows — these rows as CSV

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