PREVIEW / etf_30min / 2011-07-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-18.parquet
  size:    284 KB
  rows:    9,548

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
2011-07-18 04:00:00	SPY	ETF	131.85	131.85	131.0	131.0	11178.0
2011-07-18 04:30:00	SPY	ETF	131.2	131.2	131.2	131.2	250.0
2011-07-18 05:00:00	SPY	ETF	131.06	131.15	131.06	131.15	1250.0
2011-07-18 05:30:00	SPY	ETF	131.15	131.21	131.05	131.05	24300.0
2011-07-18 06:00:00	SPY	ETF	131.04	131.12	130.9	131.11	21068.0
2011-07-18 06:30:00	SPY	ETF	131.04	131.04	130.85	130.96	30900.0
2011-07-18 07:00:00	SPY	ETF	130.98	131.06	130.6	130.73	1675761.0
2011-07-18 07:30:00	SPY	ETF	130.73	131.14	130.7	131.03	499058.0
2011-07-18 08:00:00	SPY	ETF	131.03	131.17	130.83	131.06	4274719.0
2011-07-18 08:30:00	SPY	ETF	131.08	131.15	131.04	131.15	1478156.0
2011-07-18 09:00:00	SPY	ETF	131.15	131.29	131.08	131.09	929998.0
2011-07-18 09:30:00	SPY	ETF	131.08	131.28	130.63	130.77	16923033.0
2011-07-18 10:00:00	SPY	ETF	130.775	130.87	130.1	130.41	17724324.0
2011-07-18 10:30:00	SPY	ETF	130.4	130.43	129.91	130.11	15447010.0
2011-07-18 11:00:00	SPY	ETF	130.1087	130.31	129.97	130.19	11207274.0
2011-07-18 11:30:00	SPY	ETF	130.19	130.23	129.63	129.7199	10634017.0
2011-07-18 12:00:00	SPY	ETF	129.71	130.02	129.67	129.97	11966320.0
2011-07-18 12:30:00	SPY	ETF	129.98	130.09	129.86	130.04	5496124.0
2011-07-18 13:00:00	SPY	ETF	130.03	130.05	129.79	129.9815	4847456.0
2011-07-18 13:30:00	SPY	ETF	129.98	130.4	129.98	130.355	9687561.0
2011-07-18 14:00:00	SPY	ETF	130.36	130.41	130.19	130.24	5764458.0
2011-07-18 14:30:00	SPY	ETF	130.25	130.45	130.03	130.44	9437486.0
2011-07-18 15:00:00	SPY	ETF	130.44	130.61	130.21	130.33	17141589.0
2011-07-18 15:30:00	SPY	ETF	130.34	130.65	130.27	130.6	23024169.0
2011-07-18 16:00:00	SPY	ETF	130.59	130.68	130.3042	130.63	16198024.0
2011-07-18 16:30:00	SPY	ETF	130.65	131.6721	130.1	130.64	2188534.0
2011-07-18 17:00:00	SPY	ETF	130.63	130.63	130.55	130.59	133450.0
2011-07-18 17:30:00	SPY	ETF	130.55	130.61	130.55	130.57	43787.0
2011-07-18 18:00:00	SPY	ETF	130.6	130.61	130.54	130.56	318353.0
2011-07-18 18:30:00	SPY	ETF	130.54	130.57	130.52	130.54	18567.0
2011-07-18 19:00:00	SPY	ETF	130.53	130.66	130.53	130.63	28363.0
2011-07-18 19:30:00	SPY	ETF	130.63	130.75	130.58	130.69	76527.0
2011-07-18 04:00:00	QQQ	ETF	57.53	57.53	57.53	57.53	312.0
2011-07-18 04:30:00	QQQ	ETF	57.57	57.58	57.56	57.56	1560.0
2011-07-18 05:00:00	QQQ	ETF	57.56	57.56	57.46	57.46	11000.0
2011-07-18 06:00:00	QQQ	ETF	57.4	57.4	57.4	57.4	100.0
2011-07-18 06:30:00	QQQ	ETF	57.38	57.38	57.35	57.35	1391.0
2011-07-18 07:00:00	QQQ	ETF	57.4	57.48	57.27	57.32	742300.0
2011-07-18 07:30:00	QQQ	ETF	57.32	57.5	57.3	57.45	550365.0
2011-07-18 08:00:00	QQQ	ETF	57.44	57.54	57.39	57.52	1756696.0
2011-07-18 08:30:00	QQQ	ETF	57.53	57.57	57.52	57.56	1248114.0
2011-07-18 09:00:00	QQQ	ETF	57.56	57.63	57.515	57.54	266714.0
2011-07-18 09:30:00	QQQ	ETF	57.54	57.79	57.45	57.5	6121111.0
2011-07-18 10:00:00	QQQ	ETF	57.5	57.62	57.13	57.27	7957123.0
2011-07-18 10:30:00	QQQ	ETF	57.26	57.35	57.11	57.21	4073002.0
2011-07-18 11:00:00	QQQ	ETF	57.2	57.32	57.14	57.26	2180391.0
2011-07-18 11:30:00	QQQ	ETF	57.27	57.2801	56.98	57.02	2938609.0
2011-07-18 12:00:00	QQQ	ETF	57.03	57.165	56.98	57.145	2094667.0
2011-07-18 12:30:00	QQQ	ETF	57.15	57.18	57.08	57.15	1389386.0
2011-07-18 13:00:00	QQQ	ETF	57.15	57.17	57.05	57.15	1861768.0

> showing 50 of 9,548 rows — these rows as CSV

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