PREVIEW / etf_30min / 2014-08-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-27.parquet
  size:    317 KB
  rows:    11,141

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-08-27 04:00:00	SPY	ETF	200.4	200.51	200.4	200.49	2001.0
2014-08-27 05:00:00	SPY	ETF	200.53	200.57	200.53	200.55	535.0
2014-08-27 05:30:00	SPY	ETF	200.54	200.6	200.54	200.6	508.0
2014-08-27 06:00:00	SPY	ETF	200.54	200.54	200.51	200.51	300.0
2014-08-27 06:30:00	SPY	ETF	200.55	200.55	200.49	200.49	1359.0
2014-08-27 07:00:00	SPY	ETF	200.52	200.6	200.5	200.55	31147.0
2014-08-27 07:30:00	SPY	ETF	200.55	200.57	200.45	200.45	89777.0
2014-08-27 08:00:00	SPY	ETF	200.47	200.57	200.42	200.48	95513.0
2014-08-27 08:30:00	SPY	ETF	200.47	200.49	200.28	200.34	93128.0
2014-08-27 09:00:00	SPY	ETF	200.34	200.52	200.34	200.43	307594.0
2014-08-27 09:30:00	SPY	ETF	200.43	200.57	200.14	200.19	7123660.0
2014-08-27 10:00:00	SPY	ETF	200.18	200.29	200.08	200.13	4240302.0
2014-08-27 10:30:00	SPY	ETF	200.13	200.39	200.12	200.36	3624038.0
2014-08-27 11:00:00	SPY	ETF	200.35	200.5	200.35	200.377	1804901.0
2014-08-27 11:30:00	SPY	ETF	200.37	200.44	200.28	200.38	1774503.0
2014-08-27 12:00:00	SPY	ETF	200.385	200.43	200.21	200.32	1207834.0
2014-08-27 12:30:00	SPY	ETF	200.32	200.4	200.28	200.36	1326701.0
2014-08-27 13:00:00	SPY	ETF	200.36	200.37	200.33	200.3699	928139.0
2014-08-27 13:30:00	SPY	ETF	200.37	200.38	200.3	200.3325	1414475.0
2014-08-27 14:00:00	SPY	ETF	200.34	200.38	200.29	200.35	3435613.0
2014-08-27 14:30:00	SPY	ETF	200.35	200.35	200.0	200.0064	2532302.0
2014-08-27 15:00:00	SPY	ETF	200.015	200.18	199.94	200.16	3649982.0
2014-08-27 15:30:00	SPY	ETF	200.15	200.34	200.105	200.27	6896169.0
2014-08-27 16:00:00	SPY	ETF	200.28	200.3621	200.25	200.31	4003077.0
2014-08-27 16:30:00	SPY	ETF	200.29	200.32	200.27	200.29	148475.0
2014-08-27 17:00:00	SPY	ETF	200.29	200.3518	200.24	200.25	1555230.0
2014-08-27 17:30:00	SPY	ETF	200.25	200.25	200.22	200.23	58527.0
2014-08-27 18:00:00	SPY	ETF	200.22	200.24	200.22	200.23	26384.0
2014-08-27 18:30:00	SPY	ETF	200.23	200.25	200.23	200.24	2005.0
2014-08-27 19:00:00	SPY	ETF	200.23	200.24	200.23	200.23	3015.0
2014-08-27 19:30:00	SPY	ETF	200.23	200.29	200.23	200.26	11423.0
2014-08-27 04:00:00	QQQ	ETF	99.5	99.5	99.5	99.5	1000.0
2014-08-27 05:00:00	QQQ	ETF	99.6	99.6	99.6	99.6	100.0
2014-08-27 05:30:00	QQQ	ETF	99.62	99.62	99.62	99.62	600.0
2014-08-27 06:00:00	QQQ	ETF	99.58	99.6	99.58	99.59	19400.0
2014-08-27 06:30:00	QQQ	ETF	99.59	99.59	99.57	99.57	950.0
2014-08-27 07:00:00	QQQ	ETF	99.57	99.6	99.57	99.6	11370.0
2014-08-27 07:30:00	QQQ	ETF	99.58	99.58	99.55	99.55	5200.0
2014-08-27 08:00:00	QQQ	ETF	99.58	99.58	99.53	99.56	12765.0
2014-08-27 08:30:00	QQQ	ETF	99.54	99.54	99.48	99.51	19282.0
2014-08-27 09:00:00	QQQ	ETF	99.52	99.58	99.5	99.53	148925.0
2014-08-27 09:30:00	QQQ	ETF	99.53	99.59	99.315	99.34	2374324.0
2014-08-27 10:00:00	QQQ	ETF	99.33	99.42	99.31	99.35	1066129.0
2014-08-27 10:30:00	QQQ	ETF	99.36	99.55	99.35	99.5499	1034523.0
2014-08-27 11:00:00	QQQ	ETF	99.55	99.59	99.5	99.5	1107174.0
2014-08-27 11:30:00	QQQ	ETF	99.5	99.63	99.47	99.58	1007526.0
2014-08-27 12:00:00	QQQ	ETF	99.57	99.6	99.51	99.5599	643867.0
2014-08-27 12:30:00	QQQ	ETF	99.55	99.59	99.51	99.56	340759.0
2014-08-27 13:00:00	QQQ	ETF	99.56	99.57	99.53	99.564	387550.0
2014-08-27 13:30:00	QQQ	ETF	99.56	99.61	99.55	99.575	718174.0

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

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