PREVIEW / etf_1min / 2009-06-23

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-06-23.parquet
  size:    1.7 MB
  rows:    91,794

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-06-23 04:33:00	SPY	ETF	89.38	89.38	89.38	89.38	100.0
2009-06-23 04:34:00	SPY	ETF	89.4	89.4	89.4	89.4	100.0
2009-06-23 04:45:00	SPY	ETF	89.57	89.57	89.57	89.57	100.0
2009-06-23 04:46:00	SPY	ETF	89.6	89.62	89.6	89.62	250.0
2009-06-23 04:47:00	SPY	ETF	89.64	89.64	89.64	89.64	200.0
2009-06-23 04:48:00	SPY	ETF	89.7	89.7	89.7	89.7	100.0
2009-06-23 04:51:00	SPY	ETF	89.71	89.72	89.71	89.72	400.0
2009-06-23 04:53:00	SPY	ETF	89.73	89.74	89.73	89.74	300.0
2009-06-23 05:02:00	SPY	ETF	89.74	89.74	89.74	89.74	100.0
2009-06-23 05:04:00	SPY	ETF	89.72	89.74	89.72	89.74	200.0
2009-06-23 05:09:00	SPY	ETF	89.75	89.75	89.75	89.75	100.0
2009-06-23 05:12:00	SPY	ETF	89.76	89.76	89.76	89.76	100.0
2009-06-23 05:23:00	SPY	ETF	89.74	89.74	89.74	89.74	225.0
2009-06-23 05:46:00	SPY	ETF	89.62	89.62	89.62	89.62	1000.0
2009-06-23 06:14:00	SPY	ETF	89.7	89.7	89.7	89.7	300.0
2009-06-23 06:22:00	SPY	ETF	89.75	89.75	89.75	89.75	100.0
2009-06-23 06:25:00	SPY	ETF	89.73	89.73	89.73	89.73	500.0
2009-06-23 06:26:00	SPY	ETF	89.7	89.7	89.7	89.7	4000.0
2009-06-23 06:27:00	SPY	ETF	89.7	89.7	89.7	89.7	1500.0
2009-06-23 06:30:00	SPY	ETF	89.7	89.7	89.67	89.67	800.0
2009-06-23 06:32:00	SPY	ETF	89.7	89.7	89.7	89.7	500.0
2009-06-23 06:33:00	SPY	ETF	89.7	89.7	89.7	89.7	2500.0
2009-06-23 06:35:00	SPY	ETF	89.74	89.74	89.74	89.74	2500.0
2009-06-23 06:37:00	SPY	ETF	89.76	89.77	89.76	89.77	2400.0
2009-06-23 06:38:00	SPY	ETF	89.78	89.78	89.78	89.78	200.0
2009-06-23 06:39:00	SPY	ETF	89.79	89.79	89.79	89.79	100.0
2009-06-23 06:41:00	SPY	ETF	89.8	89.8	89.8	89.8	2679.0
2009-06-23 06:45:00	SPY	ETF	89.77	89.8	89.77	89.8	4500.0
2009-06-23 06:47:00	SPY	ETF	89.75	89.75	89.75	89.75	100.0
2009-06-23 06:48:00	SPY	ETF	89.73	89.75	89.73	89.75	700.0
2009-06-23 06:49:00	SPY	ETF	89.74	89.74	89.73	89.73	900.0
2009-06-23 06:50:00	SPY	ETF	89.71	89.71	89.7	89.7	2000.0
2009-06-23 06:51:00	SPY	ETF	89.73	89.73	89.73	89.73	200.0
2009-06-23 06:52:00	SPY	ETF	89.7	89.7	89.7	89.7	10000.0
2009-06-23 06:55:00	SPY	ETF	89.69	89.69	89.69	89.69	200.0
2009-06-23 06:57:00	SPY	ETF	89.67	89.67	89.65	89.65	29950.0
2009-06-23 06:58:00	SPY	ETF	89.65	89.65	89.63	89.63	10000.0
2009-06-23 06:59:00	SPY	ETF	89.7	89.7	89.7	89.7	2000.0
2009-06-23 07:00:00	SPY	ETF	89.66	89.66	89.64	89.64	4500.0
2009-06-23 07:01:00	SPY	ETF	89.67	89.67	89.65	89.65	600.0
2009-06-23 07:02:00	SPY	ETF	89.66	89.68	89.66	89.68	2600.0
2009-06-23 07:03:00	SPY	ETF	89.67	89.67	89.64	89.66	3800.0
2009-06-23 07:04:00	SPY	ETF	89.68	89.68	89.68	89.68	2900.0
2009-06-23 07:05:00	SPY	ETF	89.7	89.71	89.7	89.71	5000.0
2009-06-23 07:06:00	SPY	ETF	89.68	89.68	89.65	89.65	50000.0
2009-06-23 07:07:00	SPY	ETF	89.66	89.66	89.66	89.66	900.0
2009-06-23 07:08:00	SPY	ETF	89.66	89.66	89.66	89.66	5000.0
2009-06-23 07:09:00	SPY	ETF	89.67	89.67	89.65	89.65	1630.0
2009-06-23 07:10:00	SPY	ETF	89.64	89.64	89.57	89.57	4000.0
2009-06-23 07:12:00	SPY	ETF	89.59	89.59	89.59	89.59	300.0

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

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