PREVIEW / etf_5min / 2009-07-27

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-27.parquet
  size:    698 KB
  rows:    30,101

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-27 04:35:00	SPY	ETF	98.3	98.3	98.3	98.3	150.0
2009-07-27 05:15:00	SPY	ETF	98.25	98.25	98.25	98.25	12600.0
2009-07-27 05:25:00	SPY	ETF	98.25	98.25	98.25	98.25	12400.0
2009-07-27 05:50:00	SPY	ETF	98.4	98.4	98.4	98.4	600.0
2009-07-27 05:55:00	SPY	ETF	98.5	98.5	98.5	98.5	120.0
2009-07-27 06:25:00	SPY	ETF	98.5	98.5	98.5	98.5	6000.0
2009-07-27 06:30:00	SPY	ETF	98.48	98.48	98.48	98.48	100.0
2009-07-27 06:35:00	SPY	ETF	98.5	98.5	98.5	98.5	5000.0
2009-07-27 06:40:00	SPY	ETF	98.54	98.54	98.54	98.54	250.0
2009-07-27 06:55:00	SPY	ETF	98.64	98.64	98.64	98.64	5000.0
2009-07-27 07:00:00	SPY	ETF	98.6	98.6	98.55	98.59	26760.0
2009-07-27 07:05:00	SPY	ETF	98.56	98.56	98.48	98.48	51200.0
2009-07-27 07:10:00	SPY	ETF	98.47	98.47	98.38	98.38	1764.0
2009-07-27 07:15:00	SPY	ETF	98.39	98.39	98.33	98.38	4350.0
2009-07-27 07:20:00	SPY	ETF	98.39	98.44	98.37	98.37	4100.0
2009-07-27 07:25:00	SPY	ETF	98.38	98.39	98.28	98.28	3920.0
2009-07-27 07:30:00	SPY	ETF	98.29	98.29	98.16	98.21	16800.0
2009-07-27 07:35:00	SPY	ETF	98.21	98.29	98.21	98.29	69290.0
2009-07-27 07:40:00	SPY	ETF	98.21	98.23	98.18	98.21	40000.0
2009-07-27 07:45:00	SPY	ETF	98.24	98.24	98.2	98.24	23322.0
2009-07-27 07:50:00	SPY	ETF	98.25	98.27	98.23	98.26	191023.0
2009-07-27 07:55:00	SPY	ETF	98.25	98.29	98.25	98.28	227823.0
2009-07-27 08:00:00	SPY	ETF	98.28	98.28	98.2	98.22	43399.0
2009-07-27 08:05:00	SPY	ETF	98.22	98.24	98.07	98.11	79527.0
2009-07-27 08:10:00	SPY	ETF	98.11	98.12	97.89	98.11	32873.0
2009-07-27 08:15:00	SPY	ETF	98.11	98.65	98.1	98.11	76646.0
2009-07-27 08:20:00	SPY	ETF	98.1	98.22	98.05	98.11	78670.0
2009-07-27 08:25:00	SPY	ETF	98.09	98.09	97.97	98.06	549616.0
2009-07-27 08:30:00	SPY	ETF	98.06	98.1	97.98	98.01	121397.0
2009-07-27 08:35:00	SPY	ETF	98.02	98.05	97.95	98.04	146741.0
2009-07-27 08:40:00	SPY	ETF	98.04	98.23	98.03	98.22	277998.0
2009-07-27 08:45:00	SPY	ETF	98.23	98.23	98.12	98.12	86033.0
2009-07-27 08:50:00	SPY	ETF	98.13	98.17	98.13	98.13	29309.0
2009-07-27 08:55:00	SPY	ETF	98.14	98.22	98.14	98.18	85194.0
2009-07-27 09:00:00	SPY	ETF	98.2	98.2	98.09	98.14	183061.0
2009-07-27 09:05:00	SPY	ETF	98.13	98.15	98.08	98.13	85970.0
2009-07-27 09:10:00	SPY	ETF	98.12	98.16	98.12	98.14	42073.0
2009-07-27 09:15:00	SPY	ETF	98.15	98.3	98.03	98.03	96786.0
2009-07-27 09:20:00	SPY	ETF	98.02	98.06	97.95	97.96	326866.0
2009-07-27 09:25:00	SPY	ETF	97.96	97.96	97.83	97.88	1016709.0
2009-07-27 09:30:00	SPY	ETF	97.88	98.07	97.83	98.01	5740500.0
2009-07-27 09:35:00	SPY	ETF	98.01	98.04	97.72	97.85	2376018.0
2009-07-27 09:40:00	SPY	ETF	97.85	98.04	97.79	97.96	4285896.0
2009-07-27 09:45:00	SPY	ETF	97.97	98.09	97.89	97.94	4996980.0
2009-07-27 09:50:00	SPY	ETF	97.93	98.02	97.88	97.95	1759659.0
2009-07-27 09:55:00	SPY	ETF	97.95	97.96	97.79	97.91	1729486.0
2009-07-27 10:00:00	SPY	ETF	97.91	98.4	97.89	98.21	10454508.0
2009-07-27 10:05:00	SPY	ETF	98.2017	98.27	98.07	98.09	2571752.0
2009-07-27 10:10:00	SPY	ETF	98.09	98.13	97.63	97.64	5253399.0
2009-07-27 10:15:00	SPY	ETF	97.6499	97.79	97.64	97.67	1850443.0

> showing 50 of 30,101 rows — these rows as CSV

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