PREVIEW / etf_30min / 2013-06-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-04.parquet
  size:    327 KB
  rows:    10,860

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-06-04 04:00:00	SPY	ETF	164.1	164.22	164.08	164.12	11000.0
2013-06-04 04:30:00	SPY	ETF	164.16	164.28	164.04	164.04	2400.0
2013-06-04 05:00:00	SPY	ETF	164.08	164.16	164.01	164.05	12200.0
2013-06-04 05:30:00	SPY	ETF	164.0	164.13	164.0	164.13	43000.0
2013-06-04 06:00:00	SPY	ETF	164.16	164.32	164.16	164.18	30900.0
2013-06-04 06:30:00	SPY	ETF	164.26	164.26	164.01	164.21	67300.0
2013-06-04 07:00:00	SPY	ETF	164.21	164.24	164.06	164.24	36075.0
2013-06-04 07:30:00	SPY	ETF	164.21	164.29	164.15	164.16	78290.0
2013-06-04 08:00:00	SPY	ETF	164.19	164.45	164.08	164.45	238257.0
2013-06-04 08:30:00	SPY	ETF	164.46	164.6	164.34	164.42	535935.0
2013-06-04 09:00:00	SPY	ETF	164.4	164.45	164.31	164.44	612488.0
2013-06-04 09:30:00	SPY	ETF	164.44	165.01	164.29	164.85	14205185.0
2013-06-04 10:00:00	SPY	ETF	164.855	164.92	164.57	164.89	8870343.0
2013-06-04 10:30:00	SPY	ETF	164.895	165.1	164.3691	164.37	9862538.0
2013-06-04 11:00:00	SPY	ETF	164.37	164.55	164.19	164.49	7543780.0
2013-06-04 11:30:00	SPY	ETF	164.485	164.62	164.22	164.52	5649463.0
2013-06-04 12:00:00	SPY	ETF	164.511	164.56	163.84	163.85	8584930.0
2013-06-04 12:30:00	SPY	ETF	163.85	164.89	163.82	164.05	6469294.0
2013-06-04 13:00:00	SPY	ETF	164.04	164.27	163.4	163.52	8996194.0
2013-06-04 13:30:00	SPY	ETF	163.52	163.58	163.01	163.27	13684651.0
2013-06-04 14:00:00	SPY	ETF	163.27	163.31	162.73	163.17	15423393.0
2013-06-04 14:30:00	SPY	ETF	163.18	163.59	163.155	163.31	10904991.0
2013-06-04 15:00:00	SPY	ETF	163.31	163.66	163.2	163.42	10617522.0
2013-06-04 15:30:00	SPY	ETF	163.43	164.13	163.41	163.505	20787371.0
2013-06-04 16:00:00	SPY	ETF	163.51	164.4444	162.8	163.64	10983402.0
2013-06-04 16:30:00	SPY	ETF	163.64	163.75	163.58	163.64	1549309.0
2013-06-04 17:00:00	SPY	ETF	163.64	163.65	163.549	163.58	556139.0
2013-06-04 17:30:00	SPY	ETF	163.58	163.63	163.51	163.51	100921.0
2013-06-04 18:00:00	SPY	ETF	163.51	163.66	163.43	163.66	54287.0
2013-06-04 18:30:00	SPY	ETF	163.65	163.65	163.58	163.63	7650.0
2013-06-04 19:00:00	SPY	ETF	163.62	163.63	163.57	163.63	6800.0
2013-06-04 19:30:00	SPY	ETF	163.63	163.63	163.53	163.59	25491.0
2013-06-04 04:00:00	QQQ	ETF	73.36	73.38	73.32	73.32	44400.0
2013-06-04 04:30:00	QQQ	ETF	73.35	73.38	73.29	73.29	2800.0
2013-06-04 05:00:00	QQQ	ETF	73.28	73.32	73.28	73.29	2400.0
2013-06-04 05:30:00	QQQ	ETF	73.31	73.35	73.31	73.35	1000.0
2013-06-04 06:00:00	QQQ	ETF	73.38	73.4	73.38	73.38	19400.0
2013-06-04 06:30:00	QQQ	ETF	73.35	73.37	73.3	73.37	5300.0
2013-06-04 07:00:00	QQQ	ETF	73.37	73.38	73.32	73.38	7400.0
2013-06-04 07:30:00	QQQ	ETF	73.39	73.4	73.38	73.38	1300.0
2013-06-04 08:00:00	QQQ	ETF	73.37	73.46	73.37	73.46	28400.0
2013-06-04 08:30:00	QQQ	ETF	73.49	73.54	73.38	73.46	75862.0
2013-06-04 09:00:00	QQQ	ETF	73.47	73.52	73.44	73.52	29211.0
2013-06-04 09:30:00	QQQ	ETF	73.52	73.74	73.43	73.7	3213842.0
2013-06-04 10:00:00	QQQ	ETF	73.7	73.75	73.56	73.72	2324441.0
2013-06-04 10:30:00	QQQ	ETF	73.73	73.82	73.54	73.54	3285793.0
2013-06-04 11:00:00	QQQ	ETF	73.54	73.64	73.41	73.6	1674043.0
2013-06-04 11:30:00	QQQ	ETF	73.605	73.7	73.51	73.64	882033.0
2013-06-04 12:00:00	QQQ	ETF	73.63	73.645	73.3	73.3099	1431485.0
2013-06-04 12:30:00	QQQ	ETF	73.3	73.39	73.27	73.37	1078412.0

> showing 50 of 10,860 rows — these rows as CSV

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