PREVIEW / etf_5min / 2014-10-01

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-01.parquet
  size:    1.2 MB
  rows:    49,987

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-01 04:00:00	SPY	ETF	196.75	196.95	196.75	196.93	960.0
2014-10-01 04:15:00	SPY	ETF	196.88	196.92	196.88	196.92	900.0
2014-10-01 04:20:00	SPY	ETF	196.94	196.94	196.94	196.94	101.0
2014-10-01 04:25:00	SPY	ETF	196.91	196.98	196.91	196.98	24498.0
2014-10-01 04:40:00	SPY	ETF	196.97	196.97	196.96	196.96	811.0
2014-10-01 04:45:00	SPY	ETF	196.99	197.09	196.99	196.99	17000.0
2014-10-01 04:50:00	SPY	ETF	197.01	197.01	196.97	196.97	6100.0
2014-10-01 04:55:00	SPY	ETF	197.01	197.02	197.01	197.02	15374.0
2014-10-01 05:00:00	SPY	ETF	197.06	197.06	197.03	197.03	6200.0
2014-10-01 05:05:00	SPY	ETF	197.01	197.09	197.0	197.09	739.0
2014-10-01 05:10:00	SPY	ETF	196.99	196.99	196.99	196.99	800.0
2014-10-01 05:15:00	SPY	ETF	196.95	196.95	196.95	196.95	100.0
2014-10-01 05:20:00	SPY	ETF	196.99	196.99	196.96	196.96	4249.0
2014-10-01 05:25:00	SPY	ETF	196.94	196.97	196.94	196.97	4500.0
2014-10-01 05:30:00	SPY	ETF	196.97	196.97	196.94	196.94	9650.0
2014-10-01 05:35:00	SPY	ETF	196.95	196.95	196.88	196.9	17650.0
2014-10-01 05:40:00	SPY	ETF	196.9	196.92	196.85	196.85	3485.0
2014-10-01 05:50:00	SPY	ETF	196.83	196.83	196.77	196.82	335.0
2014-10-01 06:00:00	SPY	ETF	196.85	196.85	196.85	196.85	130.0
2014-10-01 06:05:00	SPY	ETF	196.86	196.86	196.86	196.86	5100.0
2014-10-01 06:10:00	SPY	ETF	196.83	196.83	196.83	196.83	10000.0
2014-10-01 06:15:00	SPY	ETF	196.85	196.86	196.85	196.86	3332.0
2014-10-01 06:20:00	SPY	ETF	196.87	196.88	196.87	196.88	4000.0
2014-10-01 06:35:00	SPY	ETF	196.9	196.92	196.9	196.92	41350.0
2014-10-01 06:40:00	SPY	ETF	196.9	196.9	196.8	196.85	8600.0
2014-10-01 06:45:00	SPY	ETF	196.81	196.82	196.81	196.82	35150.0
2014-10-01 06:50:00	SPY	ETF	196.82	196.82	196.81	196.81	5000.0
2014-10-01 06:55:00	SPY	ETF	196.87	196.87	196.86	196.86	5185.0
2014-10-01 07:00:00	SPY	ETF	196.83	196.84	196.81	196.82	2650.0
2014-10-01 07:05:00	SPY	ETF	196.83	196.83	196.76	196.77	14974.0
2014-10-01 07:10:00	SPY	ETF	196.76	196.79	196.76	196.79	57955.0
2014-10-01 07:15:00	SPY	ETF	196.82	196.94	196.82	196.89	30400.0
2014-10-01 07:20:00	SPY	ETF	196.89	196.89	196.89	196.89	200.0
2014-10-01 07:25:00	SPY	ETF	196.81	196.81	196.81	196.81	5632.0
2014-10-01 07:30:00	SPY	ETF	196.79	196.8	196.73	196.73	30200.0
2014-10-01 07:35:00	SPY	ETF	196.79	196.79	196.69	196.69	400.0
2014-10-01 07:40:00	SPY	ETF	196.68	196.68	196.62	196.62	28533.0
2014-10-01 07:45:00	SPY	ETF	196.62	196.64	196.54	196.56	140400.0
2014-10-01 07:50:00	SPY	ETF	196.56	196.62	196.56	196.62	59361.0
2014-10-01 07:55:00	SPY	ETF	196.63	196.66	196.63	196.65	57350.0
2014-10-01 08:00:00	SPY	ETF	196.79	196.79	196.52	196.54	292445.0
2014-10-01 08:05:00	SPY	ETF	196.5	196.58	196.48	196.53	57249.0
2014-10-01 08:10:00	SPY	ETF	196.57	196.68	196.57	196.67	40663.0
2014-10-01 08:15:00	SPY	ETF	196.67	196.73	196.55	196.55	82597.0
2014-10-01 08:20:00	SPY	ETF	196.53	196.56	196.26	196.3	247542.0
2014-10-01 08:25:00	SPY	ETF	196.34	196.5	196.34	196.46	58017.0
2014-10-01 08:30:00	SPY	ETF	196.48	196.48	196.32	196.42	41639.0
2014-10-01 08:35:00	SPY	ETF	196.42	196.5	196.39	196.45	306891.0
2014-10-01 08:40:00	SPY	ETF	196.46	196.59	196.44	196.56	434893.0
2014-10-01 08:45:00	SPY	ETF	196.56	196.6	196.4	196.6	222245.0

> showing 50 of 49,987 rows — these rows as CSV

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