PREVIEW / etf_5min / 2011-09-14

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-09-14.parquet
  size:    900 KB
  rows:    36,572

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-14 04:05:00	SPY	ETF	117.45	117.45	117.45	117.45	100.0
2011-09-14 04:15:00	SPY	ETF	117.63	117.63	117.63	117.63	500.0
2011-09-14 04:20:00	SPY	ETF	117.5	117.5	117.4	117.4	1250.0
2011-09-14 04:25:00	SPY	ETF	117.25	117.25	117.25	117.25	100.0
2011-09-14 04:30:00	SPY	ETF	117.2	117.2	117.01	117.2	3200.0
2011-09-14 04:35:00	SPY	ETF	117.19	117.2	117.19	117.2	500.0
2011-09-14 04:40:00	SPY	ETF	117.3	117.3	117.3	117.3	500.0
2011-09-14 04:50:00	SPY	ETF	117.37	117.37	117.37	117.37	100.0
2011-09-14 05:00:00	SPY	ETF	117.11	117.11	117.11	117.11	300.0
2011-09-14 05:05:00	SPY	ETF	117.01	117.09	117.01	117.09	600.0
2011-09-14 05:20:00	SPY	ETF	117.15	117.15	117.15	117.15	2100.0
2011-09-14 05:25:00	SPY	ETF	117.29	117.29	117.2	117.2	300.0
2011-09-14 05:30:00	SPY	ETF	117.25	117.3	117.25	117.27	400.0
2011-09-14 05:35:00	SPY	ETF	117.34	117.34	117.34	117.34	100.0
2011-09-14 05:40:00	SPY	ETF	117.39	117.39	117.39	117.39	200.0
2011-09-14 05:50:00	SPY	ETF	117.41	117.41	117.41	117.41	1000.0
2011-09-14 05:55:00	SPY	ETF	117.59	117.59	117.51	117.57	4000.0
2011-09-14 06:05:00	SPY	ETF	117.63	117.85	117.63	117.85	2800.0
2011-09-14 06:10:00	SPY	ETF	117.78	117.8	117.69	117.72	1600.0
2011-09-14 06:20:00	SPY	ETF	117.71	117.71	117.71	117.71	170.0
2011-09-14 06:25:00	SPY	ETF	117.85	117.9	117.85	117.9	3200.0
2011-09-14 06:30:00	SPY	ETF	117.9	118.19	117.9	118.09	7542.0
2011-09-14 06:35:00	SPY	ETF	118.03	118.14	118.03	118.12	10800.0
2011-09-14 06:40:00	SPY	ETF	118.01	118.01	118.0	118.0	2600.0
2011-09-14 06:45:00	SPY	ETF	118.13	118.4	118.13	118.4	106955.0
2011-09-14 06:50:00	SPY	ETF	118.38	118.49	118.35	118.49	101625.0
2011-09-14 06:55:00	SPY	ETF	118.4	118.42	118.3	118.3	53100.0
2011-09-14 07:00:00	SPY	ETF	118.3	118.62	118.3	118.54	114395.0
2011-09-14 07:05:00	SPY	ETF	118.55	118.74	118.55	118.63	79615.0
2011-09-14 07:10:00	SPY	ETF	118.62	118.62	118.48	118.5	149250.0
2011-09-14 07:15:00	SPY	ETF	118.5	118.55	118.42	118.45	20140.0
2011-09-14 07:20:00	SPY	ETF	118.45	118.55	118.45	118.55	205250.0
2011-09-14 07:25:00	SPY	ETF	118.55	118.65	118.49	118.57	152520.0
2011-09-14 07:30:00	SPY	ETF	118.54	118.65	118.54	118.57	16409.0
2011-09-14 07:35:00	SPY	ETF	118.54	118.54	118.41	118.46	112875.0
2011-09-14 07:40:00	SPY	ETF	118.52	118.62	118.5	118.62	69900.0
2011-09-14 07:45:00	SPY	ETF	118.62	118.73	118.61	118.62	115300.0
2011-09-14 07:50:00	SPY	ETF	118.61	118.87	118.6	118.84	170510.0
2011-09-14 07:55:00	SPY	ETF	118.84	118.9	118.8	118.9	85920.0
2011-09-14 08:00:00	SPY	ETF	118.9	118.9	117.1	118.81	673737.0
2011-09-14 08:05:00	SPY	ETF	118.81	118.84	118.495	118.82	362050.0
2011-09-14 08:10:00	SPY	ETF	118.82	118.82	118.63	118.65	90580.0
2011-09-14 08:15:00	SPY	ETF	118.65	118.67	118.56	118.67	170267.0
2011-09-14 08:20:00	SPY	ETF	118.68	118.7	118.6	118.68	157611.0
2011-09-14 08:25:00	SPY	ETF	118.68	118.68	118.47	118.55	148517.0
2011-09-14 08:30:00	SPY	ETF	118.55	118.55	118.24	118.36	785117.0
2011-09-14 08:35:00	SPY	ETF	118.36	118.42	118.11	118.27	558375.0
2011-09-14 08:40:00	SPY	ETF	118.26	118.61	118.2	118.57	571788.0
2011-09-14 08:45:00	SPY	ETF	118.56	118.64	118.48	118.56	293715.0
2011-09-14 08:50:00	SPY	ETF	118.57	118.6	118.32	118.37	473388.0

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

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