PREVIEW / etf_1min / 2009-07-20

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-20.parquet
  size:    1.7 MB
  rows:    93,402

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-07-20 04:15:00	SPY	ETF	94.41	94.45	94.41	94.45	1100.0
2009-07-20 04:16:00	SPY	ETF	94.46	94.46	94.46	94.46	100.0
2009-07-20 04:26:00	SPY	ETF	94.41	94.41	94.41	94.41	100.0
2009-07-20 04:35:00	SPY	ETF	94.38	94.38	94.38	94.38	100.0
2009-07-20 04:37:00	SPY	ETF	94.35	94.37	94.35	94.37	200.0
2009-07-20 04:48:00	SPY	ETF	94.38	94.38	94.38	94.38	100.0
2009-07-20 04:50:00	SPY	ETF	94.36	94.36	94.36	94.36	100.0
2009-07-20 05:07:00	SPY	ETF	94.46	94.46	94.46	94.46	400.0
2009-07-20 05:08:00	SPY	ETF	94.5	94.5	94.5	94.5	300.0
2009-07-20 05:10:00	SPY	ETF	94.62	94.62	94.62	94.62	100.0
2009-07-20 05:11:00	SPY	ETF	94.65	94.66	94.65	94.65	8100.0
2009-07-20 05:16:00	SPY	ETF	94.64	94.66	94.64	94.66	3500.0
2009-07-20 05:18:00	SPY	ETF	94.7	94.7	94.7	94.7	100.0
2009-07-20 05:19:00	SPY	ETF	94.71	94.73	94.71	94.73	700.0
2009-07-20 05:20:00	SPY	ETF	94.74	94.82	94.74	94.81	1900.0
2009-07-20 05:21:00	SPY	ETF	94.82	94.82	94.82	94.82	600.0
2009-07-20 05:22:00	SPY	ETF	94.83	94.83	94.83	94.83	400.0
2009-07-20 05:33:00	SPY	ETF	94.78	94.78	94.78	94.78	200.0
2009-07-20 05:51:00	SPY	ETF	94.75	94.75	94.75	94.75	100.0
2009-07-20 05:53:00	SPY	ETF	94.75	94.75	94.75	94.75	500.0
2009-07-20 06:07:00	SPY	ETF	94.8	94.82	94.8	94.82	5600.0
2009-07-20 06:10:00	SPY	ETF	94.82	94.82	94.82	94.82	1600.0
2009-07-20 06:12:00	SPY	ETF	94.83	94.83	94.83	94.83	1400.0
2009-07-20 06:14:00	SPY	ETF	94.82	94.82	94.82	94.82	800.0
2009-07-20 06:15:00	SPY	ETF	94.81	94.81	94.81	94.81	1000.0
2009-07-20 06:16:00	SPY	ETF	94.84	94.85	94.84	94.85	400.0
2009-07-20 06:18:00	SPY	ETF	94.85	94.85	94.85	94.85	2500.0
2009-07-20 06:19:00	SPY	ETF	94.86	94.87	94.86	94.87	500.0
2009-07-20 06:20:00	SPY	ETF	94.86	94.86	94.86	94.86	1600.0
2009-07-20 06:21:00	SPY	ETF	94.88	94.88	94.88	94.88	300.0
2009-07-20 06:23:00	SPY	ETF	94.88	94.88	94.88	94.88	2500.0
2009-07-20 06:28:00	SPY	ETF	94.89	94.91	94.89	94.91	5900.0
2009-07-20 06:29:00	SPY	ETF	94.91	94.91	94.91	94.91	16700.0
2009-07-20 06:34:00	SPY	ETF	94.86	94.86	94.86	94.86	200.0
2009-07-20 06:38:00	SPY	ETF	94.91	94.91	94.91	94.91	100.0
2009-07-20 06:43:00	SPY	ETF	94.86	94.86	94.85	94.85	5000.0
2009-07-20 06:44:00	SPY	ETF	94.85	94.85	94.85	94.85	5000.0
2009-07-20 06:45:00	SPY	ETF	94.88	94.88	94.87	94.88	5100.0
2009-07-20 06:46:00	SPY	ETF	94.89	94.89	94.89	94.89	2700.0
2009-07-20 06:47:00	SPY	ETF	94.85	94.85	94.85	94.85	1500.0
2009-07-20 06:48:00	SPY	ETF	94.85	94.89	94.85	94.88	9000.0
2009-07-20 06:49:00	SPY	ETF	94.88	94.88	94.83	94.83	7000.0
2009-07-20 06:50:00	SPY	ETF	94.83	94.83	94.83	94.83	110.0
2009-07-20 06:51:00	SPY	ETF	94.83	94.85	94.82	94.85	94110.0
2009-07-20 06:53:00	SPY	ETF	94.83	94.83	94.82	94.82	35600.0
2009-07-20 06:54:00	SPY	ETF	94.82	94.85	94.82	94.83	38690.0
2009-07-20 06:55:00	SPY	ETF	94.83	94.83	94.83	94.83	45000.0
2009-07-20 06:56:00	SPY	ETF	94.83	94.83	94.83	94.83	20000.0
2009-07-20 06:57:00	SPY	ETF	94.8	94.8	94.79	94.8	23000.0
2009-07-20 06:58:00	SPY	ETF	94.81	94.81	94.81	94.81	200.0

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

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