PREVIEW / etf_1min / 2009-08-10

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-08-10.parquet
  size:    1.6 MB
  rows:    89,243

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-08-10 04:38:00	SPY	ETF	101.01	101.01	101.01	101.01	2000.0
2009-08-10 05:04:00	SPY	ETF	101.02	101.02	101.02	101.02	100.0
2009-08-10 05:17:00	SPY	ETF	101.04	101.04	101.04	101.04	100.0
2009-08-10 05:18:00	SPY	ETF	101.04	101.04	101.04	101.04	200.0
2009-08-10 05:31:00	SPY	ETF	100.98	100.98	100.98	100.98	200.0
2009-08-10 06:12:00	SPY	ETF	100.93	100.93	100.93	100.93	100.0
2009-08-10 06:21:00	SPY	ETF	100.97	100.97	100.97	100.97	2000.0
2009-08-10 06:27:00	SPY	ETF	100.92	100.92	100.92	100.92	4000.0
2009-08-10 06:35:00	SPY	ETF	100.88	100.88	100.88	100.88	100.0
2009-08-10 07:00:00	SPY	ETF	100.9	100.9	100.9	100.9	1992.0
2009-08-10 07:02:00	SPY	ETF	100.81	100.81	100.81	100.81	2050.0
2009-08-10 07:05:00	SPY	ETF	100.77	100.77	100.73	100.73	7500.0
2009-08-10 07:07:00	SPY	ETF	100.7	100.7	100.7	100.7	200.0
2009-08-10 07:08:00	SPY	ETF	100.7	100.7	100.7	100.7	5000.0
2009-08-10 07:09:00	SPY	ETF	100.72	100.72	100.68	100.72	2258.0
2009-08-10 07:10:00	SPY	ETF	100.7	100.7	100.7	100.7	4000.0
2009-08-10 07:13:00	SPY	ETF	100.7	100.7	100.7	100.7	1000.0
2009-08-10 07:14:00	SPY	ETF	100.67	100.67	100.66	100.67	11000.0
2009-08-10 07:15:00	SPY	ETF	100.66	100.66	100.65	100.65	100000.0
2009-08-10 07:20:00	SPY	ETF	100.72	100.72	100.72	100.72	200.0
2009-08-10 07:21:00	SPY	ETF	100.72	100.72	100.72	100.72	300.0
2009-08-10 07:23:00	SPY	ETF	100.72	100.72	100.72	100.72	1000.0
2009-08-10 07:24:00	SPY	ETF	100.71	100.75	100.71	100.75	1600.0
2009-08-10 07:25:00	SPY	ETF	100.75	100.75	100.75	100.75	1000.0
2009-08-10 07:26:00	SPY	ETF	100.73	100.73	100.73	100.73	200.0
2009-08-10 07:27:00	SPY	ETF	100.75	100.75	100.75	100.75	600.0
2009-08-10 07:30:00	SPY	ETF	100.75	100.78	100.75	100.78	1900.0
2009-08-10 07:31:00	SPY	ETF	100.76	100.82	100.75	100.8	100300.0
2009-08-10 07:32:00	SPY	ETF	100.8	100.81	100.8	100.81	1000.0
2009-08-10 07:33:00	SPY	ETF	100.77	100.77	100.77	100.77	100.0
2009-08-10 07:35:00	SPY	ETF	100.79	100.79	100.77	100.77	17709.0
2009-08-10 07:36:00	SPY	ETF	100.76	100.76	100.76	100.76	400.0
2009-08-10 07:38:00	SPY	ETF	100.75	100.75	100.75	100.75	13500.0
2009-08-10 07:40:00	SPY	ETF	100.78	100.78	100.78	100.78	8775.0
2009-08-10 07:43:00	SPY	ETF	100.78	100.78	100.77	100.77	5000.0
2009-08-10 07:45:00	SPY	ETF	100.81	100.81	100.77	100.77	11914.0
2009-08-10 07:47:00	SPY	ETF	100.76	100.76	100.76	100.76	8000.0
2009-08-10 07:49:00	SPY	ETF	100.76	100.76	100.75	100.75	21200.0
2009-08-10 07:50:00	SPY	ETF	100.76	100.76	100.74	100.75	45690.0
2009-08-10 07:51:00	SPY	ETF	100.73	100.74	100.73	100.74	6000.0
2009-08-10 07:52:00	SPY	ETF	100.75	100.79	100.75	100.78	10200.0
2009-08-10 07:53:00	SPY	ETF	100.78	100.78	100.77	100.78	10800.0
2009-08-10 07:54:00	SPY	ETF	100.79	100.79	100.79	100.79	1300.0
2009-08-10 07:55:00	SPY	ETF	100.8	100.83	100.8	100.8	9924.0
2009-08-10 07:56:00	SPY	ETF	100.8	100.8	100.78	100.78	7900.0
2009-08-10 07:57:00	SPY	ETF	100.78	100.78	100.77	100.77	75550.0
2009-08-10 07:58:00	SPY	ETF	100.78	100.82	100.78	100.82	18300.0
2009-08-10 07:59:00	SPY	ETF	100.82	100.85	100.82	100.85	8800.0
2009-08-10 08:00:00	SPY	ETF	100.86	100.99	100.71	100.86	1039990.0
2009-08-10 08:01:00	SPY	ETF	100.86	100.87	100.83	100.84	7100.0

> showing 50 of 89,243 rows — these rows as CSV

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