PREVIEW / etf_1min / 2009-10-23

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-10-23.parquet
  size:    1.8 MB
  rows:    91,995

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-10-23 04:17:00	SPY	ETF	109.81	109.81	109.81	109.81	900.0
2009-10-23 04:31:00	SPY	ETF	109.59	109.59	109.59	109.59	200.0
2009-10-23 04:34:00	SPY	ETF	109.59	109.59	109.59	109.59	200.0
2009-10-23 04:35:00	SPY	ETF	109.56	109.56	109.53	109.53	500.0
2009-10-23 04:40:00	SPY	ETF	109.63	109.63	109.63	109.63	120.0
2009-10-23 04:42:00	SPY	ETF	109.68	109.68	109.68	109.68	100.0
2009-10-23 05:00:00	SPY	ETF	109.49	109.49	109.43	109.43	200.0
2009-10-23 05:52:00	SPY	ETF	109.61	109.61	109.61	109.61	200.0
2009-10-23 05:55:00	SPY	ETF	109.61	109.61	109.61	109.61	100.0
2009-10-23 06:04:00	SPY	ETF	109.58	109.58	109.58	109.58	200.0
2009-10-23 06:12:00	SPY	ETF	109.54	109.54	109.54	109.54	1000.0
2009-10-23 06:27:00	SPY	ETF	109.44	109.44	109.44	109.44	1500.0
2009-10-23 06:37:00	SPY	ETF	109.48	109.48	109.45	109.45	7500.0
2009-10-23 06:41:00	SPY	ETF	109.49	109.49	109.49	109.49	100.0
2009-10-23 06:57:00	SPY	ETF	109.54	109.54	109.54	109.54	200.0
2009-10-23 07:00:00	SPY	ETF	109.5	109.5	109.45	109.45	5000.0
2009-10-23 07:01:00	SPY	ETF	109.46	109.48	109.46	109.48	3000.0
2009-10-23 07:02:00	SPY	ETF	109.49	109.49	109.49	109.49	2000.0
2009-10-23 07:03:00	SPY	ETF	109.49	109.49	109.49	109.49	1000.0
2009-10-23 07:04:00	SPY	ETF	109.54	109.54	109.54	109.54	6750.0
2009-10-23 07:05:00	SPY	ETF	109.57	109.57	109.57	109.57	400.0
2009-10-23 07:07:00	SPY	ETF	109.62	109.62	109.62	109.62	300.0
2009-10-23 07:08:00	SPY	ETF	109.64	109.64	109.64	109.64	100.0
2009-10-23 07:09:00	SPY	ETF	109.65	109.65	109.65	109.65	300.0
2009-10-23 07:11:00	SPY	ETF	109.65	109.65	109.65	109.65	3800.0
2009-10-23 07:12:00	SPY	ETF	109.65	109.69	109.65	109.69	25100.0
2009-10-23 07:13:00	SPY	ETF	109.65	109.65	109.63	109.63	7413.0
2009-10-23 07:14:00	SPY	ETF	109.69	109.69	109.69	109.69	1000.0
2009-10-23 07:15:00	SPY	ETF	109.64	109.64	109.63	109.63	2003.0
2009-10-23 07:17:00	SPY	ETF	109.65	109.65	109.65	109.65	14100.0
2009-10-23 07:18:00	SPY	ETF	109.62	109.62	109.62	109.62	2201.0
2009-10-23 07:19:00	SPY	ETF	109.62	109.62	109.62	109.62	120.0
2009-10-23 07:21:00	SPY	ETF	109.62	109.62	109.62	109.62	6700.0
2009-10-23 07:22:00	SPY	ETF	109.64	109.64	109.63	109.63	1099.0
2009-10-23 07:24:00	SPY	ETF	109.61	109.64	109.61	109.64	2600.0
2009-10-23 07:27:00	SPY	ETF	109.65	109.65	109.65	109.65	1300.0
2009-10-23 07:28:00	SPY	ETF	109.72	109.72	109.72	109.72	24950.0
2009-10-23 07:29:00	SPY	ETF	109.71	109.71	109.71	109.71	100.0
2009-10-23 07:30:00	SPY	ETF	109.74	109.76	109.71	109.71	75154.0
2009-10-23 07:31:00	SPY	ETF	109.75	109.75	109.75	109.75	100.0
2009-10-23 07:32:00	SPY	ETF	109.74	109.77	109.74	109.77	5200.0
2009-10-23 07:33:00	SPY	ETF	109.78	109.78	109.73	109.74	5184.0
2009-10-23 07:34:00	SPY	ETF	109.68	109.72	109.68	109.72	5300.0
2009-10-23 07:37:00	SPY	ETF	109.69	109.69	109.61	109.61	1200.0
2009-10-23 07:38:00	SPY	ETF	109.65	109.65	109.65	109.65	5000.0
2009-10-23 07:42:00	SPY	ETF	109.67	109.67	109.67	109.67	1500.0
2009-10-23 07:44:00	SPY	ETF	109.7	109.7	109.7	109.7	10000.0
2009-10-23 07:45:00	SPY	ETF	109.7	109.7	109.7	109.7	1000.0
2009-10-23 07:46:00	SPY	ETF	109.67	109.7	109.67	109.7	15500.0
2009-10-23 07:47:00	SPY	ETF	109.67	109.67	109.67	109.67	2500.0

> showing 50 of 91,995 rows — these rows as CSV

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