PREVIEW / etf_30min / 2013-07-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-02.parquet
  size:    322 KB
  rows:    10,776

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-07-02 04:00:00	SPY	ETF	161.38	161.47	161.19	161.29	27400.0
2013-07-02 04:30:00	SPY	ETF	161.4	161.65	161.4	161.55	26150.0
2013-07-02 05:00:00	SPY	ETF	161.6	161.7	161.43	161.44	5200.0
2013-07-02 05:30:00	SPY	ETF	161.4	161.55	161.31	161.45	8800.0
2013-07-02 06:00:00	SPY	ETF	161.5	161.78	161.5	161.7	8100.0
2013-07-02 06:30:00	SPY	ETF	161.71	161.75	161.49	161.6	20100.0
2013-07-02 07:00:00	SPY	ETF	161.6	161.65	161.5	161.55	30630.0
2013-07-02 07:30:00	SPY	ETF	161.54	161.55	161.39	161.4	68256.0
2013-07-02 08:00:00	SPY	ETF	161.43	161.62	161.08	161.08	312532.0
2013-07-02 08:30:00	SPY	ETF	161.09	161.4	160.96	161.03	906360.0
2013-07-02 09:00:00	SPY	ETF	161.03	161.25	160.99	161.13	898756.0
2013-07-02 09:30:00	SPY	ETF	161.12	162.08	161.03	161.88	14783555.0
2013-07-02 10:00:00	SPY	ETF	161.88	162.22	161.69	162.02	12063944.0
2013-07-02 10:30:00	SPY	ETF	162.0299	162.23	161.86	162.19	8565478.0
2013-07-02 11:00:00	SPY	ETF	162.19	162.23	161.94	162.08	8112253.0
2013-07-02 11:30:00	SPY	ETF	162.08	162.3	162.0	162.18	5787294.0
2013-07-02 12:00:00	SPY	ETF	162.17	162.21	161.77	161.88	5879458.0
2013-07-02 12:30:00	SPY	ETF	161.88	162.05	161.67	161.97	5567602.0
2013-07-02 13:00:00	SPY	ETF	161.97	161.98	161.63	161.64	4180283.0
2013-07-02 13:30:00	SPY	ETF	161.64	161.71	161.18	161.41	7092058.0
2013-07-02 14:00:00	SPY	ETF	161.41	161.415	160.56	160.68	12186097.0
2013-07-02 14:30:00	SPY	ETF	160.67	161.04	160.5	160.941	12912531.0
2013-07-02 15:00:00	SPY	ETF	160.94	161.13	160.76	160.85	7553367.0
2013-07-02 15:30:00	SPY	ETF	160.85	161.37	160.68	161.16	15548428.0
2013-07-02 16:00:00	SPY	ETF	161.14	161.3467	160.5	161.17	7906739.0
2013-07-02 16:30:00	SPY	ETF	161.18	161.25	161.15	161.19	4257866.0
2013-07-02 17:00:00	SPY	ETF	161.2	161.21	161.17	161.19	1548502.0
2013-07-02 17:30:00	SPY	ETF	161.18	161.24	161.17	161.19	47477.0
2013-07-02 18:00:00	SPY	ETF	161.18	161.26	161.18	161.24	79135.0
2013-07-02 18:30:00	SPY	ETF	161.21	161.21	161.15	161.17	28420.0
2013-07-02 19:00:00	SPY	ETF	161.19	161.29	161.19	161.26	10900.0
2013-07-02 19:30:00	SPY	ETF	161.26	161.29	161.23	161.25	10585.0
2013-07-02 04:00:00	QQQ	ETF	71.76	71.86	71.74	71.78	9100.0
2013-07-02 04:30:00	QQQ	ETF	71.8	71.9	71.8	71.88	4200.0
2013-07-02 05:00:00	QQQ	ETF	71.9	71.94	71.8	71.8	6000.0
2013-07-02 05:30:00	QQQ	ETF	71.78	71.82	71.74	71.8	6400.0
2013-07-02 06:00:00	QQQ	ETF	71.82	71.96	71.82	71.9	7000.0
2013-07-02 06:30:00	QQQ	ETF	71.92	71.94	71.82	71.86	6000.0
2013-07-02 07:00:00	QQQ	ETF	71.84	71.86	71.81	71.82	3845.0
2013-07-02 07:30:00	QQQ	ETF	71.82	71.84	71.79	71.8	8020.0
2013-07-02 08:00:00	QQQ	ETF	71.78	71.8	71.7	71.7	9504.0
2013-07-02 08:30:00	QQQ	ETF	71.64	71.72	71.63	71.65	27130.0
2013-07-02 09:00:00	QQQ	ETF	71.68	71.74	71.67	71.69	32164.0
2013-07-02 09:30:00	QQQ	ETF	71.69	72.09	71.62	71.9799	2664087.0
2013-07-02 10:00:00	QQQ	ETF	71.98	72.14	71.84	72.045	2092840.0
2013-07-02 10:30:00	QQQ	ETF	72.04	72.14	71.96	72.12	1641173.0
2013-07-02 11:00:00	QQQ	ETF	72.12	72.14	71.96	71.9963	1808935.0
2013-07-02 11:30:00	QQQ	ETF	72.01	72.1796	71.98	72.125	732149.0
2013-07-02 12:00:00	QQQ	ETF	72.12	72.13	71.88	71.925	928481.0
2013-07-02 12:30:00	QQQ	ETF	71.92	72.04	71.85	72.01	1044328.0

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

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