PREVIEW / etf_1min / 2007-06-19

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-06-19.parquet
  size:    612 KB
  rows:    42,206

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-06-19 06:37:00	SPY	ETF	152.76	152.76	152.76	152.76	2000.0
2007-06-19 07:01:00	SPY	ETF	152.84	152.84	152.82	152.82	37500.0
2007-06-19 07:02:00	SPY	ETF	152.83	152.83	152.83	152.83	5000.0
2007-06-19 07:07:00	SPY	ETF	152.85	152.85	152.85	152.85	5000.0
2007-06-19 07:11:00	SPY	ETF	152.88	152.88	152.88	152.88	2000.0
2007-06-19 07:13:00	SPY	ETF	152.87	152.87	152.87	152.87	500.0
2007-06-19 07:17:00	SPY	ETF	152.88	152.88	152.88	152.88	5000.0
2007-06-19 07:20:00	SPY	ETF	152.85	152.85	152.85	152.85	200.0
2007-06-19 07:21:00	SPY	ETF	152.85	152.85	152.85	152.85	100.0
2007-06-19 07:24:00	SPY	ETF	152.84	152.84	152.84	152.84	1200.0
2007-06-19 07:25:00	SPY	ETF	152.82	152.82	152.77	152.77	6200.0
2007-06-19 07:27:00	SPY	ETF	152.78	152.78	152.78	152.78	100.0
2007-06-19 07:29:00	SPY	ETF	152.8	152.8	152.8	152.8	1000.0
2007-06-19 07:31:00	SPY	ETF	152.78	152.81	152.78	152.81	96000.0
2007-06-19 07:33:00	SPY	ETF	152.82	152.82	152.82	152.82	50000.0
2007-06-19 07:37:00	SPY	ETF	152.82	152.82	152.8	152.81	88300.0
2007-06-19 07:39:00	SPY	ETF	152.75	152.75	152.75	152.75	500.0
2007-06-19 07:49:00	SPY	ETF	152.74	152.74	152.73	152.73	600.0
2007-06-19 07:51:00	SPY	ETF	152.72	152.72	152.72	152.72	1000.0
2007-06-19 07:52:00	SPY	ETF	152.72	152.75	152.72	152.75	3000.0
2007-06-19 07:56:00	SPY	ETF	152.81	152.81	152.81	152.81	9900.0
2007-06-19 08:00:00	SPY	ETF	152.72	152.81	152.72	152.8	433000.0
2007-06-19 08:01:00	SPY	ETF	152.76	152.76	152.69	152.69	4500.0
2007-06-19 08:02:00	SPY	ETF	152.7	152.7	152.7	152.7	5000.0
2007-06-19 08:03:00	SPY	ETF	152.71	152.71	152.7	152.7	30500.0
2007-06-19 08:04:00	SPY	ETF	152.7	152.7	152.7	152.7	19400.0
2007-06-19 08:05:00	SPY	ETF	152.72	152.72	152.72	152.72	2400.0
2007-06-19 08:06:00	SPY	ETF	152.72	152.72	152.66	152.66	25700.0
2007-06-19 08:07:00	SPY	ETF	152.63	152.68	152.62	152.68	55300.0
2007-06-19 08:08:00	SPY	ETF	152.63	152.63	152.63	152.63	10000.0
2007-06-19 08:09:00	SPY	ETF	152.65	152.65	152.65	152.65	20000.0
2007-06-19 08:10:00	SPY	ETF	152.63	152.63	152.61	152.62	80900.0
2007-06-19 08:12:00	SPY	ETF	152.65	152.65	152.65	152.65	25000.0
2007-06-19 08:14:00	SPY	ETF	152.63	152.63	152.62	152.63	64000.0
2007-06-19 08:15:00	SPY	ETF	152.63	152.67	152.63	152.67	14600.0
2007-06-19 08:17:00	SPY	ETF	152.67	152.67	152.67	152.67	100.0
2007-06-19 08:18:00	SPY	ETF	152.62	152.62	152.54	152.55	31900.0
2007-06-19 08:19:00	SPY	ETF	152.54	152.54	152.5	152.51	17600.0
2007-06-19 08:20:00	SPY	ETF	152.52	152.52	152.48	152.48	21500.0
2007-06-19 08:21:00	SPY	ETF	152.5	152.55	152.5	152.55	2200.0
2007-06-19 08:23:00	SPY	ETF	152.57	152.57	152.5	152.5	36300.0
2007-06-19 08:24:00	SPY	ETF	152.52	152.57	152.52	152.57	51500.0
2007-06-19 08:26:00	SPY	ETF	152.54	152.54	152.52	152.52	700.0
2007-06-19 08:27:00	SPY	ETF	152.57	152.57	152.55	152.56	30400.0
2007-06-19 08:28:00	SPY	ETF	152.55	152.56	152.55	152.55	4300.0
2007-06-19 08:29:00	SPY	ETF	152.57	152.58	152.56	152.58	3700.0
2007-06-19 08:30:00	SPY	ETF	152.58	152.7	152.58	152.7	170400.0
2007-06-19 08:31:00	SPY	ETF	152.7	152.7	152.56	152.6	61600.0
2007-06-19 08:32:00	SPY	ETF	152.6	152.66	152.59	152.62	55500.0
2007-06-19 08:33:00	SPY	ETF	152.62	152.66	152.6	152.62	55900.0

> showing 50 of 42,206 rows — these rows as CSV

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