PREVIEW / etf_5min / 2012-04-19

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-19.parquet
  size:    859 KB
  rows:    36,246

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-04-19 04:00:00	SPY	ETF	139.17	139.17	138.92	139.08	3400.0
2012-04-19 04:10:00	SPY	ETF	139.05	139.17	139.05	139.17	690.0
2012-04-19 04:20:00	SPY	ETF	139.16	139.16	139.16	139.16	440.0
2012-04-19 04:35:00	SPY	ETF	139.16	139.16	138.98	139.0	18700.0
2012-04-19 04:40:00	SPY	ETF	139.1	139.38	139.1	139.2	2300.0
2012-04-19 04:45:00	SPY	ETF	139.0	139.0	139.0	139.0	1000.0
2012-04-19 04:55:00	SPY	ETF	138.8	138.95	138.78	138.95	1900.0
2012-04-19 05:10:00	SPY	ETF	138.85	138.85	138.85	138.85	200.0
2012-04-19 05:15:00	SPY	ETF	138.93	139.07	138.93	139.07	3100.0
2012-04-19 05:20:00	SPY	ETF	139.0	139.01	139.0	139.01	3400.0
2012-04-19 05:40:00	SPY	ETF	139.14	139.14	139.14	139.14	10000.0
2012-04-19 05:45:00	SPY	ETF	139.17	139.17	139.14	139.14	1000.0
2012-04-19 05:55:00	SPY	ETF	139.2	139.23	139.2	139.23	1000.0
2012-04-19 06:00:00	SPY	ETF	139.19	139.19	139.19	139.19	1500.0
2012-04-19 06:05:00	SPY	ETF	139.17	139.19	139.14	139.14	10500.0
2012-04-19 06:10:00	SPY	ETF	139.15	139.15	139.1	139.11	40000.0
2012-04-19 06:15:00	SPY	ETF	139.1	139.13	139.1	139.11	2700.0
2012-04-19 06:20:00	SPY	ETF	139.1	139.17	139.1	139.11	2100.0
2012-04-19 06:25:00	SPY	ETF	139.08	139.08	139.08	139.08	500.0
2012-04-19 06:30:00	SPY	ETF	139.05	139.05	139.0	139.04	38400.0
2012-04-19 06:35:00	SPY	ETF	139.07	139.11	139.05	139.05	11100.0
2012-04-19 06:40:00	SPY	ETF	139.05	139.06	139.04	139.06	11500.0
2012-04-19 06:45:00	SPY	ETF	139.06	139.06	138.95	138.99	18800.0
2012-04-19 06:50:00	SPY	ETF	138.93	139.0	138.93	139.0	600.0
2012-04-19 06:55:00	SPY	ETF	139.02	139.02	139.02	139.02	500.0
2012-04-19 07:00:00	SPY	ETF	139.0	139.14	138.95	139.14	63015.0
2012-04-19 07:05:00	SPY	ETF	139.15	139.17	139.12	139.14	49932.0
2012-04-19 07:10:00	SPY	ETF	139.13	139.19	138.96	138.96	478500.0
2012-04-19 07:15:00	SPY	ETF	138.95	139.08	138.88	139.06	524920.0
2012-04-19 07:20:00	SPY	ETF	139.02	139.02	138.86	138.86	177720.0
2012-04-19 07:25:00	SPY	ETF	138.86	138.86	138.5	138.56	174461.0
2012-04-19 07:30:00	SPY	ETF	138.57	138.71	138.38	138.56	103020.0
2012-04-19 07:35:00	SPY	ETF	138.53	138.53	138.37	138.45	189715.0
2012-04-19 07:40:00	SPY	ETF	138.46	138.57	138.42	138.55	73640.0
2012-04-19 07:45:00	SPY	ETF	138.54	138.68	138.54	138.6	167149.0
2012-04-19 07:50:00	SPY	ETF	138.6	138.65	138.54	138.6	166825.0
2012-04-19 07:55:00	SPY	ETF	138.6	138.72	138.59	138.64	69400.0
2012-04-19 08:00:00	SPY	ETF	139.06	139.06	138.45	139.06	961700.0
2012-04-19 08:05:00	SPY	ETF	138.74	138.81	138.71	138.71	48215.0
2012-04-19 08:10:00	SPY	ETF	138.73	138.79	138.69	138.77	70518.0
2012-04-19 08:15:00	SPY	ETF	138.77	138.92	138.77	138.87	315090.0
2012-04-19 08:20:00	SPY	ETF	138.87	138.95	138.85	138.91	61449.0
2012-04-19 08:25:00	SPY	ETF	138.91	138.99	138.81	138.87	77336.0
2012-04-19 08:30:00	SPY	ETF	138.81	138.81	138.56	138.72	473206.0
2012-04-19 08:35:00	SPY	ETF	138.71	138.71	138.38	138.39	641768.0
2012-04-19 08:40:00	SPY	ETF	138.38	139.29	138.22	138.38	630058.0
2012-04-19 08:45:00	SPY	ETF	138.39	138.42	138.32	138.4	142300.0
2012-04-19 08:50:00	SPY	ETF	138.41	138.49	138.38	138.42	159772.0
2012-04-19 08:55:00	SPY	ETF	138.42	138.44	138.29	138.38	155763.0
2012-04-19 09:00:00	SPY	ETF	138.38	138.54	138.32	138.5	136286.0

> showing 50 of 36,246 rows — these rows as CSV

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