PREVIEW / etf_5min / 2009-07-10

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-10.parquet
  size:    634 KB
  rows:    27,531

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-07-10 04:15:00	SPY	ETF	88.19	88.19	88.15	88.15	750.0
2009-07-10 04:20:00	SPY	ETF	88.13	88.13	88.13	88.13	250.0
2009-07-10 04:45:00	SPY	ETF	88.2	88.2	88.2	88.2	500.0
2009-07-10 05:10:00	SPY	ETF	87.96	87.96	87.96	87.96	2000.0
2009-07-10 05:40:00	SPY	ETF	87.91	87.91	87.88	87.88	2200.0
2009-07-10 06:05:00	SPY	ETF	87.78	87.78	87.76	87.76	500.0
2009-07-10 06:10:00	SPY	ETF	87.7	87.7	87.7	87.7	2500.0
2009-07-10 06:15:00	SPY	ETF	87.75	87.75	87.72	87.72	3100.0
2009-07-10 06:25:00	SPY	ETF	87.74	87.74	87.74	87.74	400.0
2009-07-10 06:30:00	SPY	ETF	87.84	87.84	87.84	87.84	100.0
2009-07-10 06:40:00	SPY	ETF	87.75	87.75	87.72	87.72	2100.0
2009-07-10 06:45:00	SPY	ETF	87.64	87.67	87.64	87.67	2000.0
2009-07-10 06:50:00	SPY	ETF	87.67	87.72	87.67	87.72	2000.0
2009-07-10 06:55:00	SPY	ETF	87.72	87.73	87.71	87.71	300.0
2009-07-10 07:00:00	SPY	ETF	87.66	87.75	87.66	87.75	50200.0
2009-07-10 07:05:00	SPY	ETF	87.75	87.78	87.75	87.75	174700.0
2009-07-10 07:10:00	SPY	ETF	87.74	87.78	87.74	87.75	11700.0
2009-07-10 07:15:00	SPY	ETF	87.77	87.78	87.7	87.7	21430.0
2009-07-10 07:20:00	SPY	ETF	87.68	87.68	87.6	87.63	12810.0
2009-07-10 07:25:00	SPY	ETF	87.62	87.67	87.62	87.67	10600.0
2009-07-10 07:30:00	SPY	ETF	87.68	87.69	87.68	87.69	3103.0
2009-07-10 07:35:00	SPY	ETF	87.69	87.71	87.67	87.71	32750.0
2009-07-10 07:40:00	SPY	ETF	87.71	87.76	87.71	87.76	33250.0
2009-07-10 07:45:00	SPY	ETF	87.76	87.76	87.64	87.64	62049.0
2009-07-10 07:50:00	SPY	ETF	87.63	87.65	87.56	87.57	27628.0
2009-07-10 07:55:00	SPY	ETF	87.57	87.66	87.56	87.62	23300.0
2009-07-10 08:00:00	SPY	ETF	87.62	87.78	87.57	87.66	1310150.0
2009-07-10 08:05:00	SPY	ETF	87.67	87.68	87.65	87.67	16666.0
2009-07-10 08:10:00	SPY	ETF	87.67	87.67	87.6	87.64	84531.0
2009-07-10 08:15:00	SPY	ETF	87.62	87.63	87.56	87.59	96872.0
2009-07-10 08:20:00	SPY	ETF	87.58	87.65	87.52	87.63	90586.0
2009-07-10 08:25:00	SPY	ETF	87.62	87.65	87.56	87.57	205440.0
2009-07-10 08:30:00	SPY	ETF	87.58	87.68	87.58	87.65	86753.0
2009-07-10 08:35:00	SPY	ETF	87.65	87.68	87.63	87.64	57739.0
2009-07-10 08:40:00	SPY	ETF	87.63	87.76	87.62	87.76	121673.0
2009-07-10 08:45:00	SPY	ETF	87.76	87.79	87.71	87.73	100379.0
2009-07-10 08:50:00	SPY	ETF	87.73	87.8	87.69	87.75	100752.0
2009-07-10 08:55:00	SPY	ETF	87.75	87.77	87.69	87.7	64020.0
2009-07-10 09:00:00	SPY	ETF	87.7	87.7	87.61	87.63	85066.0
2009-07-10 09:05:00	SPY	ETF	87.63	87.68	87.62	87.67	110078.0
2009-07-10 09:10:00	SPY	ETF	87.67	88.2	87.65	87.67	58415.0
2009-07-10 09:15:00	SPY	ETF	87.68	87.72	87.61	87.67	139621.0
2009-07-10 09:20:00	SPY	ETF	87.67	87.74	87.64	87.68	260338.0
2009-07-10 09:25:00	SPY	ETF	87.68	87.75	87.68	87.71	68218.0
2009-07-10 09:30:00	SPY	ETF	87.7	87.95	87.65	87.86	4450776.0
2009-07-10 09:35:00	SPY	ETF	87.86	88.08	87.81	87.99	3438424.0
2009-07-10 09:40:00	SPY	ETF	87.99	88.14	87.99	88.0	2576729.0
2009-07-10 09:45:00	SPY	ETF	88.0	88.26	87.99	88.2517	2839409.0
2009-07-10 09:50:00	SPY	ETF	88.27	88.49	88.25	88.43	6381503.0
2009-07-10 09:55:00	SPY	ETF	88.33	88.46	87.87	88.0	9840801.0

> showing 50 of 27,531 rows — these rows as CSV

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