PREVIEW / etf_1min / 2007-07-27

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-07-27.parquet
  size:    936 KB
  rows:    57,089

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-27 04:06:00	SPY	ETF	148.4	148.4	148.4	148.4	4000.0
2007-07-27 04:07:00	SPY	ETF	148.4	148.4	148.4	148.4	9000.0
2007-07-27 04:19:00	SPY	ETF	148.2	148.2	148.2	148.2	1000.0
2007-07-27 04:25:00	SPY	ETF	148.51	148.51	148.51	148.51	3000.0
2007-07-27 04:27:00	SPY	ETF	148.4	148.4	148.4	148.4	600.0
2007-07-27 04:28:00	SPY	ETF	148.52	148.52	148.52	148.52	2000.0
2007-07-27 04:30:00	SPY	ETF	148.52	148.52	148.52	148.52	1000.0
2007-07-27 04:38:00	SPY	ETF	148.52	148.52	148.52	148.52	600.0
2007-07-27 04:43:00	SPY	ETF	148.65	148.65	148.65	148.65	2000.0
2007-07-27 04:45:00	SPY	ETF	148.67	148.67	148.67	148.67	2000.0
2007-07-27 04:52:00	SPY	ETF	148.84	148.84	148.84	148.84	1000.0
2007-07-27 04:53:00	SPY	ETF	148.84	148.84	148.84	148.84	1700.0
2007-07-27 04:58:00	SPY	ETF	148.72	148.72	148.72	148.72	1000.0
2007-07-27 05:01:00	SPY	ETF	148.75	148.75	148.75	148.75	1500.0
2007-07-27 05:24:00	SPY	ETF	148.6	148.6	148.6	148.6	500.0
2007-07-27 05:57:00	SPY	ETF	148.4	148.4	148.4	148.4	3400.0
2007-07-27 05:58:00	SPY	ETF	148.4	148.4	148.4	148.4	1600.0
2007-07-27 06:25:00	SPY	ETF	148.17	148.17	148.17	148.17	600.0
2007-07-27 06:31:00	SPY	ETF	148.38	148.38	148.38	148.38	1000.0
2007-07-27 06:32:00	SPY	ETF	148.35	148.35	148.35	148.35	500.0
2007-07-27 06:36:00	SPY	ETF	148.42	148.42	148.42	148.42	200.0
2007-07-27 06:38:00	SPY	ETF	148.47	148.47	148.46	148.47	4100.0
2007-07-27 06:44:00	SPY	ETF	148.47	148.48	148.47	148.48	12500.0
2007-07-27 06:45:00	SPY	ETF	148.42	148.42	148.42	148.42	1000.0
2007-07-27 06:50:00	SPY	ETF	148.33	148.33	148.33	148.33	100.0
2007-07-27 06:53:00	SPY	ETF	148.23	148.23	148.23	148.23	100.0
2007-07-27 06:55:00	SPY	ETF	148.01	148.05	147.99	148.04	26000.0
2007-07-27 06:59:00	SPY	ETF	148.1	148.1	148.08	148.08	68700.0
2007-07-27 07:00:00	SPY	ETF	148.1	148.1	148.05	148.06	131100.0
2007-07-27 07:01:00	SPY	ETF	148.04	148.06	147.97	148.03	16000.0
2007-07-27 07:02:00	SPY	ETF	147.98	147.98	147.98	147.98	24900.0
2007-07-27 07:03:00	SPY	ETF	147.95	147.95	147.88	147.89	101600.0
2007-07-27 07:04:00	SPY	ETF	147.89	147.93	147.89	147.93	10500.0
2007-07-27 07:05:00	SPY	ETF	147.87	147.87	147.8	147.84	18400.0
2007-07-27 07:06:00	SPY	ETF	147.8	147.84	147.8	147.82	22500.0
2007-07-27 07:07:00	SPY	ETF	147.78	147.79	147.75	147.79	59900.0
2007-07-27 07:08:00	SPY	ETF	147.82	147.82	147.8	147.8	7900.0
2007-07-27 07:09:00	SPY	ETF	147.78	147.81	147.66	147.74	103600.0
2007-07-27 07:10:00	SPY	ETF	147.75	147.75	147.65	147.7	101000.0
2007-07-27 07:11:00	SPY	ETF	147.68	147.72	147.68	147.72	54300.0
2007-07-27 07:12:00	SPY	ETF	147.7	147.71	147.66	147.7	123700.0
2007-07-27 07:13:00	SPY	ETF	147.7	147.74	147.66	147.7	182300.0
2007-07-27 07:14:00	SPY	ETF	147.7	147.7	147.5	147.6	109100.0
2007-07-27 07:15:00	SPY	ETF	147.63	147.66	147.24	147.6	206600.0
2007-07-27 07:16:00	SPY	ETF	147.62	147.7	147.6	147.68	12300.0
2007-07-27 07:17:00	SPY	ETF	147.68	147.68	147.65	147.66	22000.0
2007-07-27 07:18:00	SPY	ETF	147.66	147.66	147.1	147.44	312700.0
2007-07-27 07:19:00	SPY	ETF	147.44	147.44	147.35	147.4	246300.0
2007-07-27 07:20:00	SPY	ETF	147.37	147.48	147.35	147.48	99900.0
2007-07-27 07:21:00	SPY	ETF	147.46	147.48	147.4	147.45	154100.0

> showing 50 of 57,089 rows — these rows as CSV

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