PREVIEW / etf_5min / 2013-08-20

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-08-20.parquet
  size:    973 KB
  rows:    41,320

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-08-20 04:00:00	SPY	ETF	164.8	164.8	164.8	164.8	100.0
2013-08-20 04:05:00	SPY	ETF	164.8	164.81	164.8	164.81	1400.0
2013-08-20 04:10:00	SPY	ETF	164.8	164.8	164.8	164.8	600.0
2013-08-20 04:15:00	SPY	ETF	164.81	164.81	164.81	164.81	100.0
2013-08-20 04:20:00	SPY	ETF	164.76	164.76	164.76	164.76	600.0
2013-08-20 04:25:00	SPY	ETF	164.76	164.76	164.72	164.72	520.0
2013-08-20 04:30:00	SPY	ETF	164.7	164.7	164.7	164.7	280.0
2013-08-20 04:35:00	SPY	ETF	164.74	164.74	164.72	164.74	1500.0
2013-08-20 04:40:00	SPY	ETF	164.77	164.86	164.77	164.85	3455.0
2013-08-20 04:45:00	SPY	ETF	164.89	165.0	164.89	164.97	2800.0
2013-08-20 04:50:00	SPY	ETF	164.98	164.98	164.92	164.92	900.0
2013-08-20 05:00:00	SPY	ETF	164.91	164.91	164.9	164.9	700.0
2013-08-20 05:05:00	SPY	ETF	164.9	164.92	164.9	164.9	3800.0
2013-08-20 05:10:00	SPY	ETF	164.9	164.9	164.88	164.88	3900.0
2013-08-20 05:20:00	SPY	ETF	164.85	164.86	164.85	164.86	1000.0
2013-08-20 05:25:00	SPY	ETF	164.85	164.85	164.85	164.85	1000.0
2013-08-20 05:30:00	SPY	ETF	164.84	164.84	164.8	164.8	3500.0
2013-08-20 05:35:00	SPY	ETF	164.76	164.76	164.76	164.76	600.0
2013-08-20 05:40:00	SPY	ETF	164.78	164.79	164.78	164.79	750.0
2013-08-20 05:45:00	SPY	ETF	164.76	164.76	164.72	164.72	854.0
2013-08-20 05:50:00	SPY	ETF	164.78	164.85	164.78	164.85	1600.0
2013-08-20 05:55:00	SPY	ETF	164.86	164.86	164.84	164.86	3200.0
2013-08-20 06:00:00	SPY	ETF	164.85	164.85	164.85	164.85	300.0
2013-08-20 06:05:00	SPY	ETF	164.9	164.91	164.88	164.88	23000.0
2013-08-20 06:10:00	SPY	ETF	164.88	164.88	164.87	164.87	97000.0
2013-08-20 06:15:00	SPY	ETF	164.86	164.86	164.82	164.82	59500.0
2013-08-20 06:20:00	SPY	ETF	164.8	164.84	164.79	164.84	21540.0
2013-08-20 06:30:00	SPY	ETF	164.86	164.99	164.86	164.98	7000.0
2013-08-20 06:35:00	SPY	ETF	165.0	165.02	165.0	165.02	2800.0
2013-08-20 06:40:00	SPY	ETF	165.04	165.09	165.04	165.05	11980.0
2013-08-20 06:45:00	SPY	ETF	165.09	165.09	165.08	165.08	5580.0
2013-08-20 06:50:00	SPY	ETF	165.11	165.12	165.08	165.08	21000.0
2013-08-20 06:55:00	SPY	ETF	165.06	165.06	164.98	164.98	4400.0
2013-08-20 07:00:00	SPY	ETF	165.0	165.14	165.0	165.12	41900.0
2013-08-20 07:05:00	SPY	ETF	165.13	165.16	165.05	165.06	9300.0
2013-08-20 07:10:00	SPY	ETF	165.05	165.05	165.02	165.02	13870.0
2013-08-20 07:15:00	SPY	ETF	165.04	165.08	165.03	165.05	5500.0
2013-08-20 07:20:00	SPY	ETF	165.08	165.28	165.08	165.28	68822.0
2013-08-20 07:25:00	SPY	ETF	165.29	165.32	165.28	165.3	20100.0
2013-08-20 07:30:00	SPY	ETF	165.29	165.31	165.27	165.31	94000.0
2013-08-20 07:35:00	SPY	ETF	165.32	165.32	165.28	165.32	7800.0
2013-08-20 07:40:00	SPY	ETF	165.3	165.4	165.3	165.39	65515.0
2013-08-20 07:45:00	SPY	ETF	165.38	165.39	165.38	165.39	7260.0
2013-08-20 07:50:00	SPY	ETF	165.39	165.43	165.37	165.37	143363.0
2013-08-20 07:55:00	SPY	ETF	165.35	165.365	165.33	165.33	22784.0
2013-08-20 08:00:00	SPY	ETF	165.36	165.44	165.02	165.3	38387.0
2013-08-20 08:05:00	SPY	ETF	165.3	165.43	165.3	165.4	45381.0
2013-08-20 08:10:00	SPY	ETF	165.4	165.49	165.4	165.4	75350.0
2013-08-20 08:15:00	SPY	ETF	165.41	165.48	165.4	165.48	27300.0
2013-08-20 08:20:00	SPY	ETF	165.45	165.5	165.42	165.42	99290.0

> showing 50 of 41,320 rows — these rows as CSV

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