PREVIEW / etf_5min / 2009-06-23

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-06-23.parquet
  size:    681 KB
  rows:    29,608

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:30:00	SPY	ETF	89.38	89.4	89.38	89.4	200.0
2009-06-23 04:45:00	SPY	ETF	89.57	89.7	89.57	89.7	650.0
2009-06-23 04:50:00	SPY	ETF	89.71	89.74	89.71	89.74	700.0
2009-06-23 05:00:00	SPY	ETF	89.74	89.74	89.72	89.74	300.0
2009-06-23 05:05:00	SPY	ETF	89.75	89.75	89.75	89.75	100.0
2009-06-23 05:10:00	SPY	ETF	89.76	89.76	89.76	89.76	100.0
2009-06-23 05:20:00	SPY	ETF	89.74	89.74	89.74	89.74	225.0
2009-06-23 05:45:00	SPY	ETF	89.62	89.62	89.62	89.62	1000.0
2009-06-23 06:10:00	SPY	ETF	89.7	89.7	89.7	89.7	300.0
2009-06-23 06:20: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.7	89.7	6000.0
2009-06-23 06:30:00	SPY	ETF	89.7	89.7	89.67	89.7	3800.0
2009-06-23 06:35:00	SPY	ETF	89.74	89.79	89.74	89.79	5200.0
2009-06-23 06:40: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.73	89.73	6200.0
2009-06-23 06:50:00	SPY	ETF	89.71	89.73	89.7	89.7	12200.0
2009-06-23 06:55:00	SPY	ETF	89.69	89.7	89.63	89.7	42150.0
2009-06-23 07:00:00	SPY	ETF	89.66	89.68	89.64	89.68	14400.0
2009-06-23 07:05:00	SPY	ETF	89.7	89.71	89.65	89.65	62530.0
2009-06-23 07:10:00	SPY	ETF	89.64	89.64	89.52	89.53	18100.0
2009-06-23 07:15:00	SPY	ETF	89.57	89.64	89.56	89.56	51000.0
2009-06-23 07:20:00	SPY	ETF	89.53	89.68	89.53	89.68	11700.0
2009-06-23 07:25:00	SPY	ETF	89.66	89.66	89.55	89.61	18613.0
2009-06-23 07:30:00	SPY	ETF	89.53	89.6	89.53	89.6	13400.0
2009-06-23 07:35:00	SPY	ETF	89.59	89.7	89.59	89.69	33900.0
2009-06-23 07:40:00	SPY	ETF	89.7	89.71	89.64	89.65	33000.0
2009-06-23 07:45:00	SPY	ETF	89.64	89.65	89.64	89.65	1486.0
2009-06-23 07:50:00	SPY	ETF	89.65	89.68	89.62	89.62	10200.0
2009-06-23 07:55:00	SPY	ETF	89.62	89.63	89.55	89.56	26000.0
2009-06-23 08:00:00	SPY	ETF	89.56	89.7	89.55	89.65	397053.0
2009-06-23 08:05:00	SPY	ETF	89.65	89.72	89.63	89.72	48636.0
2009-06-23 08:10:00	SPY	ETF	89.72	89.78	89.72	89.77	162502.0
2009-06-23 08:15:00	SPY	ETF	89.78	89.85	89.0	89.85	246858.0
2009-06-23 08:20:00	SPY	ETF	89.82	89.85	89.75	89.79	128340.0
2009-06-23 08:25:00	SPY	ETF	89.79	89.83	89.76	89.79	131525.0
2009-06-23 08:30:00	SPY	ETF	89.8	89.81	89.53	89.78	201321.0
2009-06-23 08:35:00	SPY	ETF	89.75	89.76	89.63	89.67	350889.0
2009-06-23 08:40:00	SPY	ETF	89.66	89.72	89.62	89.7	61900.0
2009-06-23 08:45:00	SPY	ETF	89.71	89.79	89.7	89.75	120286.0
2009-06-23 08:50:00	SPY	ETF	89.77	89.81	89.74	89.74	379780.0
2009-06-23 08:55:00	SPY	ETF	89.75	89.76	89.66	89.66	162414.0
2009-06-23 09:00:00	SPY	ETF	89.66	89.71	89.61	89.65	47068.0
2009-06-23 09:05:00	SPY	ETF	89.65	89.65	89.6	89.61	24100.0
2009-06-23 09:10:00	SPY	ETF	89.61	89.62	89.47	89.55	53361.0
2009-06-23 09:15:00	SPY	ETF	89.53	89.53	89.41	89.48	285369.0
2009-06-23 09:20:00	SPY	ETF	89.49	89.55	89.46	89.54	104796.0
2009-06-23 09:25:00	SPY	ETF	89.55	89.58	89.49	89.5	165762.0
2009-06-23 09:30:00	SPY	ETF	89.47	89.58	89.38	89.58	5422304.0
2009-06-23 09:35:00	SPY	ETF	89.57	89.76	89.565	89.6	3950961.0
2009-06-23 09:40:00	SPY	ETF	89.6	89.74	89.35	89.37	5160283.0

> showing 50 of 29,608 rows — these rows as CSV

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