PREVIEW / etf_5min / 2013-10-01

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-01.parquet
  size:    998 KB
  rows:    42,274

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
2013-10-01 04:00:00	SPY	ETF	168.65	168.84	168.65	168.84	900.0
2013-10-01 04:05:00	SPY	ETF	168.81	168.84	168.75	168.76	4100.0
2013-10-01 04:10:00	SPY	ETF	168.75	168.8	168.75	168.78	2000.0
2013-10-01 04:15:00	SPY	ETF	168.8	168.8	168.74	168.74	1200.0
2013-10-01 04:20:00	SPY	ETF	168.72	168.74	168.72	168.72	1600.0
2013-10-01 04:25:00	SPY	ETF	168.7	168.72	168.7	168.7	600.0
2013-10-01 04:30:00	SPY	ETF	168.68	168.72	168.68	168.72	4300.0
2013-10-01 04:35:00	SPY	ETF	168.7	168.7	168.68	168.68	11100.0
2013-10-01 04:40:00	SPY	ETF	168.68	168.7	168.68	168.7	500.0
2013-10-01 04:45:00	SPY	ETF	168.68	168.68	168.68	168.68	300.0
2013-10-01 04:50:00	SPY	ETF	168.7	168.72	168.7	168.72	500.0
2013-10-01 05:00:00	SPY	ETF	168.74	168.76	168.73	168.73	1800.0
2013-10-01 05:05:00	SPY	ETF	168.72	168.72	168.6	168.6	2500.0
2013-10-01 05:10:00	SPY	ETF	168.6	168.66	168.58	168.59	3180.0
2013-10-01 05:15:00	SPY	ETF	168.56	168.6	168.44	168.5	5780.0
2013-10-01 05:20:00	SPY	ETF	168.52	168.59	168.48	168.59	2400.0
2013-10-01 05:25:00	SPY	ETF	168.56	168.62	168.5	168.62	2000.0
2013-10-01 05:30:00	SPY	ETF	168.64	168.69	168.64	168.69	5200.0
2013-10-01 05:35:00	SPY	ETF	168.68	168.69	168.67	168.67	782.0
2013-10-01 05:40:00	SPY	ETF	168.66	168.68	168.66	168.67	700.0
2013-10-01 05:45:00	SPY	ETF	168.7	168.7	168.68	168.68	4100.0
2013-10-01 05:50:00	SPY	ETF	168.66	168.72	168.65	168.7	1500.0
2013-10-01 05:55:00	SPY	ETF	168.68	168.68	168.6	168.6	2400.0
2013-10-01 06:00:00	SPY	ETF	168.6	168.67	168.6	168.64	2100.0
2013-10-01 06:05:00	SPY	ETF	168.65	168.7	168.65	168.68	800.0
2013-10-01 06:10:00	SPY	ETF	168.68	168.68	168.68	168.68	158.0
2013-10-01 06:15:00	SPY	ETF	168.7	168.72	168.7	168.72	700.0
2013-10-01 06:20:00	SPY	ETF	168.68	168.72	168.68	168.72	1700.0
2013-10-01 06:25:00	SPY	ETF	168.7	168.7	168.65	168.65	3100.0
2013-10-01 06:30:00	SPY	ETF	168.68	168.7	168.68	168.68	15500.0
2013-10-01 06:35:00	SPY	ETF	168.69	168.72	168.62	168.62	31406.0
2013-10-01 06:40:00	SPY	ETF	168.64	168.66	168.64	168.65	1400.0
2013-10-01 06:45:00	SPY	ETF	168.64	168.7	168.64	168.7	3824.0
2013-10-01 06:50:00	SPY	ETF	168.69	168.69	168.62	168.62	12400.0
2013-10-01 06:55:00	SPY	ETF	168.62	168.62	168.62	168.62	300.0
2013-10-01 07:00:00	SPY	ETF	168.61	168.62	168.58	168.59	15100.0
2013-10-01 07:05:00	SPY	ETF	168.58	168.6	168.58	168.6	2300.0
2013-10-01 07:10:00	SPY	ETF	168.58	168.59	168.55	168.56	12200.0
2013-10-01 07:15:00	SPY	ETF	168.55	168.55	168.48	168.49	9558.0
2013-10-01 07:20:00	SPY	ETF	168.46	168.48	168.42	168.44	22100.0
2013-10-01 07:25:00	SPY	ETF	168.44	168.44	168.31	168.34	45600.0
2013-10-01 07:30:00	SPY	ETF	168.35	168.35	168.32	168.35	68500.0
2013-10-01 07:35:00	SPY	ETF	168.37	168.37	168.29	168.3	89030.0
2013-10-01 07:40:00	SPY	ETF	168.29	168.3	168.26	168.28	18385.0
2013-10-01 07:45:00	SPY	ETF	168.3	168.31	168.27	168.31	23800.0
2013-10-01 07:50:00	SPY	ETF	168.32	168.42	168.32	168.38	9508.0
2013-10-01 07:55:00	SPY	ETF	168.4	168.42	168.38	168.4	7900.0
2013-10-01 08:00:00	SPY	ETF	168.39	168.58	168.26	168.38	68593.0
2013-10-01 08:05:00	SPY	ETF	168.38	168.42	168.36	168.41	54580.0
2013-10-01 08:10:00	SPY	ETF	168.39	168.4	168.29	168.29	32400.0

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

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