PREVIEW / etf_1min / 2007-06-27

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-06-27.parquet
  size:    714 KB
  rows:    44,483

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-27 04:20:00	SPY	ETF	148.5	148.5	148.46	148.46	1400.0
2007-06-27 05:13:00	SPY	ETF	148.4	148.4	148.4	148.4	2000.0
2007-06-27 06:17:00	SPY	ETF	148.54	148.54	148.54	148.54	2500.0
2007-06-27 06:18:00	SPY	ETF	148.54	148.54	148.54	148.54	2500.0
2007-06-27 06:33:00	SPY	ETF	148.59	148.59	148.59	148.59	2500.0
2007-06-27 06:38:00	SPY	ETF	148.51	148.51	148.51	148.51	2500.0
2007-06-27 06:45:00	SPY	ETF	148.6	148.6	148.6	148.6	2400.0
2007-06-27 06:55:00	SPY	ETF	148.63	148.63	148.63	148.63	2500.0
2007-06-27 06:56:00	SPY	ETF	148.66	148.7	148.66	148.7	5100.0
2007-06-27 06:58:00	SPY	ETF	148.7	148.7	148.7	148.7	3500.0
2007-06-27 07:02:00	SPY	ETF	148.66	148.66	148.66	148.66	100000.0
2007-06-27 07:05:00	SPY	ETF	148.68	148.68	148.68	148.68	50000.0
2007-06-27 07:07:00	SPY	ETF	148.7	148.7	148.7	148.7	10900.0
2007-06-27 07:14:00	SPY	ETF	148.61	148.61	148.6	148.6	25900.0
2007-06-27 07:15:00	SPY	ETF	148.6	148.6	148.58	148.58	1100.0
2007-06-27 07:17:00	SPY	ETF	148.57	148.57	148.57	148.57	25000.0
2007-06-27 07:18:00	SPY	ETF	148.57	148.57	148.57	148.57	55000.0
2007-06-27 07:19:00	SPY	ETF	148.6	148.6	148.6	148.6	25000.0
2007-06-27 07:24:00	SPY	ETF	148.57	148.57	148.55	148.56	12500.0
2007-06-27 07:25:00	SPY	ETF	148.56	148.56	148.52	148.55	30500.0
2007-06-27 07:28:00	SPY	ETF	148.42	148.43	148.41	148.41	12100.0
2007-06-27 07:29:00	SPY	ETF	148.43	148.45	148.4	148.4	9100.0
2007-06-27 07:32:00	SPY	ETF	148.32	148.32	148.27	148.27	4500.0
2007-06-27 07:34:00	SPY	ETF	148.34	148.34	148.32	148.32	18000.0
2007-06-27 07:35:00	SPY	ETF	148.35	148.37	148.32	148.33	130200.0
2007-06-27 07:36:00	SPY	ETF	148.33	148.33	148.33	148.33	10000.0
2007-06-27 07:38:00	SPY	ETF	148.38	148.38	148.38	148.38	5000.0
2007-06-27 07:39:00	SPY	ETF	148.36	148.38	148.35	148.38	35000.0
2007-06-27 07:40:00	SPY	ETF	148.38	148.38	148.36	148.36	12200.0
2007-06-27 07:41:00	SPY	ETF	148.35	148.4	148.33	148.4	50400.0
2007-06-27 07:43:00	SPY	ETF	148.38	148.43	148.38	148.43	11000.0
2007-06-27 07:44:00	SPY	ETF	148.4	148.4	148.36	148.36	12800.0
2007-06-27 07:45:00	SPY	ETF	148.41	148.41	148.41	148.41	900.0
2007-06-27 07:46:00	SPY	ETF	148.39	148.4	148.39	148.4	5100.0
2007-06-27 07:47:00	SPY	ETF	148.4	148.4	148.4	148.4	29000.0
2007-06-27 07:48:00	SPY	ETF	148.38	148.4	148.38	148.38	8100.0
2007-06-27 07:50:00	SPY	ETF	148.37	148.38	148.37	148.37	4600.0
2007-06-27 07:51:00	SPY	ETF	148.39	148.4	148.39	148.4	500.0
2007-06-27 07:53:00	SPY	ETF	148.4	148.4	148.4	148.4	2000.0
2007-06-27 07:55:00	SPY	ETF	148.39	148.4	148.39	148.4	8100.0
2007-06-27 07:56:00	SPY	ETF	148.39	148.39	148.38	148.38	29000.0
2007-06-27 07:57:00	SPY	ETF	148.4	148.4	148.36	148.36	20200.0
2007-06-27 07:58:00	SPY	ETF	148.37	148.37	148.29	148.31	170900.0
2007-06-27 07:59:00	SPY	ETF	148.3	148.35	148.27	148.27	238200.0
2007-06-27 08:00:00	SPY	ETF	148.28	148.3	148.27	148.27	59600.0
2007-06-27 08:01:00	SPY	ETF	148.3	148.3	148.29	148.3	22000.0
2007-06-27 08:02:00	SPY	ETF	148.3	148.3	148.27	148.28	34100.0
2007-06-27 08:03:00	SPY	ETF	148.3	148.3	148.25	148.3	228700.0
2007-06-27 08:04:00	SPY	ETF	148.3	148.3	148.28	148.3	20100.0
2007-06-27 08:05:00	SPY	ETF	148.28	148.28	148.21	148.23	164600.0

> showing 50 of 44,483 rows — these rows as CSV

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