PREVIEW / etf_5min / 2009-08-11

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-11.parquet
  size:    704 KB
  rows:    29,622

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
2009-08-11 04:15:00	SPY	ETF	101.44	101.45	101.44	101.44	942.0
2009-08-11 04:20:00	SPY	ETF	101.45	101.48	101.45	101.48	1139.0
2009-08-11 05:15:00	SPY	ETF	101.4	101.4	101.4	101.4	2500.0
2009-08-11 05:25:00	SPY	ETF	101.3	101.3	101.3	101.3	100.0
2009-08-11 05:30:00	SPY	ETF	101.28	101.28	101.28	101.28	1000.0
2009-08-11 05:35:00	SPY	ETF	101.24	101.24	101.24	101.24	100.0
2009-08-11 05:55:00	SPY	ETF	101.2	101.2	101.2	101.2	100.0
2009-08-11 06:00:00	SPY	ETF	101.2	101.2	101.2	101.2	100.0
2009-08-11 06:05:00	SPY	ETF	101.15	101.15	101.15	101.15	500.0
2009-08-11 06:20:00	SPY	ETF	101.05	101.06	101.02	101.02	7600.0
2009-08-11 06:25:00	SPY	ETF	101.0	101.0	100.95	100.95	2100.0
2009-08-11 06:35:00	SPY	ETF	100.98	100.98	100.93	100.98	10200.0
2009-08-11 06:40:00	SPY	ETF	100.99	100.99	100.99	100.99	4150.0
2009-08-11 06:50:00	SPY	ETF	101.05	101.05	101.05	101.05	4150.0
2009-08-11 06:55:00	SPY	ETF	101.05	101.05	101.05	101.05	400.0
2009-08-11 07:00:00	SPY	ETF	101.02	101.02	101.01	101.01	799.0
2009-08-11 07:05:00	SPY	ETF	101.0	101.14	100.98	101.14	2850.0
2009-08-11 07:10:00	SPY	ETF	101.1	101.12	101.02	101.04	8660.0
2009-08-11 07:15:00	SPY	ETF	101.02	101.02	101.0	101.01	600.0
2009-08-11 07:20:00	SPY	ETF	101.04	101.06	101.04	101.06	2100.0
2009-08-11 07:25:00	SPY	ETF	101.06	101.1	100.99	100.99	104400.0
2009-08-11 07:30:00	SPY	ETF	101.0	101.0	100.91	100.98	13500.0
2009-08-11 07:35:00	SPY	ETF	100.96	100.97	100.95	100.97	71525.0
2009-08-11 07:40:00	SPY	ETF	100.94	100.94	100.86	100.9	230475.0
2009-08-11 07:45:00	SPY	ETF	100.9	100.9	100.83	100.86	26289.0
2009-08-11 07:50:00	SPY	ETF	100.87	100.91	100.86	100.88	37069.0
2009-08-11 07:55:00	SPY	ETF	100.89	100.89	100.8	100.84	124185.0
2009-08-11 08:00:00	SPY	ETF	100.83	100.91	100.83	100.91	45628.0
2009-08-11 08:05:00	SPY	ETF	100.89	100.89	100.85	100.85	56144.0
2009-08-11 08:10:00	SPY	ETF	100.87	100.91	100.84	100.91	29001.0
2009-08-11 08:15:00	SPY	ETF	100.9	100.95	100.89	100.95	81126.0
2009-08-11 08:20:00	SPY	ETF	100.95	101.0	100.95	101.0	41270.0
2009-08-11 08:25:00	SPY	ETF	100.99	101.08	100.97	101.08	653872.0
2009-08-11 08:30:00	SPY	ETF	101.1	101.16	100.94	100.95	894098.0
2009-08-11 08:35:00	SPY	ETF	100.94	101.0	100.9	100.93	195119.0
2009-08-11 08:40:00	SPY	ETF	100.94	100.99	100.93	100.93	353403.0
2009-08-11 08:45:00	SPY	ETF	100.93	100.99	100.93	100.94	44115.0
2009-08-11 08:50:00	SPY	ETF	100.94	100.95	100.9	100.93	146864.0
2009-08-11 08:55:00	SPY	ETF	100.94	100.94	100.7	100.76	336585.0
2009-08-11 09:00:00	SPY	ETF	100.75	100.75	100.64	100.66	180828.0
2009-08-11 09:05:00	SPY	ETF	100.67	100.71	100.66	100.69	123974.0
2009-08-11 09:10:00	SPY	ETF	100.69	100.7	100.59	100.6	359976.0
2009-08-11 09:15:00	SPY	ETF	100.59	100.63	100.55	100.63	336215.0
2009-08-11 09:20:00	SPY	ETF	100.61	100.62	100.57	100.61	321176.0
2009-08-11 09:25:00	SPY	ETF	100.62	100.62	100.48	100.53	404328.0
2009-08-11 09:30:00	SPY	ETF	100.54	100.61	100.34	100.53	4138443.0
2009-08-11 09:35:00	SPY	ETF	100.52	100.61	100.45	100.53	2910424.0
2009-08-11 09:40:00	SPY	ETF	100.54	100.54	100.27	100.38	3075461.0
2009-08-11 09:45:00	SPY	ETF	100.39	100.4	100.07	100.12	5258015.0
2009-08-11 09:50:00	SPY	ETF	100.12	100.19	100.07	100.15	2950455.0

> showing 50 of 29,622 rows — these rows as CSV

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