PREVIEW / etf_30min / 2013-05-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-01.parquet
  size:    321 KB
  rows:    10,697

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-05-01 04:30:00	SPY	ETF	159.87	159.9	159.87	159.9	200.0
2013-05-01 05:00:00	SPY	ETF	159.97	159.98	159.86	159.86	2400.0
2013-05-01 05:30:00	SPY	ETF	159.86	159.95	159.86	159.89	6300.0
2013-05-01 06:00:00	SPY	ETF	159.86	159.86	159.84	159.84	4700.0
2013-05-01 06:30:00	SPY	ETF	159.82	159.93	159.82	159.92	28476.0
2013-05-01 07:00:00	SPY	ETF	159.93	159.96	159.82	159.86	60555.0
2013-05-01 07:30:00	SPY	ETF	159.85	160.0	159.83	159.83	48120.0
2013-05-01 08:00:00	SPY	ETF	159.85	160.08	159.42	159.74	711538.0
2013-05-01 08:30:00	SPY	ETF	159.75	159.75	159.44	159.48	1009964.0
2013-05-01 09:00:00	SPY	ETF	159.5	159.68	159.29	159.33	955126.0
2013-05-01 09:30:00	SPY	ETF	159.33	159.41	159.08	159.17	13097766.0
2013-05-01 10:00:00	SPY	ETF	159.17	159.4	158.77	158.945	15600692.0
2013-05-01 10:30:00	SPY	ETF	158.94	159.26	158.87	159.25	6727956.0
2013-05-01 11:00:00	SPY	ETF	159.25	159.32	159.13	159.19	4677634.0
2013-05-01 11:30:00	SPY	ETF	159.19	159.27	158.98	159.23	4603818.0
2013-05-01 12:00:00	SPY	ETF	159.2202	159.25	159.01	159.15	3049762.0
2013-05-01 12:30:00	SPY	ETF	159.16	159.16	158.83	158.851	3560092.0
2013-05-01 13:00:00	SPY	ETF	158.855	158.885	158.62	158.84	6523243.0
2013-05-01 13:30:00	SPY	ETF	158.839	158.85	158.45	158.648	9030812.0
2013-05-01 14:00:00	SPY	ETF	158.64	159.11	158.6	158.95	11775203.0
2013-05-01 14:30:00	SPY	ETF	158.955	159.01	158.66	158.88	6771337.0
2013-05-01 15:00:00	SPY	ETF	158.87	158.9	158.22	158.27	9670304.0
2013-05-01 15:30:00	SPY	ETF	158.26	158.44	158.1	158.2725	17348623.0
2013-05-01 16:00:00	SPY	ETF	158.31	159.7496	158.15	158.2	15695521.0
2013-05-01 16:30:00	SPY	ETF	158.21	159.7496	158.21	158.34	4680131.0
2013-05-01 17:00:00	SPY	ETF	158.34	158.39	158.34	158.37	58792.0
2013-05-01 17:30:00	SPY	ETF	158.36	158.41	158.36	158.41	123378.0
2013-05-01 18:00:00	SPY	ETF	158.42	158.51	158.4	158.43	47965.0
2013-05-01 18:30:00	SPY	ETF	158.42	158.55	158.41	158.55	15890.0
2013-05-01 19:00:00	SPY	ETF	158.5	158.52	158.46	158.46	10924.0
2013-05-01 19:30:00	SPY	ETF	158.46	158.46	158.38	158.42	26720.0
2013-05-01 04:30:00	QQQ	ETF	70.77	70.77	70.77	70.77	200.0
2013-05-01 07:00:00	QQQ	ETF	70.73	70.74	70.73	70.74	1300.0
2013-05-01 07:30:00	QQQ	ETF	70.77	70.8	70.77	70.77	18900.0
2013-05-01 08:00:00	QQQ	ETF	70.73	70.79	70.73	70.775	31020.0
2013-05-01 08:30:00	QQQ	ETF	70.78	70.81	70.69	70.69	63321.0
2013-05-01 09:00:00	QQQ	ETF	70.7	70.72	70.66	70.72	84025.0
2013-05-01 09:30:00	QQQ	ETF	70.72	70.85	70.61	70.662	3725472.0
2013-05-01 10:00:00	QQQ	ETF	70.67	70.75	70.41	70.47	2612820.0
2013-05-01 10:30:00	QQQ	ETF	70.46	70.655	70.39	70.64	1926306.0
2013-05-01 11:00:00	QQQ	ETF	70.64	70.69	70.56	70.63	895159.0
2013-05-01 11:30:00	QQQ	ETF	70.62	70.71	70.53	70.67	1069660.0
2013-05-01 12:00:00	QQQ	ETF	70.662	70.69	70.59	70.63	710982.0
2013-05-01 12:30:00	QQQ	ETF	70.6293	70.63	70.49	70.498	621509.0
2013-05-01 13:00:00	QQQ	ETF	70.49	70.495	70.36	70.49	1193084.0
2013-05-01 13:30:00	QQQ	ETF	70.49	70.505	70.33	70.44	1435133.0
2013-05-01 14:00:00	QQQ	ETF	70.44	70.65	70.42	70.59	1718821.0
2013-05-01 14:30:00	QQQ	ETF	70.6	70.63	70.47	70.5999	1066633.0
2013-05-01 15:00:00	QQQ	ETF	70.59	70.63	70.3	70.328	1999892.0
2013-05-01 15:30:00	QQQ	ETF	70.31	70.42	70.25	70.41	2830294.0

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

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