PREVIEW / etf_30min / 2011-06-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-08.parquet
  size:    287 KB
  rows:    9,539

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-06-08 04:00:00	SPY	ETF	128.61	128.76	128.4	128.52	7450.0
2011-06-08 04:30:00	SPY	ETF	128.51	128.59	128.47	128.59	700.0
2011-06-08 05:00:00	SPY	ETF	128.59	128.61	128.51	128.51	2200.0
2011-06-08 05:30:00	SPY	ETF	128.59	128.7	128.59	128.7	15450.0
2011-06-08 06:00:00	SPY	ETF	128.61	128.66	128.42	128.45	23550.0
2011-06-08 06:30:00	SPY	ETF	128.4	128.46	128.2	128.34	70400.0
2011-06-08 07:00:00	SPY	ETF	128.35	128.49	128.31	128.4	181143.0
2011-06-08 07:30:00	SPY	ETF	128.37	128.44	128.3	128.43	235960.0
2011-06-08 08:00:00	SPY	ETF	128.45	128.65	128.35	128.45	569022.0
2011-06-08 08:30:00	SPY	ETF	128.45	128.71	128.4	128.67	1146520.0
2011-06-08 09:00:00	SPY	ETF	128.65	128.8	128.56	128.76	2325825.0
2011-06-08 09:30:00	SPY	ETF	128.76	129.07	128.43	128.5	21114388.0
2011-06-08 10:00:00	SPY	ETF	128.5	128.95	128.47	128.81	18812218.0
2011-06-08 10:30:00	SPY	ETF	128.82	129.05	128.6	128.91	11932598.0
2011-06-08 11:00:00	SPY	ETF	128.92	129.19	128.62	128.67	12975925.0
2011-06-08 11:30:00	SPY	ETF	128.665	129.05	128.64	129.04	9373268.0
2011-06-08 12:00:00	SPY	ETF	129.05	129.14	128.69	128.78	8375667.0
2011-06-08 12:30:00	SPY	ETF	128.79	129.05	128.69	129.04	6880229.0
2011-06-08 13:00:00	SPY	ETF	129.04	129.12	128.78	128.87	5714848.0
2011-06-08 13:30:00	SPY	ETF	128.87	128.89	128.26	128.42	13415607.0
2011-06-08 14:00:00	SPY	ETF	128.41	128.67	128.24	128.32	14006599.0
2011-06-08 14:30:00	SPY	ETF	128.32	128.89	128.31	128.69	14070069.0
2011-06-08 15:00:00	SPY	ETF	128.69	128.72	128.22	128.31	15742038.0
2011-06-08 15:30:00	SPY	ETF	128.3	128.65	128.18	128.42	25504412.0
2011-06-08 16:00:00	SPY	ETF	128.4	128.9516	128.21	128.27	12185784.0
2011-06-08 16:30:00	SPY	ETF	128.27	128.6821	128.08	128.1	1039779.0
2011-06-08 17:00:00	SPY	ETF	128.1	128.28	128.1	128.26	162235.0
2011-06-08 17:30:00	SPY	ETF	128.25	128.38	128.22	128.38	321646.0
2011-06-08 18:00:00	SPY	ETF	128.38	128.43	128.3	128.38	428028.0
2011-06-08 18:30:00	SPY	ETF	128.38	128.45	128.32	128.44	115143.0
2011-06-08 19:00:00	SPY	ETF	128.43	128.47	128.41	128.44	90909.0
2011-06-08 19:30:00	SPY	ETF	128.47	128.55	128.46	128.5	101054.0
2011-06-08 04:00:00	QQQ	ETF	55.77	55.77	55.54	55.54	700.0
2011-06-08 04:30:00	QQQ	ETF	55.53	55.53	55.53	55.53	100.0
2011-06-08 05:30:00	QQQ	ETF	55.66	55.68	55.66	55.68	15000.0
2011-06-08 06:30:00	QQQ	ETF	55.52	55.57	55.5	55.51	21400.0
2011-06-08 07:00:00	QQQ	ETF	55.51	55.55	55.48	55.5	66300.0
2011-06-08 07:30:00	QQQ	ETF	55.5	55.53	55.47	55.52	94900.0
2011-06-08 08:00:00	QQQ	ETF	55.54	55.56	55.48	55.51	131141.0
2011-06-08 08:30:00	QQQ	ETF	55.51	55.67	55.5	55.64	219159.0
2011-06-08 09:00:00	QQQ	ETF	55.63	55.71	55.6	55.67	283721.0
2011-06-08 09:30:00	QQQ	ETF	55.68	55.77	55.45	55.4967	5502394.0
2011-06-08 10:00:00	QQQ	ETF	55.4901	55.66	55.47	55.5729	3907675.0
2011-06-08 10:30:00	QQQ	ETF	55.58	55.7394	55.49	55.63	2527041.0
2011-06-08 11:00:00	QQQ	ETF	55.64	55.74	55.47	55.48	2427093.0
2011-06-08 11:30:00	QQQ	ETF	55.48	55.67	55.47	55.66	1988851.0
2011-06-08 12:00:00	QQQ	ETF	55.66	55.68	55.495	55.53	2390293.0
2011-06-08 12:30:00	QQQ	ETF	55.525	55.655	55.49	55.655	1716008.0
2011-06-08 13:00:00	QQQ	ETF	55.655	55.68	55.511	55.53	1341930.0
2011-06-08 13:30:00	QQQ	ETF	55.54	55.54	55.23	55.3	3829273.0

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

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