PREVIEW / etf_30min / 2013-04-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-01.parquet
  size:    311 KB
  rows:    10,630

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-04-01 04:00:00	SPY	ETF	156.64	156.64	156.39	156.39	2350.0
2013-04-01 04:30:00	SPY	ETF	156.39	156.44	156.39	156.42	1170.0
2013-04-01 05:00:00	SPY	ETF	156.42	156.46	156.4	156.44	3280.0
2013-04-01 05:30:00	SPY	ETF	156.42	156.42	156.38	156.41	1500.0
2013-04-01 06:00:00	SPY	ETF	156.42	156.47	156.42	156.47	1000.0
2013-04-01 06:30:00	SPY	ETF	156.53	156.61	156.53	156.59	10380.0
2013-04-01 07:00:00	SPY	ETF	156.57	156.71	156.57	156.67	18972.0
2013-04-01 07:30:00	SPY	ETF	156.67	156.81	156.67	156.69	196159.0
2013-04-01 08:00:00	SPY	ETF	156.69	156.77	156.38	156.74	717115.0
2013-04-01 08:30:00	SPY	ETF	156.74	156.74	156.62	156.67	214111.0
2013-04-01 09:00:00	SPY	ETF	156.66	156.68	156.54	156.58	869409.0
2013-04-01 09:30:00	SPY	ETF	156.59	156.91	156.54	156.61	7895578.0
2013-04-01 10:00:00	SPY	ETF	156.6	156.72	156.17	156.4625	16508937.0
2013-04-01 10:30:00	SPY	ETF	156.4601	156.47	155.86	155.86	8739171.0
2013-04-01 11:00:00	SPY	ETF	155.86	155.97	155.75	155.95	6820534.0
2013-04-01 11:30:00	SPY	ETF	155.94	156.1	155.89	155.995	3918826.0
2013-04-01 12:00:00	SPY	ETF	155.97	156.03	155.805	155.9	2558541.0
2013-04-01 12:30:00	SPY	ETF	155.905	156.08	155.819	156.07	2721324.0
2013-04-01 13:00:00	SPY	ETF	156.06	156.26	156.03	156.23	3742330.0
2013-04-01 13:30:00	SPY	ETF	156.23	156.26	156.04	156.09	2830928.0
2013-04-01 14:00:00	SPY	ETF	156.09	156.22	156.02	156.05	2936825.0
2013-04-01 14:30:00	SPY	ETF	156.05	156.09	155.89	155.95	3595826.0
2013-04-01 15:00:00	SPY	ETF	155.94	156.04	155.7	155.8	7601925.0
2013-04-01 15:30:00	SPY	ETF	155.8	156.07	155.67	156.06	13082450.0
2013-04-01 16:00:00	SPY	ETF	156.06	156.0963	155.91	155.97	6341154.0
2013-04-01 16:30:00	SPY	ETF	156.0	156.05	155.95	156.0	2416458.0
2013-04-01 17:00:00	SPY	ETF	156.01	156.08	156.01	156.03	44888.0
2013-04-01 17:30:00	SPY	ETF	156.03	156.03	156.01	156.03	17925.0
2013-04-01 18:00:00	SPY	ETF	156.04	156.09	156.02	156.07	22050.0
2013-04-01 18:30:00	SPY	ETF	156.03	156.03	155.99	155.99	11550.0
2013-04-01 19:00:00	SPY	ETF	156.01	156.02	156.0	156.02	690.0
2013-04-01 19:30:00	SPY	ETF	156.05	156.1	156.05	156.09	13260.0
2013-04-01 04:00:00	QQQ	ETF	68.92	68.92	68.92	68.92	200.0
2013-04-01 04:30:00	QQQ	ETF	68.87	68.87	68.87	68.87	1000.0
2013-04-01 05:00:00	QQQ	ETF	68.9	68.9	68.9	68.9	300.0
2013-04-01 07:00:00	QQQ	ETF	69.0	69.03	69.0	69.03	5000.0
2013-04-01 07:30:00	QQQ	ETF	69.08	69.08	69.05	69.05	900.0
2013-04-01 08:00:00	QQQ	ETF	69.01	69.08	69.01	69.06	20100.0
2013-04-01 08:30:00	QQQ	ETF	69.05	69.07	69.04	69.06	26980.0
2013-04-01 09:00:00	QQQ	ETF	69.06	69.08	69.01	69.01	42356.0
2013-04-01 09:30:00	QQQ	ETF	69.01	69.09	68.98	68.98	2558797.0
2013-04-01 10:00:00	QQQ	ETF	68.99	69.02	68.75	68.87	5086615.0
2013-04-01 10:30:00	QQQ	ETF	68.8799	68.8799	68.59	68.59	2439054.0
2013-04-01 11:00:00	QQQ	ETF	68.58	68.6452	68.51	68.635	1950449.0
2013-04-01 11:30:00	QQQ	ETF	68.632	68.74	68.62	68.68	1353636.0
2013-04-01 12:00:00	QQQ	ETF	68.67	68.67	68.505	68.57	797049.0
2013-04-01 12:30:00	QQQ	ETF	68.57	68.63	68.51	68.615	594263.0
2013-04-01 13:00:00	QQQ	ETF	68.62	68.71	68.6	68.69	872466.0
2013-04-01 13:30:00	QQQ	ETF	68.6899	68.72	68.59	68.6	850296.0
2013-04-01 14:00:00	QQQ	ETF	68.61	68.678	68.54	68.56	1110445.0

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

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