PREVIEW / etf_30min / 2013-10-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-29.parquet
  size:    313 KB
  rows:    10,849

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-10-29 04:00:00	SPY	ETF	176.28	176.42	176.25	176.42	3500.0
2013-10-29 04:30:00	SPY	ETF	176.42	176.56	176.42	176.5	6700.0
2013-10-29 05:00:00	SPY	ETF	176.51	176.52	176.4	176.4	48643.0
2013-10-29 05:30:00	SPY	ETF	176.39	176.39	176.29	176.34	2200.0
2013-10-29 06:00:00	SPY	ETF	176.31	176.44	176.31	176.36	15127.0
2013-10-29 06:30:00	SPY	ETF	176.31	176.37	176.3	176.35	18569.0
2013-10-29 07:00:00	SPY	ETF	176.32	176.53	176.32	176.5	75137.0
2013-10-29 07:30:00	SPY	ETF	176.49	176.6	176.48	176.51	40880.0
2013-10-29 08:00:00	SPY	ETF	176.5	176.56	176.43	176.43	476926.0
2013-10-29 08:30:00	SPY	ETF	176.45	176.63	176.43	176.53	274300.0
2013-10-29 09:00:00	SPY	ETF	176.52	176.69	176.5	176.62	522762.0
2013-10-29 09:30:00	SPY	ETF	176.63	176.87	176.5	176.59	11174559.0
2013-10-29 10:00:00	SPY	ETF	176.59	176.7	176.38	176.67	6912315.0
2013-10-29 10:30:00	SPY	ETF	176.67	176.81	176.44	176.46	5152515.0
2013-10-29 11:00:00	SPY	ETF	176.46	176.77	176.44	176.69	4302361.0
2013-10-29 11:30:00	SPY	ETF	176.691	176.72	176.53	176.68	3401806.0
2013-10-29 12:00:00	SPY	ETF	176.69	176.9702	176.66	176.93	5106732.0
2013-10-29 12:30:00	SPY	ETF	176.93	177.03	176.85	176.94	3310938.0
2013-10-29 13:00:00	SPY	ETF	176.94	177.08	176.83	176.85	3211816.0
2013-10-29 13:30:00	SPY	ETF	176.84	176.96	176.84	176.93	2816078.0
2013-10-29 14:00:00	SPY	ETF	176.93	177.05	176.9	176.97	4236554.0
2013-10-29 14:30:00	SPY	ETF	176.97	177.07	176.955	177.01	5107760.0
2013-10-29 15:00:00	SPY	ETF	177.01	177.03	176.82	176.925	4501549.0
2013-10-29 15:30:00	SPY	ETF	176.93	177.23	176.79	177.22	11298684.0
2013-10-29 16:00:00	SPY	ETF	177.22	177.25	176.1792	177.21	8216955.0
2013-10-29 16:30:00	SPY	ETF	177.22	177.27	176.1801	177.25	2572144.0
2013-10-29 17:00:00	SPY	ETF	177.24	177.32	177.22	177.29	186566.0
2013-10-29 17:30:00	SPY	ETF	177.3	177.33	177.29	177.3	16600.0
2013-10-29 18:00:00	SPY	ETF	177.29	177.29	177.21	177.21	13222.0
2013-10-29 18:30:00	SPY	ETF	177.23	177.27	177.17	177.17	66775.0
2013-10-29 19:00:00	SPY	ETF	177.18	177.19	177.13	177.16	22033.0
2013-10-29 19:30:00	SPY	ETF	177.18	177.2	177.16	177.17	53642.0
2013-10-29 04:00:00	QQQ	ETF	82.9	83.0	82.89	82.99	20046.0
2013-10-29 04:30:00	QQQ	ETF	83.0	83.09	83.0	83.06	14900.0
2013-10-29 05:00:00	QQQ	ETF	83.07	83.07	83.01	83.01	46000.0
2013-10-29 05:30:00	QQQ	ETF	83.0	83.0	82.98	83.0	14900.0
2013-10-29 06:00:00	QQQ	ETF	82.99	83.06	82.98	83.01	9000.0
2013-10-29 06:30:00	QQQ	ETF	83.02	83.05	83.02	83.04	6200.0
2013-10-29 07:00:00	QQQ	ETF	83.03	83.08	83.02	83.07	40800.0
2013-10-29 07:30:00	QQQ	ETF	83.06	83.15	83.06	83.13	78648.0
2013-10-29 08:00:00	QQQ	ETF	83.13	83.14	83.06	83.08	161482.0
2013-10-29 08:30:00	QQQ	ETF	83.07	83.13	83.07	83.09	72407.0
2013-10-29 09:00:00	QQQ	ETF	83.1	83.22	83.1	83.18	154268.0
2013-10-29 09:30:00	QQQ	ETF	83.17	83.26	82.8202	82.87	5104225.0
2013-10-29 10:00:00	QQQ	ETF	82.8763	82.9925	82.7	82.93	5312459.0
2013-10-29 10:30:00	QQQ	ETF	82.93	83.03	82.76	82.79	2916318.0
2013-10-29 11:00:00	QQQ	ETF	82.78	83.0	82.77	82.95	2631061.0
2013-10-29 11:30:00	QQQ	ETF	82.945	82.945	82.72	82.89	3786335.0
2013-10-29 12:00:00	QQQ	ETF	82.895	83.09	82.88	83.07	2385382.0
2013-10-29 12:30:00	QQQ	ETF	83.06	83.1377	82.9848	83.0958	962991.0

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

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