PREVIEW / etf_5min / 2012-03-21

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-03-21.parquet
  size:    836 KB
  rows:    35,653

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
2012-03-21 04:00:00	SPY	ETF	140.64	140.76	140.64	140.76	500.0
2012-03-21 04:05:00	SPY	ETF	140.94	140.95	140.94	140.95	430.0
2012-03-21 04:15:00	SPY	ETF	140.95	140.95	140.95	140.95	100.0
2012-03-21 04:20:00	SPY	ETF	140.95	140.95	140.95	140.95	2200.0
2012-03-21 04:35:00	SPY	ETF	140.9	140.9	140.9	140.9	5000.0
2012-03-21 04:40:00	SPY	ETF	140.97	140.97	140.97	140.97	200.0
2012-03-21 04:50:00	SPY	ETF	140.92	140.92	140.92	140.92	25700.0
2012-03-21 04:55:00	SPY	ETF	140.92	140.92	140.92	140.92	10100.0
2012-03-21 05:05:00	SPY	ETF	140.9	140.9	140.9	140.9	2500.0
2012-03-21 05:10:00	SPY	ETF	140.8	140.8	140.8	140.8	500.0
2012-03-21 05:20:00	SPY	ETF	140.8	140.8	140.78	140.78	3700.0
2012-03-21 05:25:00	SPY	ETF	140.75	140.75	140.7	140.75	17600.0
2012-03-21 05:35:00	SPY	ETF	140.85	140.85	140.85	140.85	100.0
2012-03-21 05:40:00	SPY	ETF	140.86	140.86	140.86	140.86	500.0
2012-03-21 05:50:00	SPY	ETF	140.9	140.9	140.9	140.9	10000.0
2012-03-21 06:00:00	SPY	ETF	140.83	140.83	140.8	140.8	3000.0
2012-03-21 06:05:00	SPY	ETF	140.83	140.83	140.83	140.83	125.0
2012-03-21 06:10:00	SPY	ETF	140.81	140.81	140.78	140.78	250.0
2012-03-21 06:15:00	SPY	ETF	140.81	140.81	140.81	140.81	2700.0
2012-03-21 06:25:00	SPY	ETF	140.81	140.81	140.8	140.8	20000.0
2012-03-21 06:30:00	SPY	ETF	140.8	140.8	140.8	140.8	300.0
2012-03-21 06:35:00	SPY	ETF	140.78	140.78	140.77	140.78	6000.0
2012-03-21 06:40:00	SPY	ETF	140.73	140.73	140.71	140.71	400.0
2012-03-21 06:50:00	SPY	ETF	140.72	140.74	140.72	140.74	610.0
2012-03-21 07:00:00	SPY	ETF	140.74	140.77	140.74	140.76	3350.0
2012-03-21 07:05:00	SPY	ETF	140.74	140.75	140.74	140.74	1500.0
2012-03-21 07:10:00	SPY	ETF	140.78	140.78	140.7	140.71	21887.0
2012-03-21 07:15:00	SPY	ETF	140.69	140.75	140.69	140.69	12300.0
2012-03-21 07:20:00	SPY	ETF	140.71	140.72	140.71	140.72	900.0
2012-03-21 07:25:00	SPY	ETF	140.72	140.78	140.72	140.75	5400.0
2012-03-21 07:30:00	SPY	ETF	140.7	140.76	140.69	140.76	31500.0
2012-03-21 07:35:00	SPY	ETF	140.76	140.78	140.74	140.75	15686.0
2012-03-21 07:40:00	SPY	ETF	140.73	140.76	140.73	140.76	2800.0
2012-03-21 07:45:00	SPY	ETF	140.74	140.78	140.74	140.78	15300.0
2012-03-21 07:50:00	SPY	ETF	140.74	140.78	140.74	140.76	7600.0
2012-03-21 07:55:00	SPY	ETF	140.74	140.82	140.74	140.81	3300.0
2012-03-21 08:00:00	SPY	ETF	140.8	140.85	140.4287	140.79	964915.0
2012-03-21 08:05:00	SPY	ETF	140.79	140.82	140.72	140.75	19240.0
2012-03-21 08:10:00	SPY	ETF	140.75	140.78	140.72	140.75	35836.0
2012-03-21 08:15:00	SPY	ETF	140.73	140.74	140.64	140.65	48436.0
2012-03-21 08:20:00	SPY	ETF	140.65	140.65	140.51	140.56	122974.0
2012-03-21 08:25:00	SPY	ETF	140.57	140.59	140.43	140.53	85511.0
2012-03-21 08:30:00	SPY	ETF	140.53	140.53	140.44	140.48	57785.0
2012-03-21 08:35:00	SPY	ETF	140.49	140.57	140.49	140.55	112350.0
2012-03-21 08:40:00	SPY	ETF	140.54	140.56	140.45	140.53	111106.0
2012-03-21 08:45:00	SPY	ETF	140.52	140.53	140.47	140.51	67456.0
2012-03-21 08:50:00	SPY	ETF	140.5	140.54	140.48	140.5	41394.0
2012-03-21 08:55:00	SPY	ETF	140.5	140.54	140.47	140.53	49455.0
2012-03-21 09:00:00	SPY	ETF	140.51	140.55	140.49	140.54	62958.0
2012-03-21 09:05:00	SPY	ETF	140.55	140.6	140.53	140.55	63250.0

> showing 50 of 35,653 rows — these rows as CSV

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