PREVIEW / etf_5min / 2014-08-05

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-05.parquet
  size:    1.0 MB
  rows:    44,425

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-08-05 04:00:00	SPY	ETF	193.65	193.65	193.59	193.59	877.0
2014-08-05 04:05:00	SPY	ETF	193.59	193.59	193.59	193.59	975.0
2014-08-05 04:25:00	SPY	ETF	193.8	193.8	193.8	193.8	100.0
2014-08-05 04:40:00	SPY	ETF	193.69	193.7	193.69	193.7	200.0
2014-08-05 04:50:00	SPY	ETF	193.76	193.76	193.76	193.76	205.0
2014-08-05 05:00:00	SPY	ETF	193.77	193.77	193.72	193.72	1500.0
2014-08-05 05:05:00	SPY	ETF	193.71	193.71	193.71	193.71	135.0
2014-08-05 05:15:00	SPY	ETF	193.79	193.79	193.79	193.79	300.0
2014-08-05 05:20:00	SPY	ETF	193.81	193.81	193.81	193.81	137.0
2014-08-05 05:30:00	SPY	ETF	193.67	193.67	193.67	193.67	100.0
2014-08-05 05:45:00	SPY	ETF	193.65	193.65	193.65	193.65	164.0
2014-08-05 05:50:00	SPY	ETF	193.58	193.58	193.57	193.57	1357.0
2014-08-05 06:05:00	SPY	ETF	193.51	193.51	193.48	193.48	15000.0
2014-08-05 06:10:00	SPY	ETF	193.48	193.48	193.44	193.44	5185.0
2014-08-05 06:15:00	SPY	ETF	193.42	193.42	193.41	193.41	1025.0
2014-08-05 06:20:00	SPY	ETF	193.41	193.41	193.4	193.41	700.0
2014-08-05 06:25:00	SPY	ETF	193.44	193.48	193.44	193.48	10900.0
2014-08-05 06:30:00	SPY	ETF	193.52	193.52	193.52	193.52	167.0
2014-08-05 06:35:00	SPY	ETF	193.39	193.39	193.39	193.39	500.0
2014-08-05 06:40:00	SPY	ETF	193.43	193.46	193.39	193.39	6300.0
2014-08-05 06:45:00	SPY	ETF	193.34	193.34	193.34	193.34	3000.0
2014-08-05 06:50:00	SPY	ETF	193.38	193.45	193.38	193.45	900.0
2014-08-05 06:55:00	SPY	ETF	193.42	193.48	193.42	193.44	1953.0
2014-08-05 07:00:00	SPY	ETF	193.42	193.43	193.36	193.36	8100.0
2014-08-05 07:05:00	SPY	ETF	193.41	193.41	193.32	193.32	20075.0
2014-08-05 07:10:00	SPY	ETF	193.32	193.34	193.27	193.32	6008.0
2014-08-05 07:15:00	SPY	ETF	193.32	193.33	193.27	193.27	7854.0
2014-08-05 07:20:00	SPY	ETF	193.27	193.28	193.19	193.27	112550.0
2014-08-05 07:25:00	SPY	ETF	193.3	193.32	193.24	193.25	19723.0
2014-08-05 07:30:00	SPY	ETF	193.25	193.27	193.18	193.19	21050.0
2014-08-05 07:35:00	SPY	ETF	193.19	193.23	193.15	193.23	44925.0
2014-08-05 07:40:00	SPY	ETF	193.25	193.25	193.19	193.19	69660.0
2014-08-05 07:45:00	SPY	ETF	193.23	193.23	193.19	193.2	1650.0
2014-08-05 07:50:00	SPY	ETF	193.23	193.23	193.14	193.22	14100.0
2014-08-05 07:55:00	SPY	ETF	193.22	193.22	193.12	193.15	9092.0
2014-08-05 08:00:00	SPY	ETF	193.15	193.27	193.06	193.12	98525.0
2014-08-05 08:05:00	SPY	ETF	193.55	193.55	193.0	193.05	95351.0
2014-08-05 08:10:00	SPY	ETF	193.04	193.09	192.92	192.96	110230.0
2014-08-05 08:15:00	SPY	ETF	192.96	192.99	192.91	192.93	49137.0
2014-08-05 08:20:00	SPY	ETF	192.92	193.0	192.91	193.0	83597.0
2014-08-05 08:25:00	SPY	ETF	193.0	193.0	192.91	192.95	84946.0
2014-08-05 08:30:00	SPY	ETF	192.94	192.95	192.81	192.9	163382.0
2014-08-05 08:35:00	SPY	ETF	192.9	192.92	192.76	192.84	126479.0
2014-08-05 08:40:00	SPY	ETF	192.85	192.93	192.85	192.88	102045.0
2014-08-05 08:45:00	SPY	ETF	192.88	193.0	192.86	193.0	79957.0
2014-08-05 08:50:00	SPY	ETF	192.99	193.1	192.97	193.08	296398.0
2014-08-05 08:55:00	SPY	ETF	193.07	193.11	193.06	193.08	82081.0
2014-08-05 09:00:00	SPY	ETF	193.06	193.07	193.0	193.0	49306.0
2014-08-05 09:05:00	SPY	ETF	193.01	193.05	192.94	193.0	90980.0
2014-08-05 09:10:00	SPY	ETF	192.99	193.0	192.95	192.97	37132.0

> showing 50 of 44,425 rows — these rows as CSV

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