PREVIEW / etf_5min / 2013-05-23

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-23.parquet
  size:    1.0 MB
  rows:    44,108

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-05-23 04:00:00	SPY	ETF	164.85	164.85	164.3	164.4	26106.0
2013-05-23 04:05:00	SPY	ETF	164.37	164.37	164.28	164.28	8601.0
2013-05-23 04:10:00	SPY	ETF	164.25	164.25	164.15	164.2	45750.0
2013-05-23 04:15:00	SPY	ETF	164.2	164.35	164.12	164.24	7499.0
2013-05-23 04:20:00	SPY	ETF	164.17	164.18	164.12	164.12	1400.0
2013-05-23 04:25:00	SPY	ETF	164.08	164.1	163.97	164.01	20515.0
2013-05-23 04:30:00	SPY	ETF	163.92	164.0	163.85	163.91	8400.0
2013-05-23 04:35:00	SPY	ETF	163.88	164.28	163.81	164.28	27546.0
2013-05-23 04:40:00	SPY	ETF	164.19	164.25	164.14	164.25	1300.0
2013-05-23 04:45:00	SPY	ETF	164.28	164.28	164.09	164.11	4100.0
2013-05-23 04:50:00	SPY	ETF	164.23	164.23	164.17	164.23	4350.0
2013-05-23 04:55:00	SPY	ETF	164.19	164.19	164.04	164.04	3548.0
2013-05-23 05:00:00	SPY	ETF	164.04	164.15	164.04	164.15	3900.0
2013-05-23 05:05:00	SPY	ETF	164.19	164.19	164.1	164.12	1629.0
2013-05-23 05:10:00	SPY	ETF	164.18	164.18	164.05	164.14	2358.0
2013-05-23 05:15:00	SPY	ETF	164.16	164.32	164.06	164.32	3345.0
2013-05-23 05:20:00	SPY	ETF	164.32	164.34	164.23	164.23	8375.0
2013-05-23 05:25:00	SPY	ETF	164.31	164.35	164.31	164.35	30000.0
2013-05-23 05:30:00	SPY	ETF	164.3	164.3	164.18	164.18	21500.0
2013-05-23 05:35:00	SPY	ETF	164.23	164.28	164.18	164.28	8800.0
2013-05-23 05:40:00	SPY	ETF	164.25	164.26	164.16	164.26	30600.0
2013-05-23 05:45:00	SPY	ETF	164.28	164.31	164.19	164.23	3900.0
2013-05-23 05:50:00	SPY	ETF	164.22	164.22	164.16	164.18	6400.0
2013-05-23 05:55:00	SPY	ETF	164.23	164.27	164.16	164.16	4350.0
2013-05-23 06:00:00	SPY	ETF	164.09	164.12	164.04	164.08	11470.0
2013-05-23 06:05:00	SPY	ETF	164.2	164.22	164.18	164.18	2000.0
2013-05-23 06:10:00	SPY	ETF	164.23	164.26	164.23	164.26	1000.0
2013-05-23 06:15:00	SPY	ETF	164.27	164.3	164.23	164.3	8772.0
2013-05-23 06:20:00	SPY	ETF	164.26	164.29	164.23	164.28	5000.0
2013-05-23 06:25:00	SPY	ETF	164.26	164.26	164.1	164.23	33252.0
2013-05-23 06:30:00	SPY	ETF	164.23	164.28	164.21	164.24	47400.0
2013-05-23 06:35:00	SPY	ETF	164.26	164.33	164.21	164.26	8200.0
2013-05-23 06:40:00	SPY	ETF	164.28	164.49	164.28	164.46	95400.0
2013-05-23 06:45:00	SPY	ETF	164.45	164.65	164.44	164.6	37220.0
2013-05-23 06:50:00	SPY	ETF	164.63	164.76	164.59	164.72	57800.0
2013-05-23 06:55:00	SPY	ETF	164.71	164.82	164.71	164.79	84900.0
2013-05-23 07:00:00	SPY	ETF	164.79	164.82	164.67	164.8	104975.0
2013-05-23 07:05:00	SPY	ETF	164.84	164.96	164.8	164.96	62405.0
2013-05-23 07:10:00	SPY	ETF	164.98	165.0	164.83	164.84	122313.0
2013-05-23 07:15:00	SPY	ETF	164.84	164.86	164.76	164.8	74000.0
2013-05-23 07:20:00	SPY	ETF	164.8	164.81	164.69	164.7	60800.0
2013-05-23 07:25:00	SPY	ETF	164.71	164.79	164.69	164.7	100793.0
2013-05-23 07:30:00	SPY	ETF	164.69	164.72	164.63	164.65	113309.0
2013-05-23 07:35:00	SPY	ETF	164.65	164.74	164.65	164.67	106925.0
2013-05-23 07:40:00	SPY	ETF	164.65	164.68	164.39	164.53	206344.0
2013-05-23 07:45:00	SPY	ETF	164.54	164.54	164.36	164.37	105830.0
2013-05-23 07:50:00	SPY	ETF	164.37	164.51	164.37	164.45	68444.0
2013-05-23 07:55:00	SPY	ETF	164.45	164.52	164.37	164.42	131104.0
2013-05-23 08:00:00	SPY	ETF	164.42	164.95	163.74	164.64	819216.0
2013-05-23 08:05:00	SPY	ETF	164.61	164.63	164.14	164.6	296804.0

> showing 50 of 44,108 rows — these rows as CSV

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