PREVIEW / etf_1min / 2009-04-17

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-04-17.parquet
  size:    1.6 MB
  rows:    93,607

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-04-17 04:22:00	SPY	ETF	86.1	86.18	86.1	86.18	1100.0
2009-04-17 05:04:00	SPY	ETF	86.05	86.05	86.05	86.05	100.0
2009-04-17 05:06:00	SPY	ETF	86.0	86.0	86.0	86.0	100.0
2009-04-17 05:08:00	SPY	ETF	85.98	85.98	85.98	85.98	200.0
2009-04-17 05:15:00	SPY	ETF	86.0	86.0	86.0	86.0	200.0
2009-04-17 05:16:00	SPY	ETF	86.02	86.02	86.02	86.02	100.0
2009-04-17 05:24:00	SPY	ETF	86.06	86.06	86.06	86.06	300.0
2009-04-17 05:25:00	SPY	ETF	86.07	86.07	86.07	86.07	600.0
2009-04-17 05:34:00	SPY	ETF	86.09	86.09	86.09	86.09	200.0
2009-04-17 05:36:00	SPY	ETF	86.09	86.09	86.09	86.09	201.0
2009-04-17 05:41:00	SPY	ETF	86.08	86.08	86.08	86.08	1000.0
2009-04-17 05:47:00	SPY	ETF	86.19	86.2	86.19	86.2	10500.0
2009-04-17 05:48:00	SPY	ETF	86.18	86.18	86.18	86.18	300.0
2009-04-17 05:49:00	SPY	ETF	86.2	86.23	86.2	86.23	500.0
2009-04-17 05:50:00	SPY	ETF	86.25	86.31	86.25	86.31	1300.0
2009-04-17 05:51:00	SPY	ETF	86.35	86.35	86.35	86.35	400.0
2009-04-17 05:53:00	SPY	ETF	86.24	86.43	86.24	86.43	700.0
2009-04-17 05:54:00	SPY	ETF	86.41	86.43	86.41	86.43	600.0
2009-04-17 05:55:00	SPY	ETF	86.41	86.41	86.41	86.41	1000.0
2009-04-17 05:56:00	SPY	ETF	86.53	86.53	86.42	86.42	1800.0
2009-04-17 06:02:00	SPY	ETF	86.29	86.29	86.29	86.29	500.0
2009-04-17 06:03:00	SPY	ETF	86.35	86.35	86.35	86.35	250.0
2009-04-17 06:04:00	SPY	ETF	86.41	86.42	86.41	86.42	25000.0
2009-04-17 06:11:00	SPY	ETF	86.41	86.41	86.41	86.41	200.0
2009-04-17 06:12:00	SPY	ETF	86.44	86.46	86.44	86.46	350.0
2009-04-17 06:14:00	SPY	ETF	86.47	86.47	86.45	86.45	14500.0
2009-04-17 06:17:00	SPY	ETF	86.43	86.43	86.43	86.43	147.0
2009-04-17 06:20:00	SPY	ETF	86.43	86.43	86.43	86.43	122.0
2009-04-17 06:21:00	SPY	ETF	86.42	86.42	86.42	86.42	3000.0
2009-04-17 06:22:00	SPY	ETF	86.47	86.52	86.47	86.52	25100.0
2009-04-17 06:23:00	SPY	ETF	86.5	86.52	86.5	86.5	50000.0
2009-04-17 06:24:00	SPY	ETF	86.54	86.54	86.54	86.54	600.0
2009-04-17 06:25:00	SPY	ETF	86.54	86.57	86.52	86.57	1600.0
2009-04-17 06:26:00	SPY	ETF	86.59	86.6	86.59	86.6	3100.0
2009-04-17 06:27:00	SPY	ETF	86.64	86.72	86.64	86.72	3000.0
2009-04-17 06:28:00	SPY	ETF	86.73	86.78	86.73	86.78	10500.0
2009-04-17 06:29:00	SPY	ETF	86.66	86.66	86.66	86.66	400.0
2009-04-17 06:30:00	SPY	ETF	86.7	86.84	86.64	86.64	22150.0
2009-04-17 06:31:00	SPY	ETF	86.72	86.72	86.72	86.72	100.0
2009-04-17 06:32:00	SPY	ETF	86.56	86.62	86.5	86.5	4200.0
2009-04-17 06:33:00	SPY	ETF	86.6	86.6	86.6	86.6	2500.0
2009-04-17 06:36:00	SPY	ETF	86.5	86.5	86.5	86.5	500.0
2009-04-17 06:37:00	SPY	ETF	86.6	86.6	86.6	86.6	200.0
2009-04-17 06:38:00	SPY	ETF	86.51	86.51	86.49	86.49	6500.0
2009-04-17 06:39:00	SPY	ETF	86.61	86.67	86.61	86.65	2200.0
2009-04-17 06:40:00	SPY	ETF	86.7	86.77	86.7	86.77	29300.0
2009-04-17 06:41:00	SPY	ETF	86.59	86.76	86.59	86.76	6600.0
2009-04-17 06:43:00	SPY	ETF	86.64	86.64	86.64	86.64	100.0
2009-04-17 06:48:00	SPY	ETF	86.62	86.62	86.62	86.62	100.0
2009-04-17 06:50:00	SPY	ETF	86.57	86.57	86.57	86.57	5000.0

> showing 50 of 93,607 rows — these rows as CSV

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