PREVIEW / etf_30min / 2013-09-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-09.parquet
  size:    331 KB
  rows:    11,039

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-09-09 04:00:00	SPY	ETF	166.15	166.52	166.15	166.45	14200.0
2013-09-09 04:30:00	SPY	ETF	166.47	166.52	166.35	166.51	65800.0
2013-09-09 05:00:00	SPY	ETF	166.46	166.46	166.34	166.34	7900.0
2013-09-09 05:30:00	SPY	ETF	166.35	166.35	166.27	166.27	6100.0
2013-09-09 06:00:00	SPY	ETF	166.26	166.37	166.26	166.37	3800.0
2013-09-09 06:30:00	SPY	ETF	166.4	166.5	166.26	166.26	20000.0
2013-09-09 07:00:00	SPY	ETF	166.24	166.42	166.2	166.41	98537.0
2013-09-09 07:30:00	SPY	ETF	166.42	166.44	166.28	166.29	66090.0
2013-09-09 08:00:00	SPY	ETF	166.32	166.4	166.29	166.34	421280.0
2013-09-09 08:30:00	SPY	ETF	166.34	166.42	166.27	166.42	273089.0
2013-09-09 09:00:00	SPY	ETF	166.42	166.52	166.37	166.43	511471.0
2013-09-09 09:30:00	SPY	ETF	166.45	167.05	166.45	166.9801	11010196.0
2013-09-09 10:00:00	SPY	ETF	166.99	167.11	166.64	166.66	7891551.0
2013-09-09 10:30:00	SPY	ETF	166.65	166.88	166.63	166.8	4777331.0
2013-09-09 11:00:00	SPY	ETF	166.79	166.9	166.7	166.8	3815733.0
2013-09-09 11:30:00	SPY	ETF	166.8	167.07	166.78	166.98	4732287.0
2013-09-09 12:00:00	SPY	ETF	166.98	167.28	166.98	167.24	4055507.0
2013-09-09 12:30:00	SPY	ETF	167.23	167.25	167.09	167.185	2831745.0
2013-09-09 13:00:00	SPY	ETF	167.19	167.25	167.12	167.155	2508255.0
2013-09-09 13:30:00	SPY	ETF	167.15	167.44	167.15	167.43	3184481.0
2013-09-09 14:00:00	SPY	ETF	167.42	167.73	167.415	167.61	6826760.0
2013-09-09 14:30:00	SPY	ETF	167.6	167.66	167.53	167.56	3227270.0
2013-09-09 15:00:00	SPY	ETF	167.56	167.72	167.49	167.57	4161138.0
2013-09-09 15:30:00	SPY	ETF	167.56	167.65	167.46	167.64	13357404.0
2013-09-09 16:00:00	SPY	ETF	167.64	167.71	167.42	167.56	2667897.0
2013-09-09 16:30:00	SPY	ETF	167.56	167.63	167.55	167.62	234059.0
2013-09-09 17:00:00	SPY	ETF	167.62	167.69	167.61	167.67	108285.0
2013-09-09 17:30:00	SPY	ETF	167.68	167.69	167.66	167.67	4017305.0
2013-09-09 18:00:00	SPY	ETF	167.67	167.78	167.65	167.76	60973.0
2013-09-09 18:30:00	SPY	ETF	167.78	167.79	167.7	167.76	65532.0
2013-09-09 19:00:00	SPY	ETF	167.71	167.74	167.69	167.74	14510.0
2013-09-09 19:30:00	SPY	ETF	167.74	167.8	167.74	167.79	9780.0
2013-09-09 04:00:00	QQQ	ETF	77.18	77.23	77.17	77.21	27100.0
2013-09-09 04:30:00	QQQ	ETF	77.23	77.23	77.19	77.23	5700.0
2013-09-09 05:00:00	QQQ	ETF	77.21	77.21	77.15	77.19	9500.0
2013-09-09 05:30:00	QQQ	ETF	77.17	77.19	77.15	77.15	4800.0
2013-09-09 06:00:00	QQQ	ETF	77.17	77.19	77.17	77.19	2400.0
2013-09-09 06:30:00	QQQ	ETF	77.21	77.26	77.15	77.15	12900.0
2013-09-09 07:00:00	QQQ	ETF	77.13	77.23	77.11	77.23	13700.0
2013-09-09 07:30:00	QQQ	ETF	77.21	77.39	77.18	77.19	39635.0
2013-09-09 08:00:00	QQQ	ETF	77.2	77.21	77.16	77.16	8800.0
2013-09-09 08:30:00	QQQ	ETF	77.18	77.19	77.15	77.19	43501.0
2013-09-09 09:00:00	QQQ	ETF	77.21	77.25	77.2	77.24	43667.0
2013-09-09 09:30:00	QQQ	ETF	77.23	77.52	77.23	77.47	3094286.0
2013-09-09 10:00:00	QQQ	ETF	77.47	77.52	77.26	77.32	1754429.0
2013-09-09 10:30:00	QQQ	ETF	77.31	77.44	77.29	77.37	1516229.0
2013-09-09 11:00:00	QQQ	ETF	77.365	77.44	77.31	77.41	866866.0
2013-09-09 11:30:00	QQQ	ETF	77.41	77.58	77.41	77.54	2068637.0
2013-09-09 12:00:00	QQQ	ETF	77.54	77.7	77.53	77.69	1630736.0
2013-09-09 12:30:00	QQQ	ETF	77.69	77.695	77.6	77.6386	1124984.0

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

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