PREVIEW / etf_5min / 2007-04-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-04-20.parquet
  size:    297 KB
  rows:    14,183

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
2007-04-20 05:50:00	SPY	ETF	147.66	147.66	147.66	147.66	19000.0
2007-04-20 06:10:00	SPY	ETF	147.69	147.69	147.69	147.69	25000.0
2007-04-20 06:20:00	SPY	ETF	147.75	147.75	147.75	147.75	100.0
2007-04-20 06:55:00	SPY	ETF	147.77	147.77	147.77	147.77	10000.0
2007-04-20 07:00:00	SPY	ETF	147.72	147.83	147.7	147.83	48800.0
2007-04-20 07:05:00	SPY	ETF	147.82	147.89	147.81	147.89	11100.0
2007-04-20 07:10:00	SPY	ETF	147.88	147.95	147.83	147.85	116700.0
2007-04-20 07:15:00	SPY	ETF	147.85	147.85	147.85	147.85	2600.0
2007-04-20 07:20:00	SPY	ETF	147.8	147.8	147.73	147.8	243100.0
2007-04-20 07:25:00	SPY	ETF	147.8	147.8	147.78	147.8	131000.0
2007-04-20 07:30:00	SPY	ETF	147.8	147.91	147.8	147.91	139700.0
2007-04-20 07:35:00	SPY	ETF	147.92	147.92	147.9	147.9	6200.0
2007-04-20 07:40:00	SPY	ETF	147.9	147.98	147.9	147.96	517200.0
2007-04-20 07:45:00	SPY	ETF	147.96	147.99	147.94	147.99	78900.0
2007-04-20 07:50:00	SPY	ETF	147.99	147.99	147.91	147.91	20100.0
2007-04-20 07:55:00	SPY	ETF	147.95	147.95	147.92	147.92	27800.0
2007-04-20 08:00:00	SPY	ETF	147.77	147.95	147.77	147.86	1945300.0
2007-04-20 08:05:00	SPY	ETF	147.9	147.91	147.86	147.91	221000.0
2007-04-20 08:10:00	SPY	ETF	147.9	147.9	147.87	147.87	5300.0
2007-04-20 08:15:00	SPY	ETF	147.85	147.87	147.82	147.86	120800.0
2007-04-20 08:20:00	SPY	ETF	147.84	147.88	147.83	147.85	44100.0
2007-04-20 08:25:00	SPY	ETF	147.86	147.9	147.82	147.9	101800.0
2007-04-20 08:30:00	SPY	ETF	147.9	147.95	147.47	147.91	1062000.0
2007-04-20 08:35:00	SPY	ETF	147.92	147.96	147.92	147.96	419000.0
2007-04-20 08:40:00	SPY	ETF	147.96	148.02	147.95	148.0	89300.0
2007-04-20 08:45:00	SPY	ETF	148.0	148.02	147.97	147.97	57100.0
2007-04-20 08:50:00	SPY	ETF	147.95	147.98	147.94	147.95	554900.0
2007-04-20 08:55:00	SPY	ETF	147.94	148.05	147.94	148.05	1118500.0
2007-04-20 09:00:00	SPY	ETF	148.05	148.06	148.0	148.03	708800.0
2007-04-20 09:05:00	SPY	ETF	148.05	148.06	148.03	148.04	228300.0
2007-04-20 09:10:00	SPY	ETF	148.04	148.11	148.03	148.08	234900.0
2007-04-20 09:15:00	SPY	ETF	148.09	148.12	148.06	148.1	444877.0
2007-04-20 09:20:00	SPY	ETF	148.11	148.11	148.05	148.06	1080700.0
2007-04-20 09:25:00	SPY	ETF	148.06	148.3	148.06	148.23	1369200.0
2007-04-20 09:30:00	SPY	ETF	148.22	148.41	148.1	148.4	5911600.0
2007-04-20 09:35:00	SPY	ETF	148.41	148.47	148.23	148.24	6777740.0
2007-04-20 09:40:00	SPY	ETF	148.24	148.33	148.2	148.31	1995738.0
2007-04-20 09:45:00	SPY	ETF	148.3	148.4	148.26	148.39	1745879.0
2007-04-20 09:50:00	SPY	ETF	148.38	148.39	148.11	148.16	3509582.0
2007-04-20 09:55:00	SPY	ETF	148.15	148.27	148.12	148.15	3202168.0
2007-04-20 10:00:00	SPY	ETF	148.16	148.3	148.08	148.26	2536680.0
2007-04-20 10:05:00	SPY	ETF	148.26	148.5275	148.06	148.17	7985761.0
2007-04-20 10:10:00	SPY	ETF	148.16	148.24	148.1	148.22	1088470.0
2007-04-20 10:15:00	SPY	ETF	148.2299	148.26	148.11	148.15	1230329.0
2007-04-20 10:20:00	SPY	ETF	148.15	148.2	148.12	148.17	830300.0
2007-04-20 10:25:00	SPY	ETF	148.17	148.24	148.14	148.21	1474425.0
2007-04-20 10:30:00	SPY	ETF	148.2	148.25	148.17	148.17	743325.0
2007-04-20 10:35:00	SPY	ETF	148.17	148.2	148.08	148.13	1699351.0
2007-04-20 10:40:00	SPY	ETF	148.13	148.16	148.04	148.1	1876760.0
2007-04-20 10:45:00	SPY	ETF	148.1	148.15	148.04	148.1	762560.0

> showing 50 of 14,183 rows — these rows as CSV

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