PREVIEW / etf_5min / 2009-04-27

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-27.parquet
  size:    676 KB
  rows:    28,946

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-04-27 04:15:00	SPY	ETF	85.52	85.62	85.52	85.62	1900.0
2009-04-27 04:35:00	SPY	ETF	85.54	85.54	85.54	85.54	100.0
2009-04-27 04:55:00	SPY	ETF	85.69	85.69	85.69	85.69	100.0
2009-04-27 05:00:00	SPY	ETF	85.74	85.74	85.74	85.74	500.0
2009-04-27 05:05:00	SPY	ETF	85.6	85.6	85.56	85.56	700.0
2009-04-27 05:15:00	SPY	ETF	85.44	85.44	85.44	85.44	3200.0
2009-04-27 05:20:00	SPY	ETF	85.44	85.47	85.36	85.36	930.0
2009-04-27 05:25:00	SPY	ETF	85.39	85.39	85.39	85.39	5000.0
2009-04-27 05:30:00	SPY	ETF	85.37	85.39	85.37	85.39	200.0
2009-04-27 05:35:00	SPY	ETF	85.5	85.5	85.5	85.5	2500.0
2009-04-27 05:40:00	SPY	ETF	85.52	85.52	85.52	85.52	2500.0
2009-04-27 05:45:00	SPY	ETF	85.55	85.55	85.54	85.54	500.0
2009-04-27 05:50:00	SPY	ETF	85.52	85.59	85.52	85.59	2800.0
2009-04-27 05:55:00	SPY	ETF	85.58	85.6	85.54	85.56	3000.0
2009-04-27 06:00:00	SPY	ETF	85.54	85.58	85.5	85.5	2600.0
2009-04-27 06:05:00	SPY	ETF	85.48	85.52	85.42	85.45	10700.0
2009-04-27 06:10:00	SPY	ETF	85.43	85.49	85.43	85.49	1000.0
2009-04-27 06:15:00	SPY	ETF	85.6	85.6	85.6	85.6	1000.0
2009-04-27 06:25:00	SPY	ETF	85.65	85.68	85.65	85.68	2700.0
2009-04-27 06:30:00	SPY	ETF	85.67	85.7	85.67	85.7	400.0
2009-04-27 06:35:00	SPY	ETF	85.72	85.73	85.6	85.63	5700.0
2009-04-27 06:40:00	SPY	ETF	85.58	85.6	85.45	85.45	14200.0
2009-04-27 06:45:00	SPY	ETF	85.48	85.54	85.44	85.49	8400.0
2009-04-27 06:50:00	SPY	ETF	85.45	85.45	85.36	85.36	1050.0
2009-04-27 06:55:00	SPY	ETF	85.37	85.44	85.36	85.44	5899.0
2009-04-27 07:00:00	SPY	ETF	85.44	85.52	85.44	85.49	30250.0
2009-04-27 07:05:00	SPY	ETF	85.5	85.5	85.44	85.47	46070.0
2009-04-27 07:10:00	SPY	ETF	85.49	85.51	85.43	85.47	42922.0
2009-04-27 07:15:00	SPY	ETF	85.45	85.48	85.42	85.47	45637.0
2009-04-27 07:20:00	SPY	ETF	85.47	85.53	85.47	85.52	32100.0
2009-04-27 07:25:00	SPY	ETF	85.52	85.66	85.52	85.64	67807.0
2009-04-27 07:30:00	SPY	ETF	85.65	85.75	85.65	85.72	119976.0
2009-04-27 07:35:00	SPY	ETF	85.7	85.71	85.59	85.62	44007.0
2009-04-27 07:40:00	SPY	ETF	85.6	85.66	85.55	85.64	154400.0
2009-04-27 07:45:00	SPY	ETF	85.66	85.83	85.64	85.8	204542.0
2009-04-27 07:50:00	SPY	ETF	85.8	85.82	85.77	85.77	124121.0
2009-04-27 07:55:00	SPY	ETF	85.78	85.8	85.63	85.64	81896.0
2009-04-27 08:00:00	SPY	ETF	85.62	85.65	85.43	85.44	606256.0
2009-04-27 08:05:00	SPY	ETF	85.45	85.51	85.33	85.4	531324.0
2009-04-27 08:10:00	SPY	ETF	85.4	85.41	85.29	85.4	360508.0
2009-04-27 08:15:00	SPY	ETF	85.4	85.52	85.38	85.51	194743.0
2009-04-27 08:20:00	SPY	ETF	85.51	85.53	85.41	85.51	154673.0
2009-04-27 08:25:00	SPY	ETF	85.49	85.49	85.41	85.44	147575.0
2009-04-27 08:30:00	SPY	ETF	85.43	85.47	85.36	85.46	142883.0
2009-04-27 08:35:00	SPY	ETF	85.45	85.49	85.44	85.49	158294.0
2009-04-27 08:40:00	SPY	ETF	85.49	85.53	85.42	85.43	230962.0
2009-04-27 08:45:00	SPY	ETF	85.42	85.46	85.36	85.46	166491.0
2009-04-27 08:50:00	SPY	ETF	85.46	85.53	85.43	85.52	211300.0
2009-04-27 08:55:00	SPY	ETF	85.51	85.56	85.5	85.55	146591.0
2009-04-27 09:00:00	SPY	ETF	85.54	85.61	85.53	85.54	176971.0

> showing 50 of 28,946 rows — these rows as CSV

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