PREVIEW / etf_5min / 2011-08-10

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-08-10.parquet
  size:    1.0 MB
  rows:    42,985

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-08-10 04:00:00	SPY	ETF	117.26	117.26	116.9	116.9	4000.0
2011-08-10 04:15:00	SPY	ETF	116.67	116.67	116.3	116.3	9600.0
2011-08-10 04:20:00	SPY	ETF	116.3	116.65	116.3	116.5	7300.0
2011-08-10 04:25:00	SPY	ETF	116.47	116.57	116.47	116.5	11200.0
2011-08-10 04:30:00	SPY	ETF	116.5	116.79	116.5	116.74	40451.0
2011-08-10 04:35:00	SPY	ETF	116.7	116.7	116.49	116.49	51749.0
2011-08-10 04:40:00	SPY	ETF	116.65	116.8	116.6	116.8	30200.0
2011-08-10 04:45:00	SPY	ETF	116.95	116.99	116.85	116.99	21200.0
2011-08-10 04:50:00	SPY	ETF	116.79	116.81	116.79	116.81	200.0
2011-08-10 04:55:00	SPY	ETF	116.9	117.0	116.9	117.0	1500.0
2011-08-10 05:00:00	SPY	ETF	117.0	117.3	117.0	117.3	9200.0
2011-08-10 05:05:00	SPY	ETF	117.49	117.6	117.49	117.6	700.0
2011-08-10 05:10:00	SPY	ETF	117.6	117.65	117.6	117.65	200.0
2011-08-10 05:15:00	SPY	ETF	117.46	117.46	117.46	117.46	200.0
2011-08-10 05:20:00	SPY	ETF	117.6	117.6	117.51	117.51	7615.0
2011-08-10 05:25:00	SPY	ETF	117.7	117.77	117.7	117.77	200.0
2011-08-10 05:30:00	SPY	ETF	117.82	117.82	117.63	117.63	400.0
2011-08-10 05:35:00	SPY	ETF	117.75	117.75	117.75	117.75	100.0
2011-08-10 05:40:00	SPY	ETF	117.42	117.44	117.42	117.44	300.0
2011-08-10 05:50:00	SPY	ETF	117.42	117.42	117.27	117.27	400.0
2011-08-10 05:55:00	SPY	ETF	117.3	117.35	117.3	117.31	1600.0
2011-08-10 06:00:00	SPY	ETF	117.27	117.27	117.12	117.17	2260.0
2011-08-10 06:05:00	SPY	ETF	117.13	117.13	117.1	117.1	600.0
2011-08-10 06:10:00	SPY	ETF	117.06	117.15	117.05	117.12	3000.0
2011-08-10 06:15:00	SPY	ETF	117.1	117.16	117.1	117.16	200.0
2011-08-10 06:20:00	SPY	ETF	117.22	117.4	117.22	117.3	15300.0
2011-08-10 06:25:00	SPY	ETF	117.37	117.4	117.3	117.38	10880.0
2011-08-10 06:30:00	SPY	ETF	117.39	117.49	117.35	117.49	13100.0
2011-08-10 06:35:00	SPY	ETF	117.46	117.46	117.35	117.35	8300.0
2011-08-10 06:40:00	SPY	ETF	117.25	117.35	117.2	117.35	5348.0
2011-08-10 06:45:00	SPY	ETF	117.33	117.33	117.33	117.33	200.0
2011-08-10 06:50:00	SPY	ETF	117.26	117.26	117.17	117.17	40900.0
2011-08-10 06:55:00	SPY	ETF	117.12	117.2	117.11	117.2	45500.0
2011-08-10 07:00:00	SPY	ETF	117.2	117.36	116.84	116.92	414115.0
2011-08-10 07:05:00	SPY	ETF	116.94	116.99	116.72	116.74	331960.0
2011-08-10 07:10:00	SPY	ETF	116.74	116.88	116.68	116.85	194111.0
2011-08-10 07:15:00	SPY	ETF	116.86	116.93	116.81	116.86	418850.0
2011-08-10 07:20:00	SPY	ETF	116.87	116.89	116.84	116.85	448995.0
2011-08-10 07:25:00	SPY	ETF	116.84	116.85	116.6	116.6	887735.0
2011-08-10 07:30:00	SPY	ETF	116.67	116.95	116.67	116.91	165280.0
2011-08-10 07:35:00	SPY	ETF	116.92	116.95	116.77	116.88	492600.0
2011-08-10 07:40:00	SPY	ETF	116.83	116.95	116.73	116.86	351151.0
2011-08-10 07:45:00	SPY	ETF	116.86	117.01	116.77	116.77	830462.0
2011-08-10 07:50:00	SPY	ETF	116.77	116.88	116.76	116.78	329006.0
2011-08-10 07:55:00	SPY	ETF	116.78	116.83	116.64	116.68	871694.0
2011-08-10 08:00:00	SPY	ETF	116.7	117.44	116.36	116.66	3157060.0
2011-08-10 08:05:00	SPY	ETF	116.37	116.5	116.34	116.46	288275.0
2011-08-10 08:10:00	SPY	ETF	116.45	116.85	116.44	116.83	338575.0
2011-08-10 08:15:00	SPY	ETF	116.83	116.84	116.5	116.58	223200.0
2011-08-10 08:20:00	SPY	ETF	116.58	116.62	116.38	116.45	538488.0

> showing 50 of 42,985 rows — these rows as CSV

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