PREVIEW / etf_1min / 2015-05-21

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-05-21.parquet
  size:    2.2 MB
  rows:    116,916

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
2015-05-21 04:00:00	SPY	ETF	212.37	212.37	212.37	212.37	400.0
2015-05-21 04:02:00	SPY	ETF	212.4	212.4	212.39	212.39	300.0
2015-05-21 04:03:00	SPY	ETF	212.4	212.4	212.4	212.4	300.0
2015-05-21 04:10:00	SPY	ETF	212.47	212.47	212.47	212.47	2030.0
2015-05-21 04:11:00	SPY	ETF	212.5	212.5	212.5	212.5	1000.0
2015-05-21 04:20:00	SPY	ETF	212.41	212.41	212.41	212.41	200.0
2015-05-21 04:24:00	SPY	ETF	212.37	212.37	212.34	212.34	500.0
2015-05-21 04:25:00	SPY	ETF	212.31	212.31	212.31	212.31	125.0
2015-05-21 04:36:00	SPY	ETF	212.43	212.43	212.43	212.43	200.0
2015-05-21 04:42:00	SPY	ETF	212.37	212.37	212.37	212.37	900.0
2015-05-21 04:43:00	SPY	ETF	212.4	212.4	212.4	212.4	300.0
2015-05-21 04:55:00	SPY	ETF	212.32	212.32	212.32	212.32	900.0
2015-05-21 05:00:00	SPY	ETF	212.35	212.35	212.35	212.35	300.0
2015-05-21 05:22:00	SPY	ETF	212.33	212.33	212.33	212.33	100.0
2015-05-21 05:25:00	SPY	ETF	212.33	212.33	212.33	212.33	900.0
2015-05-21 05:26:00	SPY	ETF	212.28	212.28	212.28	212.28	100.0
2015-05-21 05:52:00	SPY	ETF	212.4	212.4	212.4	212.4	901.0
2015-05-21 05:56:00	SPY	ETF	212.37	212.43	212.37	212.43	1201.0
2015-05-21 05:58:00	SPY	ETF	212.36	212.37	212.36	212.36	500.0
2015-05-21 06:04:00	SPY	ETF	212.37	212.37	212.31	212.31	800.0
2015-05-21 06:06:00	SPY	ETF	212.33	212.33	212.33	212.33	100.0
2015-05-21 06:07:00	SPY	ETF	212.37	212.37	212.37	212.37	100.0
2015-05-21 06:10:00	SPY	ETF	212.37	212.37	212.37	212.37	200.0
2015-05-21 06:14:00	SPY	ETF	212.36	212.36	212.36	212.36	200.0
2015-05-21 06:19:00	SPY	ETF	212.4	212.4	212.4	212.4	300.0
2015-05-21 06:21:00	SPY	ETF	212.35	212.35	212.35	212.35	349.0
2015-05-21 06:27:00	SPY	ETF	212.38	212.38	212.38	212.38	200.0
2015-05-21 06:30:00	SPY	ETF	212.4	212.4	212.4	212.4	200.0
2015-05-21 06:33:00	SPY	ETF	212.4	212.4	212.4	212.4	1000.0
2015-05-21 06:35:00	SPY	ETF	212.37	212.37	212.37	212.37	100.0
2015-05-21 06:37:00	SPY	ETF	212.37	212.43	212.37	212.43	11300.0
2015-05-21 06:43:00	SPY	ETF	212.4	212.4	212.4	212.4	400.0
2015-05-21 06:44:00	SPY	ETF	212.42	212.42	212.42	212.42	2100.0
2015-05-21 06:45:00	SPY	ETF	212.42	212.42	212.38	212.4	4494.0
2015-05-21 06:51:00	SPY	ETF	212.43	212.43	212.42	212.42	3000.0
2015-05-21 06:52:00	SPY	ETF	212.41	212.41	212.38	212.38	1000.0
2015-05-21 06:55:00	SPY	ETF	212.37	212.37	212.37	212.37	750.0
2015-05-21 06:56:00	SPY	ETF	212.37	212.37	212.37	212.37	1000.0
2015-05-21 07:00:00	SPY	ETF	212.39	212.42	212.39	212.42	600.0
2015-05-21 07:02:00	SPY	ETF	212.43	212.43	212.43	212.43	2700.0
2015-05-21 07:04:00	SPY	ETF	212.42	212.42	212.42	212.42	698.0
2015-05-21 07:05:00	SPY	ETF	212.43	212.43	212.43	212.43	100.0
2015-05-21 07:06:00	SPY	ETF	212.43	212.45	212.43	212.45	325.0
2015-05-21 07:07:00	SPY	ETF	212.44	212.44	212.44	212.44	100.0
2015-05-21 07:08:00	SPY	ETF	212.45	212.45	212.45	212.45	1000.0
2015-05-21 07:09:00	SPY	ETF	212.4	212.4	212.4	212.4	201.0
2015-05-21 07:10:00	SPY	ETF	212.43	212.43	212.42	212.42	900.0
2015-05-21 07:12:00	SPY	ETF	212.41	212.41	212.41	212.41	500.0
2015-05-21 07:13:00	SPY	ETF	212.4	212.4	212.38	212.38	920.0
2015-05-21 07:14:00	SPY	ETF	212.4	212.41	212.4	212.41	600.0

> showing 50 of 116,916 rows — these rows as CSV

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