PREVIEW / etf_1min / 2007-07-25

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-07-25.parquet
  size:    803 KB
  rows:    50,382

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-07-25 04:09:00	SPY	ETF	151.52	151.52	151.52	151.52	1000.0
2007-07-25 04:11:00	SPY	ETF	151.58	151.58	151.58	151.58	5100.0
2007-07-25 04:12:00	SPY	ETF	151.62	151.62	151.62	151.62	500.0
2007-07-25 04:22:00	SPY	ETF	151.43	151.43	151.43	151.43	2000.0
2007-07-25 04:23:00	SPY	ETF	151.42	151.42	151.41	151.41	4000.0
2007-07-25 04:29:00	SPY	ETF	151.37	151.37	151.37	151.37	2000.0
2007-07-25 04:35:00	SPY	ETF	151.45	151.45	151.45	151.45	1100.0
2007-07-25 04:54:00	SPY	ETF	151.58	151.61	151.58	151.61	2000.0
2007-07-25 05:25:00	SPY	ETF	151.52	151.52	151.52	151.52	2000.0
2007-07-25 05:39:00	SPY	ETF	151.66	151.66	151.66	151.66	2000.0
2007-07-25 05:40:00	SPY	ETF	151.66	151.68	151.66	151.68	2000.0
2007-07-25 06:10:00	SPY	ETF	151.68	151.68	151.68	151.68	1900.0
2007-07-25 06:40:00	SPY	ETF	151.86	151.86	151.86	151.86	400.0
2007-07-25 06:52:00	SPY	ETF	151.8	151.8	151.8	151.8	4000.0
2007-07-25 06:53:00	SPY	ETF	151.79	151.79	151.79	151.79	1000.0
2007-07-25 06:59:00	SPY	ETF	151.78	151.78	151.77	151.77	20000.0
2007-07-25 07:00:00	SPY	ETF	151.76	151.76	151.74	151.74	10000.0
2007-07-25 07:05:00	SPY	ETF	151.78	151.81	151.78	151.81	2700.0
2007-07-25 07:07:00	SPY	ETF	151.78	151.8	151.78	151.8	1700.0
2007-07-25 07:08:00	SPY	ETF	151.81	151.82	151.81	151.82	3100.0
2007-07-25 07:09:00	SPY	ETF	151.78	151.78	151.73	151.74	26000.0
2007-07-25 07:10:00	SPY	ETF	151.75	151.78	151.75	151.78	35500.0
2007-07-25 07:11:00	SPY	ETF	151.8	151.82	151.8	151.82	9100.0
2007-07-25 07:13:00	SPY	ETF	151.83	151.83	151.83	151.83	2000.0
2007-07-25 07:14:00	SPY	ETF	151.82	151.82	151.82	151.82	1000.0
2007-07-25 07:15:00	SPY	ETF	151.82	151.82	151.82	151.82	1000.0
2007-07-25 07:18:00	SPY	ETF	151.82	151.82	151.82	151.82	10000.0
2007-07-25 07:19:00	SPY	ETF	151.86	151.86	151.86	151.86	100.0
2007-07-25 07:20:00	SPY	ETF	151.83	151.84	151.83	151.83	46900.0
2007-07-25 07:21:00	SPY	ETF	151.83	151.92	151.83	151.92	7700.0
2007-07-25 07:22:00	SPY	ETF	151.97	151.97	151.97	151.97	500.0
2007-07-25 07:23:00	SPY	ETF	151.98	152.0	151.98	152.0	10100.0
2007-07-25 07:24:00	SPY	ETF	151.97	152.01	151.96	152.01	116200.0
2007-07-25 07:25:00	SPY	ETF	152.01	152.01	152.01	152.01	140000.0
2007-07-25 07:26:00	SPY	ETF	151.95	151.95	151.94	151.94	42500.0
2007-07-25 07:27:00	SPY	ETF	151.95	151.95	151.95	151.95	8000.0
2007-07-25 07:28:00	SPY	ETF	151.98	152.0	151.98	151.98	10300.0
2007-07-25 07:29:00	SPY	ETF	151.98	151.98	151.98	151.98	200.0
2007-07-25 07:30:00	SPY	ETF	151.99	152.04	151.99	152.03	58900.0
2007-07-25 07:31:00	SPY	ETF	152.04	152.04	152.0	152.0	4000.0
2007-07-25 07:32:00	SPY	ETF	152.1	152.16	152.09	152.15	37600.0
2007-07-25 07:33:00	SPY	ETF	152.18	152.18	152.12	152.15	111400.0
2007-07-25 07:34:00	SPY	ETF	152.15	152.16	152.1	152.15	152800.0
2007-07-25 07:35:00	SPY	ETF	152.15	152.16	152.12	152.12	130700.0
2007-07-25 07:36:00	SPY	ETF	152.1	152.11	152.08	152.11	8000.0
2007-07-25 07:37:00	SPY	ETF	152.08	152.08	152.08	152.08	2000.0
2007-07-25 07:38:00	SPY	ETF	152.07	152.07	152.07	152.07	100.0
2007-07-25 07:39:00	SPY	ETF	152.04	152.07	152.03	152.03	3200.0
2007-07-25 07:40:00	SPY	ETF	152.05	152.05	152.05	152.05	6200.0
2007-07-25 07:41:00	SPY	ETF	152.03	152.08	152.03	152.08	53300.0

> showing 50 of 50,382 rows — these rows as CSV

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