PREVIEW / etf_30min / 2013-11-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-01.parquet
  size:    323 KB
  rows:    11,053

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-11-01 04:00:00	SPY	ETF	175.9	175.9	175.73	175.78	341000.0
2013-11-01 04:30:00	SPY	ETF	175.83	175.88	175.75	175.78	8000.0
2013-11-01 05:00:00	SPY	ETF	175.83	175.83	175.74	175.83	9179.0
2013-11-01 05:30:00	SPY	ETF	175.8	175.83	175.8	175.82	900.0
2013-11-01 06:00:00	SPY	ETF	175.8	175.89	175.78	175.8	40900.0
2013-11-01 06:30:00	SPY	ETF	175.75	175.82	175.68	175.82	38300.0
2013-11-01 07:00:00	SPY	ETF	175.83	175.93	175.81	175.93	29644.0
2013-11-01 07:30:00	SPY	ETF	175.93	175.98	175.83	175.92	187809.0
2013-11-01 08:00:00	SPY	ETF	175.9	176.03	175.73	175.99	177754.0
2013-11-01 08:30:00	SPY	ETF	176.0	176.09	175.94	175.97	513049.0
2013-11-01 09:00:00	SPY	ETF	175.99	176.04	175.89	176.03	446114.0
2013-11-01 09:30:00	SPY	ETF	176.02	176.38	176.0	176.24	13107578.0
2013-11-01 10:00:00	SPY	ETF	176.26	176.61	175.7597	175.91	14151188.0
2013-11-01 10:30:00	SPY	ETF	175.91	176.17	175.84	176.1	7012806.0
2013-11-01 11:00:00	SPY	ETF	176.105	176.13	175.32	175.6	10495082.0
2013-11-01 11:30:00	SPY	ETF	175.595	175.7	175.27	175.3	7229368.0
2013-11-01 12:00:00	SPY	ETF	175.3	175.6	175.22	175.53	7638885.0
2013-11-01 12:30:00	SPY	ETF	175.52	175.69	175.51	175.57	3930437.0
2013-11-01 13:00:00	SPY	ETF	175.56	175.6	175.38	175.59	3866732.0
2013-11-01 13:30:00	SPY	ETF	175.59	175.95	175.48	175.91	6040974.0
2013-11-01 14:00:00	SPY	ETF	175.91	176.0	175.83	175.8799	4196395.0
2013-11-01 14:30:00	SPY	ETF	175.88	175.985	175.75	175.83	5103744.0
2013-11-01 15:00:00	SPY	ETF	175.83	176.11	175.8	176.035	9501033.0
2013-11-01 15:30:00	SPY	ETF	176.035	176.42	175.96	176.15	19950240.0
2013-11-01 16:00:00	SPY	ETF	176.15	176.26	175.6536	175.94	5418229.0
2013-11-01 16:30:00	SPY	ETF	175.94	176.21	175.6542	175.95	4347094.0
2013-11-01 17:00:00	SPY	ETF	175.96	176.02	175.95	175.96	9242128.0
2013-11-01 17:30:00	SPY	ETF	175.98	175.98	175.93	175.93	510163.0
2013-11-01 18:00:00	SPY	ETF	175.97	176.01	175.97	176.01	10200.0
2013-11-01 18:30:00	SPY	ETF	176.0	176.0	176.0	176.0	2350.0
2013-11-01 19:00:00	SPY	ETF	175.98	175.98	175.91	175.92	2200.0
2013-11-01 19:30:00	SPY	ETF	175.96	176.0	175.91	176.0	14884.0
2013-11-01 04:00:00	QQQ	ETF	82.85	82.85	82.78	82.82	4500.0
2013-11-01 04:30:00	QQQ	ETF	82.86	82.86	82.84	82.84	5600.0
2013-11-01 05:00:00	QQQ	ETF	82.86	82.86	82.84	82.86	4200.0
2013-11-01 05:30:00	QQQ	ETF	82.89	82.89	82.87	82.89	4300.0
2013-11-01 06:00:00	QQQ	ETF	82.87	82.89	82.87	82.87	5800.0
2013-11-01 06:30:00	QQQ	ETF	82.84	82.86	82.84	82.86	27600.0
2013-11-01 07:00:00	QQQ	ETF	82.89	82.94	82.89	82.94	5600.0
2013-11-01 07:30:00	QQQ	ETF	82.9	82.95	82.9	82.93	54100.0
2013-11-01 08:00:00	QQQ	ETF	82.95	82.98	82.78	82.97	44500.0
2013-11-01 08:30:00	QQQ	ETF	82.98	83.01	82.98	83.0	45090.0
2013-11-01 09:00:00	QQQ	ETF	82.99	83.05	82.95	83.04	279526.0
2013-11-01 09:30:00	QQQ	ETF	83.04	83.13	82.99	83.05	3269405.0
2013-11-01 10:00:00	QQQ	ETF	83.06	83.169	82.69	82.8	5063844.0
2013-11-01 10:30:00	QQQ	ETF	82.8	82.94	82.76	82.885	1706671.0
2013-11-01 11:00:00	QQQ	ETF	82.87	82.885	82.48	82.62	3765089.0
2013-11-01 11:30:00	QQQ	ETF	82.625	82.69	82.45	82.48	1506322.0
2013-11-01 12:00:00	QQQ	ETF	82.47	82.73	82.45	82.67	2373157.0
2013-11-01 12:30:00	QQQ	ETF	82.665	82.72	82.58	82.59	714974.0

> showing 50 of 11,053 rows — these rows as CSV

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