PREVIEW / etf_5min / 2006-01-20

all etf 5-min files

  file:    by_date/etf_5min/2006/2006-01-20.parquet
  size:    201 KB
  rows:    9,571

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
2006-01-20 06:30:00	SPY	ETF	128.1	128.12	128.1	128.12	2500.0
2006-01-20 06:35:00	SPY	ETF	128.09	128.09	128.03	128.03	1100.0
2006-01-20 06:40:00	SPY	ETF	128.0	128.0	128.0	128.0	1000.0
2006-01-20 07:00:00	SPY	ETF	128.0	128.0	128.0	128.0	2100.0
2006-01-20 07:05:00	SPY	ETF	127.97	127.97	127.97	127.97	100.0
2006-01-20 07:15:00	SPY	ETF	128.0	128.0	128.0	128.0	3000.0
2006-01-20 07:25:00	SPY	ETF	128.03	128.03	128.03	128.03	1000.0
2006-01-20 07:35:00	SPY	ETF	128.02	128.02	128.02	128.02	200.0
2006-01-20 07:40:00	SPY	ETF	128.04	128.04	128.04	128.04	200.0
2006-01-20 07:45:00	SPY	ETF	128.05	128.05	128.04	128.05	8100.0
2006-01-20 07:50:00	SPY	ETF	128.04	128.04	128.04	128.04	100.0
2006-01-20 07:55:00	SPY	ETF	128.04	128.05	128.04	128.04	3600.0
2006-01-20 08:00:00	SPY	ETF	128.05	128.11	127.97	127.97	26200.0
2006-01-20 08:05:00	SPY	ETF	128.09	128.1	128.09	128.1	800.0
2006-01-20 08:10:00	SPY	ETF	128.11	128.11	128.1	128.1	600.0
2006-01-20 08:15:00	SPY	ETF	128.13	128.13	128.13	128.13	2000.0
2006-01-20 08:20:00	SPY	ETF	128.12	128.12	128.1	128.1	1400.0
2006-01-20 08:25:00	SPY	ETF	128.08	128.08	128.02	128.02	6900.0
2006-01-20 08:30:00	SPY	ETF	128.02	128.03	128.0	128.03	20400.0
2006-01-20 08:35:00	SPY	ETF	128.03	128.36	128.03	128.36	46300.0
2006-01-20 08:40:00	SPY	ETF	128.07	128.07	128.0	128.03	31600.0
2006-01-20 08:45:00	SPY	ETF	128.02	128.14	128.0	128.06	137000.0
2006-01-20 08:50:00	SPY	ETF	128.05	128.05	128.03	128.05	5000.0
2006-01-20 08:55:00	SPY	ETF	128.05	128.05	128.02	128.05	7100.0
2006-01-20 09:00:00	SPY	ETF	128.09	128.12	128.07	128.12	9500.0
2006-01-20 09:05:00	SPY	ETF	128.12	128.17	128.11	128.16	38200.0
2006-01-20 09:10:00	SPY	ETF	128.17	128.18	128.17	128.17	9200.0
2006-01-20 09:15:00	SPY	ETF	128.14	128.22	128.14	128.19	52200.0
2006-01-20 09:20:00	SPY	ETF	128.18	128.26	128.18	128.24	85200.0
2006-01-20 09:25:00	SPY	ETF	128.24	128.38	128.24	128.26	130600.0
2006-01-20 09:30:00	SPY	ETF	128.28	128.31	128.19	128.22	1709500.0
2006-01-20 09:35:00	SPY	ETF	128.22	128.29	128.13	128.22	1200400.0
2006-01-20 09:40:00	SPY	ETF	128.23	128.25	128.17	128.19	854000.0
2006-01-20 09:45:00	SPY	ETF	128.19	128.21	128.09	128.19	988000.0
2006-01-20 09:50:00	SPY	ETF	128.17	128.27	128.16	128.21	1195400.0
2006-01-20 09:55:00	SPY	ETF	128.2	128.21	128.05	128.08	1396900.0
2006-01-20 10:00:00	SPY	ETF	128.08	128.15	127.93	128.06	1490200.0
2006-01-20 10:05:00	SPY	ETF	128.06	128.11	128.04	128.05	975800.0
2006-01-20 10:10:00	SPY	ETF	128.06	128.09	127.84	127.85	1657700.0
2006-01-20 10:15:00	SPY	ETF	127.86	127.95	127.84	127.93	807500.0
2006-01-20 10:20:00	SPY	ETF	127.92	127.99	127.87	127.99	1537800.0
2006-01-20 10:25:00	SPY	ETF	127.97	127.99	127.85	127.87	1182800.0
2006-01-20 10:30:00	SPY	ETF	127.87	127.9	127.66	127.76	2644800.0
2006-01-20 10:35:00	SPY	ETF	127.76	127.81	127.75	127.81	1597600.0
2006-01-20 10:40:00	SPY	ETF	127.81	127.82	127.61	127.61	770400.0
2006-01-20 10:45:00	SPY	ETF	127.62	127.76	127.55	127.61	1878800.0
2006-01-20 10:50:00	SPY	ETF	127.62	127.65	127.26	127.42	2386700.0
2006-01-20 10:55:00	SPY	ETF	127.42	127.55	127.36	127.49	2760700.0
2006-01-20 11:00:00	SPY	ETF	127.44	127.51	127.32	127.47	1736500.0
2006-01-20 11:05:00	SPY	ETF	127.48	127.48	127.33	127.39	812200.0

> showing 50 of 9,571 rows — these rows as CSV

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