PREVIEW / etf_5min / 2011-09-29

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-09-29.parquet
  size:    936 KB
  rows:    38,062

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
2011-09-29 04:00:00	SPY	ETF	116.2	116.6	116.2	116.52	2792.0
2011-09-29 04:05:00	SPY	ETF	116.55	116.55	116.55	116.55	100.0
2011-09-29 04:15:00	SPY	ETF	116.62	116.62	116.62	116.62	500.0
2011-09-29 04:20:00	SPY	ETF	116.58	116.58	116.47	116.47	800.0
2011-09-29 04:30:00	SPY	ETF	116.34	116.45	116.34	116.45	300.0
2011-09-29 04:35:00	SPY	ETF	116.49	116.49	116.49	116.49	100.0
2011-09-29 04:40:00	SPY	ETF	116.6	116.6	116.6	116.6	100.0
2011-09-29 04:45:00	SPY	ETF	116.57	116.57	116.57	116.57	200.0
2011-09-29 04:50:00	SPY	ETF	116.49	116.53	116.49	116.53	200.0
2011-09-29 04:55:00	SPY	ETF	116.55	116.55	116.55	116.55	1100.0
2011-09-29 05:00:00	SPY	ETF	116.5	116.5	116.5	116.5	150.0
2011-09-29 05:05:00	SPY	ETF	116.59	116.59	116.59	116.59	350.0
2011-09-29 05:10:00	SPY	ETF	116.66	116.77	116.66	116.69	11050.0
2011-09-29 05:15:00	SPY	ETF	116.7	116.72	116.67	116.72	11800.0
2011-09-29 05:20:00	SPY	ETF	116.68	116.68	116.46	116.46	500.0
2011-09-29 05:25:00	SPY	ETF	116.5	116.52	116.4	116.52	400.0
2011-09-29 05:30:00	SPY	ETF	116.43	116.47	116.37	116.47	4000.0
2011-09-29 05:35:00	SPY	ETF	116.28	116.32	116.22	116.22	5900.0
2011-09-29 05:40:00	SPY	ETF	116.33	116.35	116.33	116.35	200.0
2011-09-29 05:45:00	SPY	ETF	116.3	116.4	116.3	116.32	19771.0
2011-09-29 05:50:00	SPY	ETF	116.32	116.61	116.32	116.61	22099.0
2011-09-29 06:00:00	SPY	ETF	116.57	116.68	116.57	116.62	450.0
2011-09-29 06:05:00	SPY	ETF	116.5	116.69	116.5	116.65	2200.0
2011-09-29 06:10:00	SPY	ETF	116.69	116.94	116.64	116.64	3451.0
2011-09-29 06:15:00	SPY	ETF	116.65	116.68	116.45	116.57	6650.0
2011-09-29 06:20:00	SPY	ETF	116.35	116.5	116.34	116.5	12600.0
2011-09-29 06:25:00	SPY	ETF	116.5	116.64	116.5	116.57	5900.0
2011-09-29 06:30:00	SPY	ETF	116.54	116.6	116.4	116.6	2100.0
2011-09-29 06:35:00	SPY	ETF	116.39	116.49	116.37	116.37	3700.0
2011-09-29 06:40:00	SPY	ETF	116.35	116.53	116.31	116.46	2800.0
2011-09-29 06:45:00	SPY	ETF	116.35	116.6	116.3	116.6	50900.0
2011-09-29 06:50:00	SPY	ETF	116.48	116.53	116.44	116.44	8400.0
2011-09-29 06:55:00	SPY	ETF	116.47	116.47	116.08	116.1	46870.0
2011-09-29 07:00:00	SPY	ETF	116.1	116.15	115.9	116.01	23003.0
2011-09-29 07:05:00	SPY	ETF	116.0	116.11	116.0	116.03	27900.0
2011-09-29 07:10:00	SPY	ETF	116.05	116.13	116.0	116.11	14934.0
2011-09-29 07:15:00	SPY	ETF	116.12	116.2	115.99	116.0	61500.0
2011-09-29 07:20:00	SPY	ETF	116.0	116.07	115.95	115.99	55810.0
2011-09-29 07:25:00	SPY	ETF	116.03	116.03	115.88	115.97	160450.0
2011-09-29 07:30:00	SPY	ETF	115.96	116.12	115.96	116.07	43500.0
2011-09-29 07:35:00	SPY	ETF	116.03	116.18	115.94	116.1	58300.0
2011-09-29 07:40:00	SPY	ETF	116.09	116.25	116.0	116.2	68380.0
2011-09-29 07:45:00	SPY	ETF	116.2	116.3	116.18	116.23	306400.0
2011-09-29 07:50:00	SPY	ETF	116.23	116.28	116.08	116.08	19760.0
2011-09-29 07:55:00	SPY	ETF	116.08	116.13	116.05	116.05	37650.0
2011-09-29 08:00:00	SPY	ETF	116.04	116.37	115.85	116.13	200685.0
2011-09-29 08:05:00	SPY	ETF	116.75	116.75	116.1	116.15	50050.0
2011-09-29 08:10:00	SPY	ETF	116.16	116.5	115.91	116.0	255600.0
2011-09-29 08:15:00	SPY	ETF	116.03	116.15	116.01	116.11	86420.0
2011-09-29 08:20:00	SPY	ETF	116.11	116.28	116.09	116.25	91185.0

> showing 50 of 38,062 rows — these rows as CSV

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