PREVIEW / etf_30min / 2014-08-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-25.parquet
  size:    334 KB
  rows:    11,471

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-25 04:00:00	SPY	ETF	199.9	200.04	199.9	200.0	7158.0
2014-08-25 04:30:00	SPY	ETF	200.0	200.12	199.93	199.94	7250.0
2014-08-25 05:00:00	SPY	ETF	199.94	199.98	199.94	199.98	500.0
2014-08-25 05:30:00	SPY	ETF	199.89	199.94	199.86	199.9	2306.0
2014-08-25 06:00:00	SPY	ETF	199.96	200.0	199.94	199.98	10920.0
2014-08-25 06:30:00	SPY	ETF	199.9	200.02	199.89	200.02	3266.0
2014-08-25 07:00:00	SPY	ETF	199.97	200.08	199.91	200.05	115280.0
2014-08-25 07:30:00	SPY	ETF	200.02	200.13	200.01	200.13	97033.0
2014-08-25 08:00:00	SPY	ETF	200.06	200.1	199.96	200.1	213498.0
2014-08-25 08:30:00	SPY	ETF	200.1	200.2	200.05	200.2	419963.0
2014-08-25 09:00:00	SPY	ETF	200.19	200.25	200.12	200.15	395528.0
2014-08-25 09:30:00	SPY	ETF	200.14	200.33	199.91	200.27	7291568.0
2014-08-25 10:00:00	SPY	ETF	200.26	200.35	200.09	200.2	5339280.0
2014-08-25 10:30:00	SPY	ETF	200.1999	200.51	200.18	200.45	7016091.0
2014-08-25 11:00:00	SPY	ETF	200.46	200.53	200.36	200.49	5048100.0
2014-08-25 11:30:00	SPY	ETF	200.5	200.5949	200.41	200.44	1936860.0
2014-08-25 12:00:00	SPY	ETF	200.445	200.47	200.06	200.13	3613313.0
2014-08-25 12:30:00	SPY	ETF	200.13	200.16	199.94	200.02	4995890.0
2014-08-25 13:00:00	SPY	ETF	200.02	200.12	199.86	200.11	2877698.0
2014-08-25 13:30:00	SPY	ETF	200.11	200.24	200.06	200.14	2139629.0
2014-08-25 14:00:00	SPY	ETF	200.15	200.18	200.0	200.06	2208945.0
2014-08-25 14:30:00	SPY	ETF	200.05	200.17	199.98	200.14	2388750.0
2014-08-25 15:00:00	SPY	ETF	200.14	200.18	200.05	200.08	4251697.0
2014-08-25 15:30:00	SPY	ETF	200.07	200.21	200.05	200.17	9792025.0
2014-08-25 16:00:00	SPY	ETF	200.17	200.2	200.03	200.08	2761848.0
2014-08-25 16:30:00	SPY	ETF	200.07	200.07	200.04	200.04	92921.0
2014-08-25 17:00:00	SPY	ETF	200.05	200.07	200.03	200.05	101907.0
2014-08-25 17:30:00	SPY	ETF	200.06	200.08	200.03	200.03	7222.0
2014-08-25 18:00:00	SPY	ETF	200.03	200.09	200.0	200.09	14085.0
2014-08-25 18:30:00	SPY	ETF	200.07	200.07	200.04	200.04	15748.0
2014-08-25 19:00:00	SPY	ETF	200.08	200.09	200.08	200.09	1721.0
2014-08-25 19:30:00	SPY	ETF	200.09	200.11	200.09	200.1	26794.0
2014-08-25 04:30:00	QQQ	ETF	99.53	99.53	99.53	99.53	100.0
2014-08-25 06:00:00	QQQ	ETF	99.44	99.45	99.44	99.45	400.0
2014-08-25 06:30:00	QQQ	ETF	99.45	99.51	99.45	99.51	900.0
2014-08-25 07:00:00	QQQ	ETF	99.47	99.53	99.44	99.53	46650.0
2014-08-25 07:30:00	QQQ	ETF	99.52	99.57	99.52	99.54	40490.0
2014-08-25 08:00:00	QQQ	ETF	99.54	99.54	99.47	99.52	97953.0
2014-08-25 08:30:00	QQQ	ETF	99.5	99.55	99.48	99.55	138384.0
2014-08-25 09:00:00	QQQ	ETF	99.54	99.57	99.5	99.53	80375.0
2014-08-25 09:30:00	QQQ	ETF	99.52	99.61	99.48	99.59	2306166.0
2014-08-25 10:00:00	QQQ	ETF	99.58	99.61	99.48	99.56	1590417.0
2014-08-25 10:30:00	QQQ	ETF	99.56	99.68	99.537	99.62	1739533.0
2014-08-25 11:00:00	QQQ	ETF	99.625	99.64	99.54	99.62	1118632.0
2014-08-25 11:30:00	QQQ	ETF	99.61	99.63	99.57	99.5964	790264.0
2014-08-25 12:00:00	QQQ	ETF	99.6	99.61	99.2501	99.31	1791771.0
2014-08-25 12:30:00	QQQ	ETF	99.31	99.35	99.22	99.31	1067955.0
2014-08-25 13:00:00	QQQ	ETF	99.31	99.38	99.16	99.37	1420514.0
2014-08-25 13:30:00	QQQ	ETF	99.37	99.46	99.3499	99.38	807738.0
2014-08-25 14:00:00	QQQ	ETF	99.38	99.4	99.28	99.31	794231.0

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

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