PREVIEW / etf_1min / 2009-07-29

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-07-29.parquet
  size:    1.6 MB
  rows:    88,403

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-29 04:12:00	SPY	ETF	97.58	97.58	97.58	97.58	100.0
2009-07-29 04:15:00	SPY	ETF	97.67	97.77	97.67	97.77	2300.0
2009-07-29 04:16:00	SPY	ETF	97.86	97.86	97.86	97.86	100.0
2009-07-29 04:24:00	SPY	ETF	97.76	97.76	97.76	97.76	100.0
2009-07-29 04:27:00	SPY	ETF	97.66	97.66	97.66	97.66	100.0
2009-07-29 05:09:00	SPY	ETF	97.66	97.66	97.66	97.66	2000.0
2009-07-29 05:27:00	SPY	ETF	97.67	97.67	97.67	97.67	2000.0
2009-07-29 05:28:00	SPY	ETF	97.76	97.76	97.76	97.76	100.0
2009-07-29 05:39:00	SPY	ETF	97.66	97.66	97.66	97.66	100.0
2009-07-29 05:43:00	SPY	ETF	97.62	97.62	97.62	97.62	2500.0
2009-07-29 05:44:00	SPY	ETF	97.62	97.62	97.6	97.6	65000.0
2009-07-29 05:45:00	SPY	ETF	97.59	97.6	97.56	97.56	32500.0
2009-07-29 05:47:00	SPY	ETF	97.58	97.58	97.58	97.58	150.0
2009-07-29 05:54:00	SPY	ETF	97.55	97.55	97.55	97.55	700.0
2009-07-29 05:57:00	SPY	ETF	97.52	97.52	97.52	97.52	100.0
2009-07-29 05:58:00	SPY	ETF	97.52	97.52	97.5	97.5	5200.0
2009-07-29 05:59:00	SPY	ETF	97.49	97.49	97.4	97.4	1050.0
2009-07-29 06:01:00	SPY	ETF	97.47	97.47	97.47	97.47	2500.0
2009-07-29 06:02:00	SPY	ETF	97.51	97.55	97.51	97.55	2600.0
2009-07-29 06:03:00	SPY	ETF	97.54	97.54	97.54	97.54	2500.0
2009-07-29 06:05:00	SPY	ETF	97.54	97.54	97.5	97.5	1000.0
2009-07-29 06:06:00	SPY	ETF	97.52	97.52	97.52	97.52	200.0
2009-07-29 06:07:00	SPY	ETF	97.56	97.57	97.56	97.57	200.0
2009-07-29 06:13:00	SPY	ETF	97.62	97.62	97.62	97.62	150.0
2009-07-29 06:15:00	SPY	ETF	97.59	97.59	97.59	97.59	25000.0
2009-07-29 06:16:00	SPY	ETF	97.66	97.66	97.66	97.66	100.0
2009-07-29 06:17:00	SPY	ETF	97.67	97.67	97.67	97.67	2500.0
2009-07-29 06:19:00	SPY	ETF	97.7	97.7	97.7	97.7	100.0
2009-07-29 06:36:00	SPY	ETF	97.76	97.76	97.76	97.76	100.0
2009-07-29 06:37:00	SPY	ETF	97.72	97.72	97.72	97.72	25000.0
2009-07-29 06:39:00	SPY	ETF	97.73	97.73	97.73	97.73	5000.0
2009-07-29 06:40:00	SPY	ETF	97.8	97.8	97.8	97.8	2000.0
2009-07-29 06:42:00	SPY	ETF	97.8	97.81	97.8	97.81	2500.0
2009-07-29 06:43:00	SPY	ETF	97.79	97.79	97.79	97.79	100.0
2009-07-29 06:44:00	SPY	ETF	97.72	97.72	97.72	97.72	100.0
2009-07-29 06:49:00	SPY	ETF	97.77	97.81	97.77	97.79	14500.0
2009-07-29 06:52:00	SPY	ETF	97.78	97.78	97.76	97.76	1300.0
2009-07-29 06:54:00	SPY	ETF	97.77	97.77	97.77	97.77	5000.0
2009-07-29 06:57:00	SPY	ETF	97.77	97.77	97.73	97.73	5000.0
2009-07-29 06:58:00	SPY	ETF	97.67	97.67	97.67	97.67	1500.0
2009-07-29 07:00:00	SPY	ETF	97.75	97.75	97.75	97.75	500.0
2009-07-29 07:01:00	SPY	ETF	97.73	97.73	97.72	97.72	2000.0
2009-07-29 07:02:00	SPY	ETF	97.7	97.7	97.7	97.7	3000.0
2009-07-29 07:03:00	SPY	ETF	97.68	97.68	97.65	97.65	1700.0
2009-07-29 07:04:00	SPY	ETF	97.68	97.68	97.65	97.65	6896.0
2009-07-29 07:08:00	SPY	ETF	97.68	97.68	97.68	97.68	1500.0
2009-07-29 07:09:00	SPY	ETF	97.72	97.72	97.72	97.72	500.0
2009-07-29 07:10:00	SPY	ETF	97.7	97.7	97.7	97.7	100.0
2009-07-29 07:11:00	SPY	ETF	97.71	97.71	97.71	97.71	5100.0
2009-07-29 07:12:00	SPY	ETF	97.7	97.7	97.69	97.69	200.0

> showing 50 of 88,403 rows — these rows as CSV

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