PREVIEW / etf_5min / 2014-10-15

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-15.parquet
  size:    1.3 MB
  rows:    56,095

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-10-15 04:00:00	SPY	ETF	187.83	187.83	187.41	187.41	1741.0
2014-10-15 04:05:00	SPY	ETF	187.53	187.58	187.5	187.58	10512.0
2014-10-15 04:10:00	SPY	ETF	187.51	187.51	187.32	187.36	1400.0
2014-10-15 04:15:00	SPY	ETF	187.38	187.55	187.38	187.52	2541.0
2014-10-15 04:20:00	SPY	ETF	187.48	187.61	187.48	187.61	1215.0
2014-10-15 04:25:00	SPY	ETF	187.65	187.65	187.61	187.63	500.0
2014-10-15 04:35:00	SPY	ETF	187.65	187.65	187.48	187.48	1870.0
2014-10-15 04:40:00	SPY	ETF	187.55	187.55	187.5	187.5	1444.0
2014-10-15 04:45:00	SPY	ETF	187.48	187.5	187.46	187.46	5685.0
2014-10-15 04:50:00	SPY	ETF	187.45	187.45	187.27	187.3	7250.0
2014-10-15 04:55:00	SPY	ETF	187.34	187.37	187.32	187.36	39743.0
2014-10-15 05:00:00	SPY	ETF	187.33	187.33	187.21	187.27	19870.0
2014-10-15 05:05:00	SPY	ETF	187.3	187.3	187.19	187.21	41666.0
2014-10-15 05:10:00	SPY	ETF	187.22	187.3	187.22	187.3	45000.0
2014-10-15 05:15:00	SPY	ETF	187.31	187.43	187.29	187.29	36150.0
2014-10-15 05:20:00	SPY	ETF	187.31	187.32	187.15	187.31	3500.0
2014-10-15 05:25:00	SPY	ETF	187.32	187.37	187.29	187.3	8165.0
2014-10-15 05:30:00	SPY	ETF	187.35	187.4	187.34	187.36	54250.0
2014-10-15 05:35:00	SPY	ETF	187.46	187.56	187.41	187.56	13312.0
2014-10-15 05:40:00	SPY	ETF	187.61	187.61	187.52	187.52	12552.0
2014-10-15 05:45:00	SPY	ETF	187.55	187.56	187.51	187.56	1454.0
2014-10-15 05:50:00	SPY	ETF	187.6	187.82	187.6	187.7	96691.0
2014-10-15 05:55:00	SPY	ETF	187.69	187.71	187.67	187.67	600.0
2014-10-15 06:00:00	SPY	ETF	187.63	187.72	187.57	187.72	82250.0
2014-10-15 06:05:00	SPY	ETF	187.74	187.79	187.74	187.79	14733.0
2014-10-15 06:10:00	SPY	ETF	187.78	187.78	187.78	187.78	166.0
2014-10-15 06:15:00	SPY	ETF	187.86	187.86	187.76	187.76	23055.0
2014-10-15 06:20:00	SPY	ETF	187.76	187.81	187.76	187.79	1575.0
2014-10-15 06:25:00	SPY	ETF	187.76	187.76	187.62	187.66	5585.0
2014-10-15 06:30:00	SPY	ETF	187.66	187.76	187.6	187.6	22300.0
2014-10-15 06:35:00	SPY	ETF	187.61	187.65	187.58	187.65	33600.0
2014-10-15 06:40:00	SPY	ETF	187.64	187.87	187.64	187.86	13227.0
2014-10-15 06:45:00	SPY	ETF	187.86	187.86	187.57	187.57	25934.0
2014-10-15 06:50:00	SPY	ETF	187.6	187.69	187.6	187.65	40201.0
2014-10-15 06:55:00	SPY	ETF	187.6	187.6	187.5	187.52	36532.0
2014-10-15 07:00:00	SPY	ETF	187.54	187.69	187.54	187.6	16343.0
2014-10-15 07:05:00	SPY	ETF	187.59	187.6	187.4	187.43	24820.0
2014-10-15 07:10:00	SPY	ETF	187.41	187.56	187.41	187.47	54050.0
2014-10-15 07:15:00	SPY	ETF	187.46	187.46	186.46	186.64	185608.0
2014-10-15 07:20:00	SPY	ETF	186.68	186.96	186.65	186.8	178707.0
2014-10-15 07:25:00	SPY	ETF	186.78	186.84	186.65	186.65	57465.0
2014-10-15 07:30:00	SPY	ETF	186.69	186.9	186.6	186.63	152130.0
2014-10-15 07:35:00	SPY	ETF	186.62	186.65	186.34	186.62	114190.0
2014-10-15 07:40:00	SPY	ETF	186.62	186.79	186.59	186.73	249246.0
2014-10-15 07:45:00	SPY	ETF	186.66	186.84	186.55	186.8	53575.0
2014-10-15 07:50:00	SPY	ETF	186.8	186.8	186.34	186.41	169975.0
2014-10-15 07:55:00	SPY	ETF	186.41	186.49	186.3	186.34	98793.0
2014-10-15 08:00:00	SPY	ETF	186.32	187.36	186.23	186.36	357518.0
2014-10-15 08:05:00	SPY	ETF	186.4	186.43	186.29	186.32	85326.0
2014-10-15 08:10:00	SPY	ETF	186.29	186.74	186.23	186.72	606509.0

> showing 50 of 56,095 rows — these rows as CSV

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