PREVIEW / etf_5min / 2013-01-17

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-17.parquet
  size:    957 KB
  rows:    40,787

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-01-17 04:00:00	SPY	ETF	146.85	146.85	146.85	146.85	200.0
2013-01-17 04:05:00	SPY	ETF	147.0	147.0	147.0	147.0	100.0
2013-01-17 04:10:00	SPY	ETF	147.03	147.03	147.03	147.03	5000.0
2013-01-17 05:10:00	SPY	ETF	146.91	146.91	146.91	146.91	180.0
2013-01-17 05:30:00	SPY	ETF	146.93	146.93	146.93	146.93	100.0
2013-01-17 05:35:00	SPY	ETF	147.0	147.0	147.0	147.0	100.0
2013-01-17 05:45:00	SPY	ETF	146.95	146.95	146.95	146.95	5000.0
2013-01-17 05:55:00	SPY	ETF	147.03	147.03	147.03	147.03	100.0
2013-01-17 06:30:00	SPY	ETF	146.96	146.96	146.96	146.96	200.0
2013-01-17 06:35:00	SPY	ETF	146.96	147.02	146.96	147.02	376.0
2013-01-17 06:40:00	SPY	ETF	147.04	147.06	147.04	147.06	13200.0
2013-01-17 06:45:00	SPY	ETF	147.07	147.07	147.05	147.05	700.0
2013-01-17 06:50:00	SPY	ETF	147.07	147.13	147.07	147.1	21100.0
2013-01-17 06:55:00	SPY	ETF	147.1	147.1	147.09	147.09	800.0
2013-01-17 07:00:00	SPY	ETF	147.17	147.18	147.15	147.17	37110.0
2013-01-17 07:05:00	SPY	ETF	147.17	147.26	147.17	147.26	105882.0
2013-01-17 07:10:00	SPY	ETF	147.23	147.26	147.23	147.23	20295.0
2013-01-17 07:15:00	SPY	ETF	147.23	147.23	147.21	147.22	9700.0
2013-01-17 07:20:00	SPY	ETF	147.22	147.24	147.22	147.24	10350.0
2013-01-17 07:25:00	SPY	ETF	147.22	147.22	147.17	147.18	12691.0
2013-01-17 07:30:00	SPY	ETF	147.18	147.23	147.17	147.23	8836.0
2013-01-17 07:35:00	SPY	ETF	147.24	147.24	147.2	147.2	4082.0
2013-01-17 07:40:00	SPY	ETF	147.2	147.21	147.18	147.18	2500.0
2013-01-17 07:45:00	SPY	ETF	147.19	147.21	147.18	147.2	8700.0
2013-01-17 07:50:00	SPY	ETF	147.19	147.25	147.19	147.25	26500.0
2013-01-17 07:55:00	SPY	ETF	147.25	147.25	147.17	147.2	48600.0
2013-01-17 08:00:00	SPY	ETF	147.17	147.22	147.08	147.18	93470.0
2013-01-17 08:05:00	SPY	ETF	147.18	147.18	147.07	147.1	47864.0
2013-01-17 08:10:00	SPY	ETF	147.1	147.13	147.09	147.1	141500.0
2013-01-17 08:15:00	SPY	ETF	147.12	147.16	147.1	147.15	61602.0
2013-01-17 08:20:00	SPY	ETF	147.16	147.38	147.16	147.35	203676.0
2013-01-17 08:25:00	SPY	ETF	147.35	147.45	147.32	147.34	190427.0
2013-01-17 08:30:00	SPY	ETF	147.35	147.63	147.35	147.52	814341.0
2013-01-17 08:35:00	SPY	ETF	147.53	147.58	147.53	147.57	182455.0
2013-01-17 08:40:00	SPY	ETF	147.56	147.66	147.55	147.66	205805.0
2013-01-17 08:45:00	SPY	ETF	147.65	147.97	147.65	147.88	742306.0
2013-01-17 08:50:00	SPY	ETF	147.89	147.9	147.8	147.84	246902.0
2013-01-17 08:55:00	SPY	ETF	147.84	147.85	147.75	147.76	158458.0
2013-01-17 09:00:00	SPY	ETF	147.76	147.81	147.05	147.05	97829.0
2013-01-17 09:05:00	SPY	ETF	147.8	147.82	147.72	147.72	119070.0
2013-01-17 09:10:00	SPY	ETF	147.73	147.76	147.67	147.7	355134.0
2013-01-17 09:15:00	SPY	ETF	147.7	147.71	147.65	147.69	94454.0
2013-01-17 09:20:00	SPY	ETF	147.69	147.71	147.65	147.69	393170.0
2013-01-17 09:25:00	SPY	ETF	147.68	147.72	147.65	147.69	381932.0
2013-01-17 09:30:00	SPY	ETF	147.7	147.73	147.62	147.721	4586940.0
2013-01-17 09:35:00	SPY	ETF	147.725	147.725	147.52	147.56	2596936.0
2013-01-17 09:40:00	SPY	ETF	147.57	147.57	147.46	147.491	3721158.0
2013-01-17 09:45:00	SPY	ETF	147.495	147.5	147.43	147.4601	1493587.0
2013-01-17 09:50:00	SPY	ETF	147.46	147.55	147.45	147.53	1455485.0
2013-01-17 09:55:00	SPY	ETF	147.52	147.66	147.52	147.66	1446026.0

> showing 50 of 40,787 rows — these rows as CSV

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