PREVIEW / etf_30min / 2013-08-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-29.parquet
  size:    314 KB
  rows:    10,479

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-29 04:00:00	SPY	ETF	163.79	164.32	163.79	164.32	12500.0
2013-08-29 04:30:00	SPY	ETF	164.28	164.28	164.19	164.19	2950.0
2013-08-29 05:00:00	SPY	ETF	164.22	164.26	164.18	164.21	44000.0
2013-08-29 05:30:00	SPY	ETF	164.22	164.23	164.0	164.02	54690.0
2013-08-29 06:00:00	SPY	ETF	164.02	164.03	163.85	163.92	25600.0
2013-08-29 06:30:00	SPY	ETF	163.91	164.05	163.88	164.03	70800.0
2013-08-29 07:00:00	SPY	ETF	164.02	164.25	164.01	164.22	158605.0
2013-08-29 07:30:00	SPY	ETF	164.23	164.43	164.22	164.36	240903.0
2013-08-29 08:00:00	SPY	ETF	164.34	164.42	164.09	164.28	430240.0
2013-08-29 08:30:00	SPY	ETF	164.29	164.43	163.96	164.07	992590.0
2013-08-29 09:00:00	SPY	ETF	164.06	164.07	163.37	163.54	2051189.0
2013-08-29 09:30:00	SPY	ETF	163.55	164.42	163.4	164.22	16347051.0
2013-08-29 10:00:00	SPY	ETF	164.22	164.53	164.19	164.33	8763726.0
2013-08-29 10:30:00	SPY	ETF	164.32	164.97	164.29	164.84	9007387.0
2013-08-29 11:00:00	SPY	ETF	164.841	165.03	164.765	164.98	5798507.0
2013-08-29 11:30:00	SPY	ETF	164.98	165.04	164.88	165.0	4007704.0
2013-08-29 12:00:00	SPY	ETF	165.0	165.03	164.75	164.84	3686847.0
2013-08-29 12:30:00	SPY	ETF	164.83	164.87	164.62	164.77	3077007.0
2013-08-29 13:00:00	SPY	ETF	164.775	164.925	164.5	164.597	3859335.0
2013-08-29 13:30:00	SPY	ETF	164.59	164.6	164.315	164.41	5961213.0
2013-08-29 14:00:00	SPY	ETF	164.41	164.66	164.36	164.57	4272524.0
2013-08-29 14:30:00	SPY	ETF	164.58	164.73	164.56	164.655	3148823.0
2013-08-29 15:00:00	SPY	ETF	164.66	164.68	164.23	164.283	8194053.0
2013-08-29 15:30:00	SPY	ETF	164.29	164.36	164.02	164.17	13279939.0
2013-08-29 16:00:00	SPY	ETF	164.17	164.5	163.8794	164.24	6602872.0
2013-08-29 16:30:00	SPY	ETF	164.24	164.39	163.8794	164.37	14289417.0
2013-08-29 17:00:00	SPY	ETF	164.6689	164.6689	164.38	164.46	2274545.0
2013-08-29 17:30:00	SPY	ETF	164.47	164.48	164.43	164.48	181401.0
2013-08-29 18:00:00	SPY	ETF	164.46	164.5	164.41	164.43	77204.0
2013-08-29 18:30:00	SPY	ETF	164.41	164.47	164.37	164.37	22621.0
2013-08-29 19:00:00	SPY	ETF	164.39	164.43	164.39	164.43	51210.0
2013-08-29 19:30:00	SPY	ETF	164.42	164.47	164.42	164.47	21776.0
2013-08-29 04:00:00	QQQ	ETF	75.62	75.69	75.61	75.69	24800.0
2013-08-29 04:30:00	QQQ	ETF	75.67	75.67	75.65	75.65	2500.0
2013-08-29 05:00:00	QQQ	ETF	75.67	75.67	75.65	75.65	2400.0
2013-08-29 05:30:00	QQQ	ETF	75.63	75.63	75.57	75.57	7700.0
2013-08-29 06:00:00	QQQ	ETF	75.55	75.55	75.49	75.51	8800.0
2013-08-29 06:30:00	QQQ	ETF	75.49	75.58	75.49	75.58	7400.0
2013-08-29 07:00:00	QQQ	ETF	75.59	75.63	75.59	75.62	27190.0
2013-08-29 07:30:00	QQQ	ETF	75.65	75.73	75.65	75.71	15438.0
2013-08-29 08:00:00	QQQ	ETF	75.69	75.72	75.57	75.66	59390.0
2013-08-29 08:30:00	QQQ	ETF	75.67	75.73	75.55	75.6	75600.0
2013-08-29 09:00:00	QQQ	ETF	75.6	75.6	75.35	75.41	554298.0
2013-08-29 09:30:00	QQQ	ETF	75.41	75.94	75.3	75.85	4526393.0
2013-08-29 10:00:00	QQQ	ETF	75.86	76.05	75.86	75.95	2069506.0
2013-08-29 10:30:00	QQQ	ETF	75.96	76.29	75.94	76.18	2626427.0
2013-08-29 11:00:00	QQQ	ETF	76.19	76.31	76.171	76.28	1669077.0
2013-08-29 11:30:00	QQQ	ETF	76.29	76.33	76.24	76.3299	1874147.0
2013-08-29 12:00:00	QQQ	ETF	76.33	76.34	76.18	76.2228	1139011.0
2013-08-29 12:30:00	QQQ	ETF	76.22	76.24	76.12	76.2	897484.0

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

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