PREVIEW / etf_1min / 2009-03-31

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-03-31.parquet
  size:    1.6 MB
  rows:    87,911

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
2009-03-31 04:15:00	SPY	ETF	79.61	79.61	79.61	79.61	700.0
2009-03-31 04:18:00	SPY	ETF	79.55	79.55	79.55	79.55	1000.0
2009-03-31 04:19:00	SPY	ETF	79.5	79.5	79.5	79.5	1000.0
2009-03-31 04:24:00	SPY	ETF	79.54	79.54	79.54	79.54	200.0
2009-03-31 04:29:00	SPY	ETF	79.57	79.6	79.57	79.6	7834.0
2009-03-31 04:33:00	SPY	ETF	79.59	79.59	79.59	79.59	300.0
2009-03-31 04:43:00	SPY	ETF	79.51	79.51	79.51	79.51	300.0
2009-03-31 04:44:00	SPY	ETF	79.58	79.58	79.58	79.58	2500.0
2009-03-31 05:01:00	SPY	ETF	79.52	79.52	79.52	79.52	100.0
2009-03-31 05:14:00	SPY	ETF	79.46	79.46	79.46	79.46	201.0
2009-03-31 05:32:00	SPY	ETF	79.56	79.56	79.56	79.56	200.0
2009-03-31 05:36:00	SPY	ETF	79.6	79.6	79.6	79.6	100.0
2009-03-31 05:41:00	SPY	ETF	79.64	79.64	79.64	79.64	100.0
2009-03-31 05:52:00	SPY	ETF	79.56	79.56	79.56	79.56	4000.0
2009-03-31 06:08:00	SPY	ETF	79.28	79.28	79.28	79.28	2500.0
2009-03-31 06:13:00	SPY	ETF	79.22	79.22	79.22	79.22	600.0
2009-03-31 06:18:00	SPY	ETF	79.3	79.3	79.3	79.3	20000.0
2009-03-31 06:20:00	SPY	ETF	79.35	79.35	79.35	79.35	5000.0
2009-03-31 06:21:00	SPY	ETF	79.43	79.43	79.43	79.43	2500.0
2009-03-31 06:25:00	SPY	ETF	79.62	79.62	79.62	79.62	100.0
2009-03-31 06:28:00	SPY	ETF	79.64	79.64	79.64	79.64	2500.0
2009-03-31 06:34:00	SPY	ETF	79.65	79.65	79.65	79.65	15000.0
2009-03-31 06:36:00	SPY	ETF	79.58	79.58	79.58	79.58	100.0
2009-03-31 06:37:00	SPY	ETF	79.56	79.56	79.56	79.56	250.0
2009-03-31 06:39:00	SPY	ETF	79.54	79.54	79.53	79.53	25000.0
2009-03-31 06:42:00	SPY	ETF	79.66	79.66	79.66	79.66	2600.0
2009-03-31 06:43:00	SPY	ETF	79.66	79.66	79.66	79.66	100.0
2009-03-31 06:45:00	SPY	ETF	79.66	79.66	79.65	79.65	50000.0
2009-03-31 06:47:00	SPY	ETF	79.7	79.7	79.7	79.7	1000.0
2009-03-31 06:50:00	SPY	ETF	79.65	79.65	79.65	79.65	1000.0
2009-03-31 06:55:00	SPY	ETF	79.7	79.73	79.7	79.73	4600.0
2009-03-31 06:58:00	SPY	ETF	79.71	79.72	79.7	79.72	5425.0
2009-03-31 07:00:00	SPY	ETF	79.65	79.65	79.63	79.63	1100.0
2009-03-31 07:01:00	SPY	ETF	79.62	79.62	79.59	79.6	2200.0
2009-03-31 07:02:00	SPY	ETF	79.61	79.61	79.6	79.6	4800.0
2009-03-31 07:03:00	SPY	ETF	79.59	79.6	79.59	79.6	29500.0
2009-03-31 07:04:00	SPY	ETF	79.6	79.6	79.59	79.6	12100.0
2009-03-31 07:05:00	SPY	ETF	79.6	79.61	79.6	79.6	5300.0
2009-03-31 07:06:00	SPY	ETF	79.59	79.6	79.59	79.6	11800.0
2009-03-31 07:07:00	SPY	ETF	79.61	79.67	79.6	79.66	54200.0
2009-03-31 07:08:00	SPY	ETF	79.68	79.69	79.68	79.69	2100.0
2009-03-31 07:09:00	SPY	ETF	79.69	79.69	79.69	79.69	1000.0
2009-03-31 07:10:00	SPY	ETF	79.63	79.66	79.63	79.66	1600.0
2009-03-31 07:11:00	SPY	ETF	79.61	79.61	79.6	79.6	1600.0
2009-03-31 07:12:00	SPY	ETF	79.6	79.61	79.58	79.61	6400.0
2009-03-31 07:13:00	SPY	ETF	79.58	79.58	79.58	79.58	10100.0
2009-03-31 07:14:00	SPY	ETF	79.59	79.6	79.59	79.6	52500.0
2009-03-31 07:15:00	SPY	ETF	79.59	79.59	79.59	79.59	12000.0
2009-03-31 07:16:00	SPY	ETF	79.59	79.59	79.58	79.58	3000.0
2009-03-31 07:17:00	SPY	ETF	79.57	79.58	79.57	79.58	28500.0

> showing 50 of 87,911 rows — these rows as CSV

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