PREVIEW / etf_30min / 2013-08-01

all etf 30-min files

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

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-08-01 04:00:00	SPY	ETF	169.06	169.43	169.06	169.35	21300.0
2013-08-01 04:30:00	SPY	ETF	169.4	169.48	169.4	169.48	26500.0
2013-08-01 05:00:00	SPY	ETF	169.5	169.72	169.47	169.72	9900.0
2013-08-01 05:30:00	SPY	ETF	169.75	169.82	169.69	169.77	54600.0
2013-08-01 06:00:00	SPY	ETF	169.81	169.81	169.74	169.74	34050.0
2013-08-01 06:30:00	SPY	ETF	169.72	169.73	169.61	169.61	31590.0
2013-08-01 07:00:00	SPY	ETF	169.62	169.69	169.56	169.59	164209.0
2013-08-01 07:30:00	SPY	ETF	169.62	169.73	169.61	169.63	89235.0
2013-08-01 08:00:00	SPY	ETF	169.63	169.85	169.62	169.79	418788.0
2013-08-01 08:30:00	SPY	ETF	169.8	169.91	169.63	169.74	876059.0
2013-08-01 09:00:00	SPY	ETF	169.73	170.02	169.64	170.0	1183145.0
2013-08-01 09:30:00	SPY	ETF	169.99	170.28	169.9	170.12	14098008.0
2013-08-01 10:00:00	SPY	ETF	170.1	170.53	170.07	170.48	13019625.0
2013-08-01 10:30:00	SPY	ETF	170.47	170.48	170.14	170.2	7147946.0
2013-08-01 11:00:00	SPY	ETF	170.2	170.29	170.11	170.25	4878992.0
2013-08-01 11:30:00	SPY	ETF	170.26	170.4	170.1939	170.33	4770004.0
2013-08-01 12:00:00	SPY	ETF	170.325	170.49	170.17	170.42	3500718.0
2013-08-01 12:30:00	SPY	ETF	170.41	170.5	170.29	170.35	3041987.0
2013-08-01 13:00:00	SPY	ETF	170.35	170.4	170.26	170.305	2939748.0
2013-08-01 13:30:00	SPY	ETF	170.305	170.48	170.26	170.455	2747629.0
2013-08-01 14:00:00	SPY	ETF	170.45	170.68	170.425	170.645	6169510.0
2013-08-01 14:30:00	SPY	ETF	170.64	170.68	170.53	170.57	5836059.0
2013-08-01 15:00:00	SPY	ETF	170.58	170.64	170.34	170.48	6881751.0
2013-08-01 15:30:00	SPY	ETF	170.49	170.81	170.46	170.66	19399648.0
2013-08-01 16:00:00	SPY	ETF	170.65	170.6926	170.42	170.57	6408257.0
2013-08-01 16:30:00	SPY	ETF	170.57	170.73	170.57	170.71	602219.0
2013-08-01 17:00:00	SPY	ETF	170.71	170.73	170.61	170.61	158144.0
2013-08-01 17:30:00	SPY	ETF	170.62	170.67	170.6	170.65	96593.0
2013-08-01 18:00:00	SPY	ETF	170.66	170.66	170.51	170.53	168784.0
2013-08-01 18:30:00	SPY	ETF	170.52	170.62	170.52	170.55	8510.0
2013-08-01 19:00:00	SPY	ETF	170.55	170.58	170.54	170.58	12100.0
2013-08-01 19:30:00	SPY	ETF	170.58	170.65	170.57	170.63	37846.0
2013-08-01 04:00:00	QQQ	ETF	76.05	76.05	76.01	76.05	10200.0
2013-08-01 04:30:00	QQQ	ETF	76.07	76.09	76.06	76.09	2500.0
2013-08-01 05:00:00	QQQ	ETF	76.1	76.17	76.1	76.17	5500.0
2013-08-01 05:30:00	QQQ	ETF	76.19	76.21	76.19	76.21	2200.0
2013-08-01 06:00:00	QQQ	ETF	76.19	76.2	76.19	76.2	4000.0
2013-08-01 06:30:00	QQQ	ETF	76.17	76.17	76.15	76.15	2200.0
2013-08-01 07:00:00	QQQ	ETF	76.13	76.16	76.13	76.14	25500.0
2013-08-01 07:30:00	QQQ	ETF	76.15	76.17	76.15	76.15	8500.0
2013-08-01 08:00:00	QQQ	ETF	76.15	76.23	76.15	76.23	56297.0
2013-08-01 08:30:00	QQQ	ETF	76.21	76.26	76.19	76.21	61139.0
2013-08-01 09:00:00	QQQ	ETF	76.21	76.31	75.77	76.31	77752.0
2013-08-01 09:30:00	QQQ	ETF	76.3	76.3999	76.21	76.25	2446637.0
2013-08-01 10:00:00	QQQ	ETF	76.25	76.4355	76.23	76.38	1796137.0
2013-08-01 10:30:00	QQQ	ETF	76.3785	76.399	76.29	76.32	1040134.0
2013-08-01 11:00:00	QQQ	ETF	76.32	76.35	76.26	76.33	775955.0
2013-08-01 11:30:00	QQQ	ETF	76.34	76.3899	76.31	76.35	698243.0
2013-08-01 12:00:00	QQQ	ETF	76.351	76.4299	76.28	76.39	760273.0
2013-08-01 12:30:00	QQQ	ETF	76.39	76.41	76.31	76.33	419975.0

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

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