PREVIEW / etf_1min / 2007-08-09

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-08-09.parquet
  size:    894 KB
  rows:    56,420

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-08-09 04:05:00	SPY	ETF	149.11	149.11	149.08	149.08	5000.0
2007-08-09 04:06:00	SPY	ETF	149.05	149.05	149.05	149.05	1500.0
2007-08-09 04:08:00	SPY	ETF	149.05	149.05	149.02	149.02	2500.0
2007-08-09 04:14:00	SPY	ETF	149.03	149.03	149.03	149.03	1000.0
2007-08-09 04:15:00	SPY	ETF	149.03	149.03	149.03	149.03	100.0
2007-08-09 04:19:00	SPY	ETF	148.92	148.92	148.92	148.92	300.0
2007-08-09 04:21:00	SPY	ETF	148.95	148.95	148.95	148.95	300.0
2007-08-09 04:22:00	SPY	ETF	148.98	148.98	148.94	148.94	500.0
2007-08-09 04:35:00	SPY	ETF	148.83	148.83	148.83	148.83	200.0
2007-08-09 04:37:00	SPY	ETF	148.82	148.83	148.82	148.83	2400.0
2007-08-09 04:38:00	SPY	ETF	148.82	148.82	148.82	148.82	800.0
2007-08-09 04:40:00	SPY	ETF	148.85	148.85	148.85	148.85	800.0
2007-08-09 04:43:00	SPY	ETF	148.85	148.85	148.85	148.85	300.0
2007-08-09 04:44:00	SPY	ETF	148.85	148.85	148.79	148.79	500.0
2007-08-09 04:47:00	SPY	ETF	148.9	148.9	148.9	148.9	300.0
2007-08-09 04:48:00	SPY	ETF	148.9	148.9	148.9	148.9	200.0
2007-08-09 04:49:00	SPY	ETF	148.88	148.88	148.88	148.88	1000.0
2007-08-09 04:57:00	SPY	ETF	148.66	148.66	148.66	148.66	15000.0
2007-08-09 04:58:00	SPY	ETF	148.7	148.7	148.68	148.68	1500.0
2007-08-09 04:59:00	SPY	ETF	148.68	148.68	148.68	148.68	800.0
2007-08-09 05:06:00	SPY	ETF	148.63	148.63	148.63	148.63	200.0
2007-08-09 05:10:00	SPY	ETF	148.59	148.59	148.59	148.59	9900.0
2007-08-09 05:11:00	SPY	ETF	148.55	148.55	148.55	148.55	15000.0
2007-08-09 05:12:00	SPY	ETF	148.5	148.5	148.5	148.5	1000.0
2007-08-09 05:20:00	SPY	ETF	148.72	148.72	148.72	148.72	1000.0
2007-08-09 05:33:00	SPY	ETF	148.99	148.99	148.99	148.99	4900.0
2007-08-09 05:35:00	SPY	ETF	148.95	148.95	148.95	148.95	1000.0
2007-08-09 05:55:00	SPY	ETF	148.6	148.6	148.6	148.6	1000.0
2007-08-09 06:07:00	SPY	ETF	148.69	148.72	148.69	148.72	12000.0
2007-08-09 06:12:00	SPY	ETF	148.69	148.69	148.69	148.69	5000.0
2007-08-09 06:13:00	SPY	ETF	148.69	148.69	148.69	148.69	3000.0
2007-08-09 06:15:00	SPY	ETF	148.81	148.81	148.81	148.81	5000.0
2007-08-09 06:39:00	SPY	ETF	148.64	148.64	148.64	148.64	5000.0
2007-08-09 06:46:00	SPY	ETF	148.62	148.62	148.61	148.61	12500.0
2007-08-09 06:47:00	SPY	ETF	148.61	148.61	148.61	148.61	1000.0
2007-08-09 06:52:00	SPY	ETF	148.39	148.39	148.39	148.39	500.0
2007-08-09 06:54:00	SPY	ETF	148.39	148.39	148.39	148.39	1000.0
2007-08-09 06:55:00	SPY	ETF	148.32	148.32	148.32	148.32	2500.0
2007-08-09 06:56:00	SPY	ETF	148.36	148.39	148.36	148.37	4900.0
2007-08-09 06:57:00	SPY	ETF	148.32	148.33	148.29	148.33	13500.0
2007-08-09 06:58:00	SPY	ETF	148.31	148.31	148.29	148.29	6000.0
2007-08-09 06:59:00	SPY	ETF	148.31	148.31	148.23	148.29	6000.0
2007-08-09 07:00:00	SPY	ETF	148.24	148.31	148.23	148.31	157900.0
2007-08-09 07:01:00	SPY	ETF	148.33	148.33	148.3	148.32	143800.0
2007-08-09 07:02:00	SPY	ETF	148.35	148.35	148.33	148.35	80500.0
2007-08-09 07:03:00	SPY	ETF	148.35	148.35	148.33	148.33	51800.0
2007-08-09 07:04:00	SPY	ETF	148.35	148.35	148.32	148.32	6000.0
2007-08-09 07:05:00	SPY	ETF	148.4	148.4	148.38	148.39	52900.0
2007-08-09 07:06:00	SPY	ETF	148.36	148.41	148.35	148.41	118100.0
2007-08-09 07:07:00	SPY	ETF	148.43	148.43	148.4	148.41	46000.0

> showing 50 of 56,420 rows — these rows as CSV

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