PREVIEW / etf_30min / 2013-06-07

all etf 30-min files

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

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-07 04:00:00	SPY	ETF	162.66	162.79	162.54	162.65	12550.0
2013-06-07 04:30:00	SPY	ETF	162.6	162.75	162.59	162.7	4400.0
2013-06-07 05:00:00	SPY	ETF	162.72	162.75	162.66	162.66	2600.0
2013-06-07 05:30:00	SPY	ETF	162.72	162.84	162.6	162.8	5300.0
2013-06-07 06:00:00	SPY	ETF	162.79	162.79	162.48	162.5	30515.0
2013-06-07 06:30:00	SPY	ETF	162.5	162.86	162.5	162.82	51358.0
2013-06-07 07:00:00	SPY	ETF	162.8	162.87	162.69	162.74	145131.0
2013-06-07 07:30:00	SPY	ETF	162.74	162.88	162.64	162.82	272570.0
2013-06-07 08:00:00	SPY	ETF	162.8	163.28	162.69	163.2	1511063.0
2013-06-07 08:30:00	SPY	ETF	163.24	163.9	162.45	163.67	7752847.0
2013-06-07 09:00:00	SPY	ETF	163.68	163.92	162.7307	163.86	3564040.0
2013-06-07 09:30:00	SPY	ETF	163.85	163.89	163.14	163.808	22289858.0
2013-06-07 10:00:00	SPY	ETF	163.82	164.44	163.81	164.28	19341586.0
2013-06-07 10:30:00	SPY	ETF	164.27	164.48	164.15	164.22	12969554.0
2013-06-07 11:00:00	SPY	ETF	164.23	164.71	164.22	164.615	9671162.0
2013-06-07 11:30:00	SPY	ETF	164.605	164.75	164.3	164.39	13105276.0
2013-06-07 12:00:00	SPY	ETF	164.39	164.45	164.19	164.4	5285511.0
2013-06-07 12:30:00	SPY	ETF	164.4	164.41	164.02	164.295	6430556.0
2013-06-07 13:00:00	SPY	ETF	164.29	164.42	164.18	164.28	4419735.0
2013-06-07 13:30:00	SPY	ETF	164.28	164.39	164.12	164.13	5360522.0
2013-06-07 14:00:00	SPY	ETF	164.13	164.26	163.74	163.89	9176653.0
2013-06-07 14:30:00	SPY	ETF	163.89	164.42	163.785	164.339	8926869.0
2013-06-07 15:00:00	SPY	ETF	164.34	164.53	164.22	164.36	7880169.0
2013-06-07 15:30:00	SPY	ETF	164.37	164.95	164.36	164.81	22970177.0
2013-06-07 16:00:00	SPY	ETF	164.8	164.8107	162.7306	164.51	11624837.0
2013-06-07 16:30:00	SPY	ETF	164.51	164.8099	162.7307	164.53	6835063.0
2013-06-07 17:00:00	SPY	ETF	164.53	164.6	164.49	164.57	1301589.0
2013-06-07 17:30:00	SPY	ETF	164.57	164.59	164.5	164.5	43202.0
2013-06-07 18:00:00	SPY	ETF	164.49	164.65	162.7307	164.59	2542670.0
2013-06-07 18:30:00	SPY	ETF	164.59	164.62	164.49	164.53	19215.0
2013-06-07 19:00:00	SPY	ETF	164.55	164.58	164.5	164.55	4085.0
2013-06-07 19:30:00	SPY	ETF	164.56	164.6	164.53	164.53	10736.0
2013-06-07 04:00:00	QQQ	ETF	72.38	72.46	72.35	72.35	5580.0
2013-06-07 04:30:00	QQQ	ETF	72.33	72.37	72.31	72.37	2200.0
2013-06-07 05:00:00	QQQ	ETF	72.4	72.4	72.35	72.35	2700.0
2013-06-07 05:30:00	QQQ	ETF	72.37	72.45	72.31	72.45	4000.0
2013-06-07 06:00:00	QQQ	ETF	72.42	72.42	72.25	72.25	2400.0
2013-06-07 06:30:00	QQQ	ETF	72.27	72.4	72.27	72.4	3300.0
2013-06-07 07:00:00	QQQ	ETF	72.42	72.42	72.35	72.37	7214.0
2013-06-07 07:30:00	QQQ	ETF	72.35	72.4	72.34	72.39	17100.0
2013-06-07 08:00:00	QQQ	ETF	72.35	72.52	72.34	72.52	71409.0
2013-06-07 08:30:00	QQQ	ETF	72.52	72.89	72.3	72.74	621944.0
2013-06-07 09:00:00	QQQ	ETF	72.74	72.78	72.6	72.72	182483.0
2013-06-07 09:30:00	QQQ	ETF	72.73	72.84	72.52	72.83	5215646.0
2013-06-07 10:00:00	QQQ	ETF	72.83	73.1399	72.78	73.001	5293476.0
2013-06-07 10:30:00	QQQ	ETF	73.01	73.1645	72.96	73.02	1740318.0
2013-06-07 11:00:00	QQQ	ETF	73.01	73.26	73.01	73.24	1671182.0
2013-06-07 11:30:00	QQQ	ETF	73.24	73.28	73.085	73.17	1288419.0
2013-06-07 12:00:00	QQQ	ETF	73.16	73.2	73.0601	73.19	943995.0
2013-06-07 12:30:00	QQQ	ETF	73.2	73.26	73.051	73.24	1084362.0

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

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