PREVIEW / etf_5min / 2014-08-15

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-15.parquet
  size:    1019 KB
  rows:    42,488

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-15 04:00:00	SPY	ETF	196.03	196.03	196.03	196.03	300.0
2014-08-15 04:05:00	SPY	ETF	196.07	196.07	196.07	196.07	2536.0
2014-08-15 04:10:00	SPY	ETF	196.15	196.18	196.15	196.18	700.0
2014-08-15 04:15:00	SPY	ETF	196.18	196.18	196.11	196.11	796.0
2014-08-15 04:20:00	SPY	ETF	196.1	196.1	196.1	196.1	200.0
2014-08-15 04:30:00	SPY	ETF	196.25	196.3	196.25	196.3	350.0
2014-08-15 04:35:00	SPY	ETF	196.21	196.38	196.21	196.33	1000.0
2014-08-15 04:40:00	SPY	ETF	196.42	196.42	196.3	196.3	400.0
2014-08-15 04:45:00	SPY	ETF	196.3	196.3	196.3	196.3	300.0
2014-08-15 04:50:00	SPY	ETF	196.39	196.4	196.36	196.4	540.0
2014-08-15 04:55:00	SPY	ETF	196.35	196.43	196.35	196.43	986.0
2014-08-15 05:00:00	SPY	ETF	196.43	196.49	196.43	196.47	5950.0
2014-08-15 05:05:00	SPY	ETF	196.43	196.43	196.43	196.43	100.0
2014-08-15 05:10:00	SPY	ETF	196.3	196.3	196.3	196.3	100.0
2014-08-15 05:15:00	SPY	ETF	196.35	196.39	196.35	196.39	1800.0
2014-08-15 05:20:00	SPY	ETF	196.43	196.43	196.35	196.35	1125.0
2014-08-15 05:40:00	SPY	ETF	196.42	196.43	196.4	196.43	11400.0
2014-08-15 05:50:00	SPY	ETF	196.43	196.49	196.43	196.49	11200.0
2014-08-15 05:55:00	SPY	ETF	196.49	196.51	196.38	196.38	4104.0
2014-08-15 06:00:00	SPY	ETF	196.38	196.38	196.38	196.38	2502.0
2014-08-15 06:05:00	SPY	ETF	196.38	196.39	196.38	196.39	239.0
2014-08-15 06:10:00	SPY	ETF	196.35	196.35	196.34	196.34	1350.0
2014-08-15 06:15:00	SPY	ETF	196.3	196.3	196.28	196.28	1616.0
2014-08-15 06:20:00	SPY	ETF	196.35	196.35	196.35	196.35	100.0
2014-08-15 06:25:00	SPY	ETF	196.34	196.34	196.34	196.34	369.0
2014-08-15 06:30:00	SPY	ETF	196.36	196.4	196.36	196.38	6671.0
2014-08-15 06:35:00	SPY	ETF	196.39	196.41	196.39	196.41	10000.0
2014-08-15 06:40:00	SPY	ETF	196.41	196.42	196.4	196.4	15330.0
2014-08-15 06:45:00	SPY	ETF	196.4	196.45	196.4	196.42	7343.0
2014-08-15 06:50:00	SPY	ETF	196.4	196.44	196.4	196.4	19400.0
2014-08-15 07:00:00	SPY	ETF	196.44	196.45	196.4	196.45	12721.0
2014-08-15 07:05:00	SPY	ETF	196.46	196.49	196.46	196.47	22617.0
2014-08-15 07:10:00	SPY	ETF	196.43	196.47	196.41	196.47	4050.0
2014-08-15 07:15:00	SPY	ETF	196.47	196.47	196.41	196.43	41300.0
2014-08-15 07:20:00	SPY	ETF	196.44	196.44	196.38	196.39	44190.0
2014-08-15 07:25:00	SPY	ETF	196.39	196.44	196.38	196.43	14200.0
2014-08-15 07:30:00	SPY	ETF	196.45	196.45	196.41	196.42	4399.0
2014-08-15 07:35:00	SPY	ETF	196.41	196.41	196.31	196.31	6517.0
2014-08-15 07:40:00	SPY	ETF	196.31	196.36	196.31	196.32	5560.0
2014-08-15 07:45:00	SPY	ETF	196.34	196.34	196.3	196.32	5814.0
2014-08-15 07:50:00	SPY	ETF	196.32	196.33	196.32	196.33	801.0
2014-08-15 07:55:00	SPY	ETF	196.32	196.35	196.32	196.35	23350.0
2014-08-15 08:00:00	SPY	ETF	196.35	196.43	196.3	196.34	62605.0
2014-08-15 08:05:00	SPY	ETF	196.34	196.38	196.33	196.38	68892.0
2014-08-15 08:10:00	SPY	ETF	196.38	196.41	196.35	196.37	7305.0
2014-08-15 08:15:00	SPY	ETF	196.37	196.38	196.32	196.34	36568.0
2014-08-15 08:20:00	SPY	ETF	196.34	196.4	196.3	196.4	42060.0
2014-08-15 08:25:00	SPY	ETF	196.41	196.42	196.35	196.35	26423.0
2014-08-15 08:30:00	SPY	ETF	196.33	196.4	196.3	196.39	31816.0
2014-08-15 08:35:00	SPY	ETF	196.37	196.38	196.37	196.38	20705.0

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

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