PREVIEW / etf_1min / 2009-05-01

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-05-01.parquet
  size:    1.6 MB
  rows:    87,683

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-05-01 04:15:00	SPY	ETF	87.7	87.7	87.7	87.7	800.0
2009-05-01 04:18:00	SPY	ETF	87.7	87.7	87.7	87.7	100.0
2009-05-01 04:20:00	SPY	ETF	87.7	87.7	87.7	87.7	100.0
2009-05-01 04:59:00	SPY	ETF	87.73	87.73	87.73	87.73	100.0
2009-05-01 05:00:00	SPY	ETF	87.78	87.78	87.78	87.78	100.0
2009-05-01 05:01:00	SPY	ETF	87.83	87.83	87.83	87.83	100.0
2009-05-01 05:04:00	SPY	ETF	87.84	87.84	87.84	87.84	900.0
2009-05-01 05:19:00	SPY	ETF	87.77	87.77	87.77	87.77	100.0
2009-05-01 05:40:00	SPY	ETF	87.72	87.72	87.72	87.72	150.0
2009-05-01 05:44:00	SPY	ETF	87.74	87.77	87.74	87.77	15000.0
2009-05-01 05:45:00	SPY	ETF	87.77	87.78	87.77	87.78	9100.0
2009-05-01 05:48:00	SPY	ETF	87.78	87.78	87.78	87.78	8400.0
2009-05-01 06:00:00	SPY	ETF	87.78	87.78	87.78	87.78	600.0
2009-05-01 06:02:00	SPY	ETF	87.77	87.77	87.77	87.77	15000.0
2009-05-01 06:30:00	SPY	ETF	87.75	87.75	87.75	87.75	100.0
2009-05-01 06:31:00	SPY	ETF	87.75	87.75	87.75	87.75	2400.0
2009-05-01 06:45:00	SPY	ETF	87.8	87.8	87.8	87.8	1000.0
2009-05-01 06:46:00	SPY	ETF	87.8	87.86	87.8	87.86	11500.0
2009-05-01 06:47:00	SPY	ETF	87.84	87.84	87.84	87.84	1000.0
2009-05-01 06:48:00	SPY	ETF	87.87	87.87	87.87	87.87	2500.0
2009-05-01 06:49:00	SPY	ETF	87.86	87.89	87.86	87.89	2002.0
2009-05-01 06:50:00	SPY	ETF	87.87	87.87	87.87	87.87	9448.0
2009-05-01 06:51:00	SPY	ETF	87.82	87.82	87.82	87.82	186.0
2009-05-01 06:52:00	SPY	ETF	87.84	87.84	87.84	87.84	4000.0
2009-05-01 06:54:00	SPY	ETF	87.86	87.86	87.86	87.86	2000.0
2009-05-01 06:55:00	SPY	ETF	87.88	87.88	87.88	87.88	100.0
2009-05-01 06:56:00	SPY	ETF	87.88	87.88	87.88	87.88	900.0
2009-05-01 06:57:00	SPY	ETF	87.89	87.9	87.89	87.9	1000.0
2009-05-01 06:59:00	SPY	ETF	87.89	87.89	87.89	87.89	100.0
2009-05-01 07:00:00	SPY	ETF	87.86	87.86	87.86	87.86	200.0
2009-05-01 07:01:00	SPY	ETF	87.86	87.87	87.86	87.87	1000.0
2009-05-01 07:02:00	SPY	ETF	87.87	87.88	87.87	87.88	1500.0
2009-05-01 07:03:00	SPY	ETF	87.86	87.88	87.86	87.88	5941.0
2009-05-01 07:04:00	SPY	ETF	87.86	87.86	87.85	87.85	6169.0
2009-05-01 07:05:00	SPY	ETF	87.83	87.83	87.82	87.82	2000.0
2009-05-01 07:06:00	SPY	ETF	87.83	87.83	87.8	87.8	4393.0
2009-05-01 07:07:00	SPY	ETF	87.82	87.82	87.82	87.82	1400.0
2009-05-01 07:08:00	SPY	ETF	87.83	87.85	87.83	87.85	2473.0
2009-05-01 07:09:00	SPY	ETF	87.86	87.86	87.86	87.86	1169.0
2009-05-01 07:10:00	SPY	ETF	87.86	87.86	87.86	87.86	4100.0
2009-05-01 07:11:00	SPY	ETF	87.86	87.87	87.86	87.87	2231.0
2009-05-01 07:12:00	SPY	ETF	87.84	87.85	87.84	87.85	1169.0
2009-05-01 07:14:00	SPY	ETF	87.83	87.85	87.83	87.85	2800.0
2009-05-01 07:15:00	SPY	ETF	87.87	87.87	87.87	87.87	1000.0
2009-05-01 07:16:00	SPY	ETF	87.85	87.85	87.84	87.84	1106.0
2009-05-01 07:19:00	SPY	ETF	87.84	87.84	87.82	87.82	402.0
2009-05-01 07:20:00	SPY	ETF	87.82	87.82	87.82	87.82	600.0
2009-05-01 07:21:00	SPY	ETF	87.82	87.87	87.81	87.87	6738.0
2009-05-01 07:23:00	SPY	ETF	87.85	87.86	87.84	87.86	2900.0
2009-05-01 07:24:00	SPY	ETF	87.86	87.86	87.86	87.86	100.0

> showing 50 of 87,683 rows — these rows as CSV

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