PREVIEW / etf_1min / 2009-03-19

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-03-19.parquet
  size:    1.8 MB
  rows:    99,078

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-03-19 04:18:00	SPY	ETF	79.5	79.5	79.43	79.43	1100.0
2009-03-19 04:20:00	SPY	ETF	79.38	79.38	79.35	79.35	300.0
2009-03-19 04:25:00	SPY	ETF	79.36	79.36	79.27	79.27	450.0
2009-03-19 04:26:00	SPY	ETF	79.3	79.3	79.3	79.3	250.0
2009-03-19 04:29:00	SPY	ETF	79.28	79.28	79.28	79.28	500.0
2009-03-19 04:32:00	SPY	ETF	79.34	79.34	79.34	79.34	500.0
2009-03-19 04:33:00	SPY	ETF	79.36	79.36	79.36	79.36	1000.0
2009-03-19 04:36:00	SPY	ETF	79.51	79.51	79.51	79.51	500.0
2009-03-19 04:39:00	SPY	ETF	79.52	79.52	79.52	79.52	1000.0
2009-03-19 04:44:00	SPY	ETF	79.49	79.49	79.49	79.49	400.0
2009-03-19 05:05:00	SPY	ETF	79.59	79.59	79.59	79.59	500.0
2009-03-19 05:07:00	SPY	ETF	79.61	79.61	79.61	79.61	5000.0
2009-03-19 05:17:00	SPY	ETF	79.57	79.57	79.57	79.57	100.0
2009-03-19 05:21:00	SPY	ETF	79.48	79.48	79.48	79.48	100.0
2009-03-19 05:23:00	SPY	ETF	79.49	79.49	79.49	79.49	2000.0
2009-03-19 05:27:00	SPY	ETF	79.52	79.52	79.52	79.52	100.0
2009-03-19 05:49:00	SPY	ETF	79.66	79.66	79.66	79.66	100.0
2009-03-19 05:50:00	SPY	ETF	79.59	79.59	79.59	79.59	2000.0
2009-03-19 05:57:00	SPY	ETF	79.56	79.56	79.56	79.56	1000.0
2009-03-19 06:01:00	SPY	ETF	79.6	79.61	79.6	79.61	10000.0
2009-03-19 06:02:00	SPY	ETF	79.64	79.64	79.64	79.64	2900.0
2009-03-19 06:03:00	SPY	ETF	79.61	79.61	79.61	79.61	3000.0
2009-03-19 06:04:00	SPY	ETF	79.65	79.65	79.65	79.65	1000.0
2009-03-19 06:05:00	SPY	ETF	79.65	79.65	79.65	79.65	1000.0
2009-03-19 06:09:00	SPY	ETF	79.62	79.63	79.62	79.63	7500.0
2009-03-19 06:10:00	SPY	ETF	79.59	79.59	79.56	79.56	12000.0
2009-03-19 06:11:00	SPY	ETF	79.59	79.59	79.56	79.56	13000.0
2009-03-19 06:14:00	SPY	ETF	79.56	79.56	79.56	79.56	10000.0
2009-03-19 06:25:00	SPY	ETF	79.7	79.7	79.7	79.7	5000.0
2009-03-19 06:26:00	SPY	ETF	79.64	79.64	79.58	79.58	11600.0
2009-03-19 06:30:00	SPY	ETF	79.57	79.57	79.57	79.57	3000.0
2009-03-19 06:33:00	SPY	ETF	79.56	79.56	79.56	79.56	100.0
2009-03-19 06:34:00	SPY	ETF	79.57	79.57	79.57	79.57	50000.0
2009-03-19 06:37:00	SPY	ETF	79.59	79.59	79.57	79.57	1700.0
2009-03-19 06:50:00	SPY	ETF	79.67	79.67	79.67	79.67	100.0
2009-03-19 06:54:00	SPY	ETF	79.75	79.75	79.75	79.75	2500.0
2009-03-19 06:55:00	SPY	ETF	79.76	79.76	79.76	79.76	100.0
2009-03-19 06:56:00	SPY	ETF	79.83	79.83	79.83	79.83	1000.0
2009-03-19 06:58:00	SPY	ETF	79.79	79.79	79.79	79.79	750.0
2009-03-19 07:00:00	SPY	ETF	79.73	79.74	79.7	79.71	2100.0
2009-03-19 07:01:00	SPY	ETF	79.73	79.73	79.73	79.73	600.0
2009-03-19 07:02:00	SPY	ETF	79.73	79.76	79.71	79.76	6976.0
2009-03-19 07:03:00	SPY	ETF	79.77	79.77	79.74	79.74	3200.0
2009-03-19 07:04:00	SPY	ETF	79.73	79.76	79.72	79.75	48100.0
2009-03-19 07:05:00	SPY	ETF	79.75	79.75	79.75	79.75	10300.0
2009-03-19 07:06:00	SPY	ETF	79.73	79.75	79.73	79.75	5100.0
2009-03-19 07:07:00	SPY	ETF	79.74	79.75	79.74	79.75	1737.0
2009-03-19 07:08:00	SPY	ETF	79.77	79.84	79.77	79.84	300.0
2009-03-19 07:09:00	SPY	ETF	79.81	79.81	79.77	79.79	500.0
2009-03-19 07:11:00	SPY	ETF	79.8	79.8	79.8	79.8	250.0

> showing 50 of 99,078 rows — these rows as CSV

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