PREVIEW / etf_30min / 2013-09-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-20.parquet
  size:    326 KB
  rows:    10,833

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-20 04:00:00	SPY	ETF	172.12	172.5	172.1	172.17	9443.0
2013-09-20 04:30:00	SPY	ETF	172.17	172.2	172.08	172.08	3570.0
2013-09-20 05:00:00	SPY	ETF	172.05	172.08	171.99	172.08	3700.0
2013-09-20 05:30:00	SPY	ETF	172.08	172.2	172.08	172.13	5419.0
2013-09-20 06:00:00	SPY	ETF	172.14	172.15	172.11	172.15	3800.0
2013-09-20 06:30:00	SPY	ETF	172.13	172.2	172.05	172.17	16095.0
2013-09-20 07:00:00	SPY	ETF	172.18	172.27	172.15	172.23	111147.0
2013-09-20 07:30:00	SPY	ETF	172.23	172.23	172.03	172.03	204821.0
2013-09-20 08:00:00	SPY	ETF	172.05	172.24	171.79	171.91	698886.0
2013-09-20 08:30:00	SPY	ETF	171.88	172.04	171.84	172.0	464830.0
2013-09-20 09:00:00	SPY	ETF	172.01	172.37	171.94	172.32	3778641.0
2013-09-20 09:30:00	SPY	ETF	172.33	172.33	171.745	171.86	16587022.0
2013-09-20 10:00:00	SPY	ETF	171.86	172.1069	171.6	171.83	8408890.0
2013-09-20 10:30:00	SPY	ETF	171.83	172.0	171.76	171.87	7142816.0
2013-09-20 11:00:00	SPY	ETF	171.87	172.3	171.531	171.64	6954301.0
2013-09-20 11:30:00	SPY	ETF	171.63	171.72	171.22	171.25	7067482.0
2013-09-20 12:00:00	SPY	ETF	171.245	171.42	171.1	171.16	6640598.0
2013-09-20 12:30:00	SPY	ETF	171.16	171.415	171.1	171.38	5130800.0
2013-09-20 13:00:00	SPY	ETF	171.38	171.42	171.04	171.165	4500724.0
2013-09-20 13:30:00	SPY	ETF	171.17	171.2395	170.96	170.98	4728006.0
2013-09-20 14:00:00	SPY	ETF	170.98	171.14	170.86	171.12	7927927.0
2013-09-20 14:30:00	SPY	ETF	171.125	171.16	170.84	171.02	5801469.0
2013-09-20 15:00:00	SPY	ETF	171.025	171.13	170.6801	170.695	9335308.0
2013-09-20 15:30:00	SPY	ETF	170.7	170.92	170.58	170.71	21288534.0
2013-09-20 16:00:00	SPY	ETF	170.71	172.15	170.58	170.76	5384653.0
2013-09-20 16:30:00	SPY	ETF	170.75	170.9082	170.73	170.88	740756.0
2013-09-20 17:00:00	SPY	ETF	170.86	170.92	170.77	170.82	1904102.0
2013-09-20 17:30:00	SPY	ETF	170.81	170.85	170.72	170.73	153523.0
2013-09-20 18:00:00	SPY	ETF	170.72	170.73	170.57	170.6	110549.0
2013-09-20 18:30:00	SPY	ETF	170.59	170.64	170.57	170.61	11972.0
2013-09-20 19:00:00	SPY	ETF	170.65	170.69	170.61	170.64	8790.0
2013-09-20 19:30:00	SPY	ETF	170.63	171.2215	170.63	170.64	181174.0
2013-09-20 04:00:00	QQQ	ETF	79.41	79.41	79.39	79.39	200.0
2013-09-20 05:00:00	QQQ	ETF	79.46	79.46	79.4	79.4	6400.0
2013-09-20 06:30:00	QQQ	ETF	79.4	79.4	79.4	79.4	200.0
2013-09-20 07:00:00	QQQ	ETF	79.4	79.41	79.4	79.41	3000.0
2013-09-20 07:30:00	QQQ	ETF	79.42	79.42	79.37	79.37	16500.0
2013-09-20 08:00:00	QQQ	ETF	79.39	79.39	79.29	79.35	92270.0
2013-09-20 08:30:00	QQQ	ETF	79.36	79.42	79.34	79.41	72314.0
2013-09-20 09:00:00	QQQ	ETF	79.4	79.52	79.38	79.48	401034.0
2013-09-20 09:30:00	QQQ	ETF	79.47	79.49	79.29	79.33	3329938.0
2013-09-20 10:00:00	QQQ	ETF	79.33	79.485	79.3	79.47	2077243.0
2013-09-20 10:30:00	QQQ	ETF	79.46	79.54	79.4	79.45	1607343.0
2013-09-20 11:00:00	QQQ	ETF	79.445	79.47	79.25	79.3	1226517.0
2013-09-20 11:30:00	QQQ	ETF	79.29	79.34	79.1	79.12	1253299.0
2013-09-20 12:00:00	QQQ	ETF	79.12	79.23	79.08	79.1	1247542.0
2013-09-20 12:30:00	QQQ	ETF	79.09	79.26	79.06	79.24	930517.0
2013-09-20 13:00:00	QQQ	ETF	79.25	79.27	79.04	79.1	1477961.0
2013-09-20 13:30:00	QQQ	ETF	79.11	79.16	79.02	79.07	1000488.0
2013-09-20 14:00:00	QQQ	ETF	79.07	79.16	79.03	79.15	799435.0

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

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