PREVIEW / etf_5min / 2009-02-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-02-09.parquet
  size:    647 KB
  rows:    27,927

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-02-09 04:05:00	SPY	ETF	85.8	85.85	85.8	85.8	20000.0
2009-02-09 04:10:00	SPY	ETF	85.8	85.87	85.8	85.87	20000.0
2009-02-09 04:15:00	SPY	ETF	85.99	85.99	85.9	85.96	2052.0
2009-02-09 04:20:00	SPY	ETF	85.98	85.98	85.85	85.85	967.0
2009-02-09 04:25:00	SPY	ETF	86.1	86.1	86.1	86.1	500.0
2009-02-09 05:15:00	SPY	ETF	86.3	86.3	86.3	86.3	800.0
2009-02-09 05:35:00	SPY	ETF	86.15	86.15	86.15	86.15	25000.0
2009-02-09 06:10:00	SPY	ETF	86.3	86.3	86.3	86.3	5000.0
2009-02-09 06:20:00	SPY	ETF	86.5	86.5	86.5	86.5	500.0
2009-02-09 06:30:00	SPY	ETF	86.52	86.52	86.52	86.52	10000.0
2009-02-09 06:35:00	SPY	ETF	86.52	86.52	86.43	86.43	5500.0
2009-02-09 06:45:00	SPY	ETF	86.52	86.52	86.43	86.43	3000.0
2009-02-09 06:50:00	SPY	ETF	86.54	86.54	86.46	86.52	3100.0
2009-02-09 06:55:00	SPY	ETF	86.5	86.52	86.49	86.49	5800.0
2009-02-09 07:00:00	SPY	ETF	86.5	86.63	86.48	86.61	108749.0
2009-02-09 07:05:00	SPY	ETF	86.61	86.64	86.51	86.51	54590.0
2009-02-09 07:10:00	SPY	ETF	86.52	86.54	86.5	86.51	9112.0
2009-02-09 07:15:00	SPY	ETF	86.53	86.56	86.5	86.56	8400.0
2009-02-09 07:20:00	SPY	ETF	86.59	86.59	86.52	86.52	28418.0
2009-02-09 07:25:00	SPY	ETF	86.56	86.56	86.49	86.52	6459.0
2009-02-09 07:30:00	SPY	ETF	86.53	86.58	86.53	86.58	12164.0
2009-02-09 07:35:00	SPY	ETF	86.57	86.57	86.47	86.49	41245.0
2009-02-09 07:40:00	SPY	ETF	86.48	86.48	86.34	86.35	46460.0
2009-02-09 07:45:00	SPY	ETF	86.32	86.34	86.27	86.33	141965.0
2009-02-09 07:50:00	SPY	ETF	86.33	86.33	86.22	86.23	54109.0
2009-02-09 07:55:00	SPY	ETF	86.24	86.35	86.24	86.27	81704.0
2009-02-09 08:00:00	SPY	ETF	86.29	86.63	86.26	86.4	863551.0
2009-02-09 08:05:00	SPY	ETF	86.39	86.44	86.38	86.44	78033.0
2009-02-09 08:10:00	SPY	ETF	86.44	86.47	86.4	86.42	97429.0
2009-02-09 08:15:00	SPY	ETF	86.42	86.61	86.39	86.59	209268.0
2009-02-09 08:20:00	SPY	ETF	86.58	86.71	86.56	86.66	140784.0
2009-02-09 08:25:00	SPY	ETF	86.65	86.65	86.5	86.52	352302.0
2009-02-09 08:30:00	SPY	ETF	86.53	86.63	86.44	86.6	163093.0
2009-02-09 08:35:00	SPY	ETF	86.61	86.62	86.53	86.55	109200.0
2009-02-09 08:40:00	SPY	ETF	86.6	86.69	86.57	86.64	121345.0
2009-02-09 08:45:00	SPY	ETF	86.64	86.68	86.335	86.61	919206.0
2009-02-09 08:50:00	SPY	ETF	86.63	86.71	86.58	86.7	65965.0
2009-02-09 08:55:00	SPY	ETF	86.7	86.74	86.69	86.71	82655.0
2009-02-09 09:00:00	SPY	ETF	86.72	86.79	86.71	86.71	76895.0
2009-02-09 09:05:00	SPY	ETF	86.72	86.79	86.72	86.74	67062.0
2009-02-09 09:10:00	SPY	ETF	86.74	86.86	86.73	86.84	136291.0
2009-02-09 09:15:00	SPY	ETF	86.84	86.89	86.82	86.87	207260.0
2009-02-09 09:20:00	SPY	ETF	86.87	86.94	86.86	86.91	370851.0
2009-02-09 09:25:00	SPY	ETF	86.91	87.03	86.9	86.98	551548.0
2009-02-09 09:30:00	SPY	ETF	86.96	87.09	86.75	86.76	4118066.0
2009-02-09 09:35:00	SPY	ETF	86.76	86.87	86.6	86.77	4571256.0
2009-02-09 09:40:00	SPY	ETF	86.78	86.99	86.7	86.86	4498599.0
2009-02-09 09:45:00	SPY	ETF	86.85	87.09	86.82	87.03	4467779.0
2009-02-09 09:50:00	SPY	ETF	87.04	87.06	86.87	87.02	2658976.0
2009-02-09 09:55:00	SPY	ETF	87.02	87.07	86.81	86.92	3504903.0

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

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