PREVIEW / etf_30min / 2014-01-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-30.parquet
  size:    350 KB
  rows:    11,578

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
2014-01-30 04:00:00	SPY	ETF	177.67	177.9	177.53	177.77	37183.0
2014-01-30 04:30:00	SPY	ETF	177.86	178.03	177.85	177.86	14378.0
2014-01-30 05:00:00	SPY	ETF	177.85	178.04	177.83	178.0	32058.0
2014-01-30 05:30:00	SPY	ETF	178.0	178.07	177.84	177.98	173491.0
2014-01-30 06:00:00	SPY	ETF	177.97	178.32	177.9	178.08	146580.0
2014-01-30 06:30:00	SPY	ETF	178.08	178.34	178.08	178.16	37412.0
2014-01-30 07:00:00	SPY	ETF	178.12	178.19	178.0	178.03	342625.0
2014-01-30 07:30:00	SPY	ETF	178.03	178.16	177.96	178.1	282735.0
2014-01-30 08:00:00	SPY	ETF	178.1	178.18	177.83	177.99	495870.0
2014-01-30 08:30:00	SPY	ETF	177.93	178.54	177.79	178.53	2256104.0
2014-01-30 09:00:00	SPY	ETF	178.53	178.9286	178.5	178.86	2336579.0
2014-01-30 09:30:00	SPY	ETF	178.86	178.99	178.46	178.53	14772990.0
2014-01-30 10:00:00	SPY	ETF	178.54	178.81	178.26	178.57	10530769.0
2014-01-30 10:30:00	SPY	ETF	178.58	178.93	178.58	178.78	6312315.0
2014-01-30 11:00:00	SPY	ETF	178.78	179.14	178.64	178.97	6013182.0
2014-01-30 11:30:00	SPY	ETF	178.97	179.66	178.97	179.535	9739460.0
2014-01-30 12:00:00	SPY	ETF	179.53	179.61	179.39	179.4	4648024.0
2014-01-30 12:30:00	SPY	ETF	179.4	179.81	179.39	179.7	5979122.0
2014-01-30 13:00:00	SPY	ETF	179.7	179.7	179.48	179.495	4607061.0
2014-01-30 13:30:00	SPY	ETF	179.49	179.56	179.34	179.39	4217075.0
2014-01-30 14:00:00	SPY	ETF	179.39	179.39	179.09	179.37	5271754.0
2014-01-30 14:30:00	SPY	ETF	179.37	179.51	179.29	179.38	4210997.0
2014-01-30 15:00:00	SPY	ETF	179.38	179.69	179.38	179.59	6044324.0
2014-01-30 15:30:00	SPY	ETF	179.58	179.64	179.21	179.32	15359034.0
2014-01-30 16:00:00	SPY	ETF	179.32	179.3551	177.3222	178.59	8737279.0
2014-01-30 16:30:00	SPY	ETF	178.62	179.3531	178.56	178.89	987006.0
2014-01-30 17:00:00	SPY	ETF	178.89	179.3632	178.69	178.76	619352.0
2014-01-30 17:30:00	SPY	ETF	178.78	178.81	178.7	178.76	79013.0
2014-01-30 18:00:00	SPY	ETF	178.78	179.23	178.66	178.9	2534723.0
2014-01-30 18:30:00	SPY	ETF	178.87	178.89	178.79	178.82	55084.0
2014-01-30 19:00:00	SPY	ETF	178.82	178.82	178.68	178.77	101061.0
2014-01-30 19:30:00	SPY	ETF	178.77	178.88	178.75	178.87	82645.0
2014-01-30 04:00:00	QQQ	ETF	85.27	85.35	85.23	85.23	17500.0
2014-01-30 04:30:00	QQQ	ETF	85.35	85.35	85.35	85.35	100.0
2014-01-30 05:30:00	QQQ	ETF	85.45	85.45	85.45	85.45	2500.0
2014-01-30 06:00:00	QQQ	ETF	85.54	85.63	85.54	85.63	9200.0
2014-01-30 06:30:00	QQQ	ETF	85.62	85.62	85.54	85.54	900.0
2014-01-30 07:00:00	QQQ	ETF	85.58	85.63	85.54	85.58	5100.0
2014-01-30 07:30:00	QQQ	ETF	85.59	85.62	85.57	85.61	72700.0
2014-01-30 08:00:00	QQQ	ETF	85.6	85.67	85.52	85.54	229090.0
2014-01-30 08:30:00	QQQ	ETF	85.55	85.81	85.52	85.79	230542.0
2014-01-30 09:00:00	QQQ	ETF	85.8	86.03	85.79	85.99	600574.0
2014-01-30 09:30:00	QQQ	ETF	85.99	86.22	85.92	85.98	6628575.0
2014-01-30 10:00:00	QQQ	ETF	85.98	86.15	85.88	85.99	2697258.0
2014-01-30 10:30:00	QQQ	ETF	85.99	86.32	85.9801	86.2399	2112034.0
2014-01-30 11:00:00	QQQ	ETF	86.235	86.486	86.12	86.41	2717462.0
2014-01-30 11:30:00	QQQ	ETF	86.41	86.73	86.401	86.65	2344257.0
2014-01-30 12:00:00	QQQ	ETF	86.65	86.7	86.59	86.59	1592486.0
2014-01-30 12:30:00	QQQ	ETF	86.59	86.8	86.59	86.725	1591155.0
2014-01-30 13:00:00	QQQ	ETF	86.72	86.735	86.61	86.61	790659.0

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

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