PREVIEW / etf_30min / 2011-04-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-07.parquet
  size:    276 KB
  rows:    9,156

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
2011-04-07 04:00:00	SPY	ETF	133.36	133.38	133.35	133.38	400.0
2011-04-07 04:30:00	SPY	ETF	133.39	133.4	133.38	133.4	700.0
2011-04-07 05:00:00	SPY	ETF	133.38	133.38	133.36	133.36	5980.0
2011-04-07 05:30:00	SPY	ETF	133.32	133.32	133.27	133.27	6900.0
2011-04-07 06:00:00	SPY	ETF	133.34	133.34	133.22	133.22	24100.0
2011-04-07 06:30:00	SPY	ETF	133.22	133.31	133.2	133.27	26150.0
2011-04-07 07:00:00	SPY	ETF	133.28	133.41	133.27	133.4	131732.0
2011-04-07 07:30:00	SPY	ETF	133.39	133.56	133.35	133.55	224509.0
2011-04-07 08:00:00	SPY	ETF	133.57	133.69	133.51	133.53	954297.0
2011-04-07 08:30:00	SPY	ETF	133.53	133.66	133.35	133.39	1132066.0
2011-04-07 09:00:00	SPY	ETF	133.38	133.44	133.26	133.41	929419.0
2011-04-07 09:30:00	SPY	ETF	133.42	133.9	133.38	133.865	14379079.0
2011-04-07 10:00:00	SPY	ETF	133.87	133.94	133.65	133.66	6900682.0
2011-04-07 10:30:00	SPY	ETF	133.66	133.69	132.66	133.34	37815398.0
2011-04-07 11:00:00	SPY	ETF	133.349	133.47	133.13	133.2299	16156775.0
2011-04-07 11:30:00	SPY	ETF	133.22	133.28	132.74	133.26	16620047.0
2011-04-07 12:00:00	SPY	ETF	133.25	133.45	133.18	133.32	10174130.0
2011-04-07 12:30:00	SPY	ETF	133.3267	133.63	133.31	133.52	6743872.0
2011-04-07 13:00:00	SPY	ETF	133.52	133.53	133.16	133.17	6232091.0
2011-04-07 13:30:00	SPY	ETF	133.17	133.2799	132.95	133.075	7307078.0
2011-04-07 14:00:00	SPY	ETF	133.08	133.19	132.96	132.96	5000792.0
2011-04-07 14:30:00	SPY	ETF	132.97	133.29	132.96	133.26	8221760.0
2011-04-07 15:00:00	SPY	ETF	133.25	133.37	133.08	133.17	7438150.0
2011-04-07 15:30:00	SPY	ETF	133.17	133.41	133.08	133.36	19212548.0
2011-04-07 16:00:00	SPY	ETF	133.36	133.4066	133.24	133.25	4301617.0
2011-04-07 16:30:00	SPY	ETF	133.26	133.35	133.26	133.28	371644.0
2011-04-07 17:00:00	SPY	ETF	133.28	133.38	133.28	133.37	43704.0
2011-04-07 17:30:00	SPY	ETF	133.33	133.38	133.32	133.35	17362.0
2011-04-07 18:00:00	SPY	ETF	133.35	133.42	133.29	133.3	91960.0
2011-04-07 18:30:00	SPY	ETF	133.29	133.3	133.24	133.27	16212.0
2011-04-07 19:00:00	SPY	ETF	133.3	133.31	133.28	133.28	3800.0
2011-04-07 19:30:00	SPY	ETF	133.28	133.36	133.28	133.31	24818.0
2011-04-07 05:00:00	QQQ	ETF	57.08	57.08	57.08	57.08	700.0
2011-04-07 05:30:00	QQQ	ETF	57.08	57.08	57.08	57.08	400.0
2011-04-07 06:30:00	QQQ	ETF	57.09	57.09	57.09	57.09	800.0
2011-04-07 07:00:00	QQQ	ETF	57.14	57.18	57.12	57.12	2590.0
2011-04-07 07:30:00	QQQ	ETF	57.15	57.24	57.12	57.24	127683.0
2011-04-07 08:00:00	QQQ	ETF	57.22	57.29	57.22	57.25	2228368.0
2011-04-07 08:30:00	QQQ	ETF	57.26	57.28	57.17	57.18	500493.0
2011-04-07 09:00:00	QQQ	ETF	57.17	57.25	57.13	57.23	1671143.0
2011-04-07 09:30:00	QQQ	ETF	57.23	57.6	57.19	57.54	7991267.0
2011-04-07 10:00:00	QQQ	ETF	57.5425	57.57	57.3608	57.3636	3119138.0
2011-04-07 10:30:00	QQQ	ETF	57.369	57.38	56.81	57.17	11585637.0
2011-04-07 11:00:00	QQQ	ETF	57.17	57.24	57.11	57.15	4838869.0
2011-04-07 11:30:00	QQQ	ETF	57.16	57.16	56.92	57.16	5369947.0
2011-04-07 12:00:00	QQQ	ETF	57.16	57.35	57.11	57.283	4675009.0
2011-04-07 12:30:00	QQQ	ETF	57.28	57.48	57.2799	57.43	2870947.0
2011-04-07 13:00:00	QQQ	ETF	57.435	57.44	57.19	57.2	2073456.0
2011-04-07 13:30:00	QQQ	ETF	57.201	57.22	57.06	57.15	2822804.0
2011-04-07 14:00:00	QQQ	ETF	57.16	57.21	57.08	57.08	1494927.0

> showing 50 of 9,156 rows — these rows as CSV

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