PREVIEW / etf_5min / 2015-03-06

all etf 5-min files

  file:    by_date/etf_5min/2015/2015-03-06.parquet
  size:    1.2 MB
  rows:    51,389

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-03-06 04:15:00	SPY	ETF	210.4	210.4	210.4	210.4	100.0
2015-03-06 04:25:00	SPY	ETF	210.45	210.48	210.45	210.48	600.0
2015-03-06 04:30:00	SPY	ETF	210.51	210.51	210.51	210.51	200.0
2015-03-06 04:40:00	SPY	ETF	210.49	210.49	210.49	210.49	200.0
2015-03-06 04:55:00	SPY	ETF	210.45	210.45	210.45	210.45	200.0
2015-03-06 05:00:00	SPY	ETF	210.42	210.42	210.42	210.42	200.0
2015-03-06 06:10:00	SPY	ETF	210.43	210.45	210.43	210.45	400.0
2015-03-06 06:15:00	SPY	ETF	210.44	210.44	210.44	210.44	163.0
2015-03-06 06:20:00	SPY	ETF	210.44	210.44	210.42	210.42	1000.0
2015-03-06 06:25:00	SPY	ETF	210.43	210.43	210.42	210.42	200.0
2015-03-06 06:30:00	SPY	ETF	210.36	210.41	210.36	210.41	500.0
2015-03-06 06:35:00	SPY	ETF	210.38	210.38	210.38	210.38	200.0
2015-03-06 06:45:00	SPY	ETF	210.38	210.38	210.38	210.38	200.0
2015-03-06 06:55:00	SPY	ETF	210.35	210.37	210.34	210.37	500.0
2015-03-06 07:00:00	SPY	ETF	210.35	210.35	210.35	210.35	300.0
2015-03-06 07:05:00	SPY	ETF	210.32	210.35	210.32	210.35	400.0
2015-03-06 07:10:00	SPY	ETF	210.37	210.37	210.37	210.37	100.0
2015-03-06 07:15:00	SPY	ETF	210.4	210.43	210.4	210.43	5690.0
2015-03-06 07:20:00	SPY	ETF	210.4	210.43	210.4	210.43	300.0
2015-03-06 07:25:00	SPY	ETF	210.46	210.49	210.45	210.45	8070.0
2015-03-06 07:30:00	SPY	ETF	210.41	210.44	210.41	210.44	2200.0
2015-03-06 07:35:00	SPY	ETF	210.5	210.5	210.47	210.47	400.0
2015-03-06 07:40:00	SPY	ETF	210.48	210.48	210.48	210.48	20100.0
2015-03-06 07:45:00	SPY	ETF	210.46	210.46	210.45	210.45	1140.0
2015-03-06 07:50:00	SPY	ETF	210.44	210.5	210.44	210.5	5500.0
2015-03-06 07:55:00	SPY	ETF	210.58	210.79	210.58	210.77	8978.0
2015-03-06 08:00:00	SPY	ETF	210.74	210.75	210.47	210.7	15095.0
2015-03-06 08:05:00	SPY	ETF	210.68	210.71	210.64	210.66	17815.0
2015-03-06 08:10:00	SPY	ETF	210.64	210.68	210.6	210.64	4602.0
2015-03-06 08:15:00	SPY	ETF	210.63	210.63	210.52	210.579	18000.0
2015-03-06 08:20:00	SPY	ETF	210.57	210.58	210.52	210.57	51678.0
2015-03-06 08:25:00	SPY	ETF	210.52	210.59	210.45	210.59	109014.0
2015-03-06 08:30:00	SPY	ETF	210.57	210.89	210.25	210.6	1354314.0
2015-03-06 08:35:00	SPY	ETF	210.6	210.66	210.12	210.23	859745.0
2015-03-06 08:40:00	SPY	ETF	210.24	210.37	210.07	210.07	744529.0
2015-03-06 08:45:00	SPY	ETF	210.09	210.11	209.73	209.85	797302.0
2015-03-06 08:50:00	SPY	ETF	209.84	210.01	209.78	209.96	445908.0
2015-03-06 08:55:00	SPY	ETF	209.95	209.98	209.8	209.82	213836.0
2015-03-06 09:00:00	SPY	ETF	209.82	209.99	209.7	209.7	418760.0
2015-03-06 09:05:00	SPY	ETF	209.71	209.8	209.49	209.68	392535.0
2015-03-06 09:10:00	SPY	ETF	209.69	209.77	209.65	209.71	115478.0
2015-03-06 09:15:00	SPY	ETF	209.72	209.73	209.57	209.64	165837.0
2015-03-06 09:20:00	SPY	ETF	209.64	209.72	209.38	209.41	464860.0
2015-03-06 09:25:00	SPY	ETF	209.42	209.44	209.15	209.42	1360670.0
2015-03-06 09:30:00	SPY	ETF	209.42	209.57	209.27	209.52	2987498.0
2015-03-06 09:35:00	SPY	ETF	209.515	209.66	209.44	209.54	2553788.0
2015-03-06 09:40:00	SPY	ETF	209.53	209.82	209.53	209.73	1380040.0
2015-03-06 09:45:00	SPY	ETF	209.73	209.8	209.67	209.67	1037019.0
2015-03-06 09:50:00	SPY	ETF	209.68	209.79	209.46	209.77	1943494.0
2015-03-06 09:55:00	SPY	ETF	209.77	209.93	209.76	209.8301	2510638.0

> showing 50 of 51,389 rows — these rows as CSV

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