PREVIEW / etf_5min / 2010-07-08

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-07-08.parquet
  size:    761 KB
  rows:    32,600

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
2010-07-08 04:10:00	SPY	ETF	106.2	106.2	106.2	106.2	2000.0
2010-07-08 04:15:00	SPY	ETF	106.13	106.13	106.07	106.07	1900.0
2010-07-08 04:20:00	SPY	ETF	106.08	106.08	106.04	106.04	200.0
2010-07-08 04:25:00	SPY	ETF	106.06	106.06	106.06	106.06	900.0
2010-07-08 04:40:00	SPY	ETF	106.19	106.19	106.19	106.19	100.0
2010-07-08 04:45:00	SPY	ETF	106.11	106.11	106.11	106.11	145.0
2010-07-08 05:05:00	SPY	ETF	106.09	106.09	106.08	106.08	350.0
2010-07-08 05:10:00	SPY	ETF	106.08	106.08	106.08	106.08	1250.0
2010-07-08 05:15:00	SPY	ETF	106.19	106.19	106.19	106.19	4659.0
2010-07-08 05:20:00	SPY	ETF	106.31	106.31	106.26	106.28	2000.0
2010-07-08 05:25:00	SPY	ETF	106.23	106.34	106.23	106.34	1276.0
2010-07-08 05:35:00	SPY	ETF	106.17	106.17	106.17	106.17	1500.0
2010-07-08 05:45:00	SPY	ETF	106.19	106.19	106.19	106.19	500.0
2010-07-08 06:15:00	SPY	ETF	106.2	106.22	106.15	106.15	5270.0
2010-07-08 06:20:00	SPY	ETF	106.18	106.18	106.18	106.18	1000.0
2010-07-08 06:30:00	SPY	ETF	106.26	106.26	106.26	106.26	410.0
2010-07-08 06:35:00	SPY	ETF	106.29	106.29	106.29	106.29	4540.0
2010-07-08 06:40:00	SPY	ETF	106.25	106.25	106.25	106.25	1700.0
2010-07-08 06:50:00	SPY	ETF	106.34	106.34	106.34	106.34	500.0
2010-07-08 07:00:00	SPY	ETF	106.33	106.43	106.33	106.42	106361.0
2010-07-08 07:05:00	SPY	ETF	106.41	106.41	106.3	106.31	67212.0
2010-07-08 07:10:00	SPY	ETF	106.3	106.31	106.29	106.29	52600.0
2010-07-08 07:15:00	SPY	ETF	106.29	106.32	106.26	106.29	10600.0
2010-07-08 07:20:00	SPY	ETF	106.29	106.31	106.26	106.26	24400.0
2010-07-08 07:25:00	SPY	ETF	106.27	106.29	106.25	106.26	13000.0
2010-07-08 07:30:00	SPY	ETF	106.26	106.26	106.21	106.22	21000.0
2010-07-08 07:35:00	SPY	ETF	106.21	106.22	106.16	106.2	13800.0
2010-07-08 07:40:00	SPY	ETF	106.17	106.22	106.17	106.22	6720.0
2010-07-08 07:45:00	SPY	ETF	106.22	106.25	106.2	106.25	24400.0
2010-07-08 07:50:00	SPY	ETF	106.21	106.3	106.21	106.29	46160.0
2010-07-08 07:55:00	SPY	ETF	106.3	106.31	106.29	106.31	2411.0
2010-07-08 08:00:00	SPY	ETF	106.32	106.38	106.23	106.33	95585.0
2010-07-08 08:05:00	SPY	ETF	106.36	106.36	106.31	106.36	118928.0
2010-07-08 08:10:00	SPY	ETF	106.36	106.45	106.36	106.42	314352.0
2010-07-08 08:15:00	SPY	ETF	106.42	106.46	106.42	106.44	282684.0
2010-07-08 08:20:00	SPY	ETF	106.44	106.51	106.39	106.48	331171.0
2010-07-08 08:25:00	SPY	ETF	106.48	106.5	106.43	106.48	278977.0
2010-07-08 08:30:00	SPY	ETF	106.47	106.76	106.47	106.75	1431206.0
2010-07-08 08:35:00	SPY	ETF	106.75	107.01	106.74	107.0	1539048.0
2010-07-08 08:40:00	SPY	ETF	107.01	107.05	106.0	106.98	1356532.0
2010-07-08 08:45:00	SPY	ETF	106.98	107.04	106.86	106.87	790127.0
2010-07-08 08:50:00	SPY	ETF	106.87	106.98	106.87	106.97	277696.0
2010-07-08 08:55:00	SPY	ETF	106.97	106.97	106.88	106.89	392483.0
2010-07-08 09:00:00	SPY	ETF	106.9	106.91	106.86	106.89	365786.0
2010-07-08 09:05:00	SPY	ETF	106.89	107.03	106.88	107.01	375552.0
2010-07-08 09:10:00	SPY	ETF	107.01	107.05	106.95	106.97	345781.0
2010-07-08 09:15:00	SPY	ETF	106.97	107.1	106.97	106.98	475561.0
2010-07-08 09:20:00	SPY	ETF	106.98	107.11	106.97	107.01	444154.0
2010-07-08 09:25:00	SPY	ETF	107.0	107.06	106.1075	106.99	681049.0
2010-07-08 09:30:00	SPY	ETF	107.0	107.0	106.78	106.91	5809859.0

> showing 50 of 32,600 rows — these rows as CSV

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