PREVIEW / etf_5min / 2013-06-21

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-06-21.parquet
  size:    1.1 MB
  rows:    46,793

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-06-21 04:00:00	SPY	ETF	159.97	159.97	159.8	159.84	2991.0
2013-06-21 04:05:00	SPY	ETF	159.7	159.7	159.68	159.68	700.0
2013-06-21 04:10:00	SPY	ETF	159.65	159.65	159.65	159.65	7200.0
2013-06-21 04:15:00	SPY	ETF	159.65	159.65	159.6	159.6	1700.0
2013-06-21 04:20:00	SPY	ETF	159.64	159.7	159.55	159.7	2973.0
2013-06-21 04:30:00	SPY	ETF	159.65	159.65	159.65	159.65	200.0
2013-06-21 04:35:00	SPY	ETF	159.6	159.6	159.6	159.6	100.0
2013-06-21 04:40:00	SPY	ETF	159.61	159.72	159.61	159.66	650.0
2013-06-21 04:45:00	SPY	ETF	159.7	159.7	159.65	159.65	300.0
2013-06-21 05:00:00	SPY	ETF	159.7	159.7	159.7	159.7	500.0
2013-06-21 05:10:00	SPY	ETF	159.75	159.85	159.75	159.85	10900.0
2013-06-21 05:15:00	SPY	ETF	159.84	159.84	159.84	159.84	4000.0
2013-06-21 05:20:00	SPY	ETF	159.8	159.84	159.8	159.84	7950.0
2013-06-21 05:25:00	SPY	ETF	159.85	159.91	159.85	159.88	11600.0
2013-06-21 05:30:00	SPY	ETF	159.9	159.95	159.9	159.91	8960.0
2013-06-21 05:35:00	SPY	ETF	159.95	160.05	159.95	160.0	18500.0
2013-06-21 05:40:00	SPY	ETF	160.0	160.01	159.96	160.01	6370.0
2013-06-21 05:45:00	SPY	ETF	160.05	160.07	160.05	160.07	2000.0
2013-06-21 05:50:00	SPY	ETF	160.1	160.1	160.03	160.03	10300.0
2013-06-21 05:55:00	SPY	ETF	160.12	160.12	160.05	160.05	5215.0
2013-06-21 06:00:00	SPY	ETF	160.05	160.05	160.05	160.05	285.0
2013-06-21 06:05:00	SPY	ETF	160.01	160.05	160.01	160.05	2173.0
2013-06-21 06:10:00	SPY	ETF	160.08	160.1	160.08	160.1	1200.0
2013-06-21 06:20:00	SPY	ETF	160.02	160.1	160.02	160.05	7700.0
2013-06-21 06:25:00	SPY	ETF	160.05	160.09	160.02	160.09	8700.0
2013-06-21 06:30:00	SPY	ETF	160.04	160.04	160.01	160.01	5000.0
2013-06-21 06:35:00	SPY	ETF	160.06	160.06	160.01	160.02	600.0
2013-06-21 06:40:00	SPY	ETF	160.0	160.05	160.0	160.01	15700.0
2013-06-21 06:45:00	SPY	ETF	160.0	160.0	160.0	160.0	100.0
2013-06-21 06:50:00	SPY	ETF	160.02	160.07	160.0	160.07	23276.0
2013-06-21 06:55:00	SPY	ETF	160.04	160.11	160.0	160.04	78375.0
2013-06-21 07:00:00	SPY	ETF	160.02	160.03	159.92	159.92	16384.0
2013-06-21 07:05:00	SPY	ETF	159.94	159.97	159.86	159.86	24585.0
2013-06-21 07:10:00	SPY	ETF	159.86	159.91	159.81	159.86	63150.0
2013-06-21 07:15:00	SPY	ETF	159.86	159.86	159.74	159.78	27498.0
2013-06-21 07:20:00	SPY	ETF	159.77	159.79	159.73	159.79	53188.0
2013-06-21 07:25:00	SPY	ETF	159.78	159.89	159.78	159.83	71670.0
2013-06-21 07:30:00	SPY	ETF	159.82	159.82	159.65	159.68	90165.0
2013-06-21 07:35:00	SPY	ETF	159.7	159.75	159.67	159.7	110753.0
2013-06-21 07:40:00	SPY	ETF	159.71	159.77	159.7	159.74	91105.0
2013-06-21 07:45:00	SPY	ETF	159.76	159.8	159.72	159.79	176957.0
2013-06-21 07:50:00	SPY	ETF	159.79	159.82	159.77	159.78	118085.0
2013-06-21 07:55:00	SPY	ETF	159.78	159.81	159.75	159.76	22956.0
2013-06-21 08:00:00	SPY	ETF	159.76	160.88	159.68	159.8	125296.0
2013-06-21 08:05:00	SPY	ETF	159.67	159.72	159.65	159.67	91588.0
2013-06-21 08:10:00	SPY	ETF	159.68	159.68	159.54	159.55	372399.0
2013-06-21 08:15:00	SPY	ETF	159.55	159.59	159.54	159.55	64636.0
2013-06-21 08:20:00	SPY	ETF	159.58	159.62	159.45	159.46	76987.0
2013-06-21 08:25:00	SPY	ETF	159.45	159.53	159.42	159.47	157922.0
2013-06-21 08:30:00	SPY	ETF	159.46	159.47	159.26	159.33	248787.0

> showing 50 of 46,793 rows — these rows as CSV

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