PREVIEW / etf_5min / 2014-02-06

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-02-06.parquet
  size:    1.0 MB
  rows:    43,144

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
2014-02-06 04:00:00	SPY	ETF	175.26	175.3	175.25	175.3	835.0
2014-02-06 04:05:00	SPY	ETF	175.39	175.39	175.39	175.39	100.0
2014-02-06 04:10:00	SPY	ETF	175.38	175.38	175.38	175.38	193.0
2014-02-06 04:20:00	SPY	ETF	175.34	175.34	175.34	175.34	200.0
2014-02-06 04:30:00	SPY	ETF	175.38	175.5	175.38	175.5	10028.0
2014-02-06 04:35:00	SPY	ETF	175.5	175.58	175.5	175.53	6223.0
2014-02-06 04:40:00	SPY	ETF	175.57	175.62	175.57	175.62	714.0
2014-02-06 04:45:00	SPY	ETF	175.59	175.65	175.59	175.65	1600.0
2014-02-06 04:50:00	SPY	ETF	175.68	175.85	175.68	175.85	875.0
2014-02-06 04:55:00	SPY	ETF	175.84	175.9	175.84	175.85	786.0
2014-02-06 05:05:00	SPY	ETF	175.79	175.88	175.79	175.88	5260.0
2014-02-06 05:10:00	SPY	ETF	175.9	176.07	175.9	176.03	25837.0
2014-02-06 05:15:00	SPY	ETF	176.0	176.0	175.95	175.95	10106.0
2014-02-06 05:20:00	SPY	ETF	175.95	175.95	175.9	175.9	1275.0
2014-02-06 05:25:00	SPY	ETF	175.9	175.93	175.85	175.85	9759.0
2014-02-06 05:30:00	SPY	ETF	175.93	175.93	175.93	175.93	2000.0
2014-02-06 05:35:00	SPY	ETF	175.95	175.95	175.93	175.93	533.0
2014-02-06 05:40:00	SPY	ETF	175.89	175.89	175.81	175.81	800.0
2014-02-06 05:45:00	SPY	ETF	175.88	175.9	175.88	175.9	343.0
2014-02-06 05:50:00	SPY	ETF	175.9	175.9	175.87	175.87	4600.0
2014-02-06 05:55:00	SPY	ETF	175.86	175.86	175.81	175.81	172000.0
2014-02-06 06:00:00	SPY	ETF	175.78	175.78	175.74	175.78	2350.0
2014-02-06 06:20:00	SPY	ETF	175.82	175.9	175.82	175.86	2300.0
2014-02-06 06:25:00	SPY	ETF	175.81	175.81	175.8	175.8	3075.0
2014-02-06 06:30:00	SPY	ETF	175.81	175.81	175.78	175.78	46892.0
2014-02-06 06:35:00	SPY	ETF	175.75	175.75	175.75	175.75	150.0
2014-02-06 06:40:00	SPY	ETF	175.75	175.75	175.71	175.72	2900.0
2014-02-06 06:45:00	SPY	ETF	175.71	175.71	175.71	175.71	325.0
2014-02-06 06:50:00	SPY	ETF	175.8	175.81	175.77	175.77	9949.0
2014-02-06 06:55:00	SPY	ETF	175.81	175.81	175.74	175.75	4250.0
2014-02-06 07:00:00	SPY	ETF	175.73	175.78	175.73	175.76	1841.0
2014-02-06 07:05:00	SPY	ETF	175.77	175.77	175.62	175.71	33045.0
2014-02-06 07:10:00	SPY	ETF	175.7	175.7	175.64	175.66	6091.0
2014-02-06 07:15:00	SPY	ETF	175.68	175.68	175.6	175.6	12750.0
2014-02-06 07:20:00	SPY	ETF	175.59	175.63	175.44	175.46	185887.0
2014-02-06 07:25:00	SPY	ETF	175.45	175.49	175.38	175.44	74080.0
2014-02-06 07:30:00	SPY	ETF	175.42	175.44	175.34	175.44	61070.0
2014-02-06 07:35:00	SPY	ETF	175.44	175.44	175.32	175.37	102024.0
2014-02-06 07:40:00	SPY	ETF	175.4	175.5	175.4	175.5	134669.0
2014-02-06 07:45:00	SPY	ETF	175.51	175.52	174.97	175.46	259563.0
2014-02-06 07:50:00	SPY	ETF	175.4	175.62	175.4	175.61	130601.0
2014-02-06 07:55:00	SPY	ETF	175.58	175.58	175.4	175.4	36629.0
2014-02-06 08:00:00	SPY	ETF	175.4	175.86	175.33	175.5	73487.0
2014-02-06 08:05:00	SPY	ETF	175.44	175.47	175.42	175.47	25064.0
2014-02-06 08:10:00	SPY	ETF	175.52	175.55	175.45	175.55	20513.0
2014-02-06 08:15:00	SPY	ETF	175.52	175.69	175.52	175.69	44547.0
2014-02-06 08:20:00	SPY	ETF	175.68	175.88	175.67	175.86	208500.0
2014-02-06 08:25:00	SPY	ETF	175.86	175.9	175.76	175.9	292998.0
2014-02-06 08:30:00	SPY	ETF	175.9	176.01	175.46	175.54	416591.0
2014-02-06 08:35:00	SPY	ETF	175.54	175.83	175.47	175.78	246137.0

> showing 50 of 43,144 rows — these rows as CSV

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