PREVIEW / etf_30min / 2015-09-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-02.parquet
  size:    393 KB
  rows:    13,248

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
2015-09-02 04:00:00	SPY	ETF	193.91	194.1	192.84	192.84	103927.0
2015-09-02 04:30:00	SPY	ETF	193.05	193.47	193.03	193.2	23410.0
2015-09-02 05:00:00	SPY	ETF	193.18	193.63	193.0	193.16	13508.0
2015-09-02 05:30:00	SPY	ETF	192.96	193.65	192.92	193.65	28916.0
2015-09-02 06:00:00	SPY	ETF	193.7	194.1	193.51	193.56	26526.0
2015-09-02 06:30:00	SPY	ETF	193.58	193.72	193.04	193.25	82035.0
2015-09-02 07:00:00	SPY	ETF	193.22	193.58	193.13	193.58	252824.0
2015-09-02 07:30:00	SPY	ETF	193.48	193.83	193.44	193.76	358594.0
2015-09-02 08:00:00	SPY	ETF	193.74	193.85	193.22	193.56	718813.0
2015-09-02 08:30:00	SPY	ETF	193.56	194.39	193.55	194.33	1497610.0
2015-09-02 09:00:00	SPY	ETF	194.33	194.93	194.13	194.67	2521480.0
2015-09-02 09:30:00	SPY	ETF	194.62	194.69	193.51	193.6	15430332.0
2015-09-02 10:00:00	SPY	ETF	193.6	194.16	192.91	192.97	12240892.0
2015-09-02 10:30:00	SPY	ETF	192.98	193.1	192.42	193.02	11230106.0
2015-09-02 11:00:00	SPY	ETF	193.02	193.71	192.865	193.485	8046868.0
2015-09-02 11:30:00	SPY	ETF	193.49	193.57	192.51	192.81	7574991.0
2015-09-02 12:00:00	SPY	ETF	192.83	193.19	192.5	193.03	5310505.0
2015-09-02 12:30:00	SPY	ETF	193.03	194.07	193.0	193.96	8144259.0
2015-09-02 13:00:00	SPY	ETF	193.95	194.35	193.64	194.335	6491391.0
2015-09-02 13:30:00	SPY	ETF	194.33	194.33	193.69	193.87	5785689.0
2015-09-02 14:00:00	SPY	ETF	193.88	194.5	193.64	194.26	9725372.0
2015-09-02 14:30:00	SPY	ETF	194.27	194.3	193.4	194.07	11844226.0
2015-09-02 15:00:00	SPY	ETF	194.0629	194.32	193.38	194.11	9222404.0
2015-09-02 15:30:00	SPY	ETF	194.11	195.46	193.99	195.46	26161328.0
2015-09-02 16:00:00	SPY	ETF	195.45	195.58	191.9119	195.41	8732666.0
2015-09-02 16:30:00	SPY	ETF	195.41	195.64	195.36	195.58	726248.0
2015-09-02 17:00:00	SPY	ETF	195.56	195.64	195.51	195.62	141296.0
2015-09-02 17:30:00	SPY	ETF	195.62	195.75	195.6	195.68	153899.0
2015-09-02 18:00:00	SPY	ETF	195.61	196.5	195.55	196.45	204803.0
2015-09-02 18:30:00	SPY	ETF	196.38	196.38	196.1	196.16	98099.0
2015-09-02 19:00:00	SPY	ETF	196.16	196.16	195.92	196.0	145559.0
2015-09-02 19:30:00	SPY	ETF	195.96	196.08	195.82	196.08	316601.0
2015-09-02 04:00:00	QQQ	ETF	102.3	102.3	101.9	102.0	1880.0
2015-09-02 04:30:00	QQQ	ETF	102.1	102.19	102.1	102.15	850.0
2015-09-02 05:00:00	QQQ	ETF	102.2	102.2	102.2	102.2	500.0
2015-09-02 05:30:00	QQQ	ETF	102.19	102.2	102.19	102.2	300.0
2015-09-02 06:00:00	QQQ	ETF	102.44	102.53	102.23	102.23	5300.0
2015-09-02 06:30:00	QQQ	ETF	102.23	102.23	101.97	102.01	9800.0
2015-09-02 07:00:00	QQQ	ETF	102.05	102.23	102.01	102.23	28115.0
2015-09-02 07:30:00	QQQ	ETF	102.18	102.41	102.16	102.38	45430.0
2015-09-02 08:00:00	QQQ	ETF	102.36	102.41	101.05	102.33	87783.0
2015-09-02 08:30:00	QQQ	ETF	102.29	102.76	102.29	102.73	301097.0
2015-09-02 09:00:00	QQQ	ETF	102.72	102.91	102.6	102.87	232134.0
2015-09-02 09:30:00	QQQ	ETF	102.88	102.89	102.147	102.32	6507662.0
2015-09-02 10:00:00	QQQ	ETF	102.32	102.77	102.01	102.06	3011232.0
2015-09-02 10:30:00	QQQ	ETF	102.07	102.22	101.7	102.16	4073516.0
2015-09-02 11:00:00	QQQ	ETF	102.17	102.58	102.04	102.47	2862348.0
2015-09-02 11:30:00	QQQ	ETF	102.49	102.52	101.99	102.18	2161566.0
2015-09-02 12:00:00	QQQ	ETF	102.19	102.229	101.881	102.13	1225533.0
2015-09-02 12:30:00	QQQ	ETF	102.125	102.83	102.1	102.79	2136863.0

> showing 50 of 13,248 rows — these rows as CSV

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