PREVIEW / etf_5min / 2007-09-25

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-25.parquet
  size:    343 KB
  rows:    18,316

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
2007-09-25 04:05:00	SPY	ETF	151.27	151.27	151.27	151.27	1000.0
2007-09-25 04:15:00	SPY	ETF	151.17	151.17	151.17	151.17	1000.0
2007-09-25 04:50:00	SPY	ETF	151.07	151.07	151.07	151.07	100.0
2007-09-25 05:30:00	SPY	ETF	151.16	151.16	151.16	151.16	3000.0
2007-09-25 05:55:00	SPY	ETF	151.14	151.14	151.04	151.04	10200.0
2007-09-25 06:05:00	SPY	ETF	151.03	151.03	151.03	151.03	400.0
2007-09-25 06:10:00	SPY	ETF	151.02	151.02	151.02	151.02	1000.0
2007-09-25 06:30:00	SPY	ETF	151.02	151.05	151.02	151.05	3000.0
2007-09-25 06:40:00	SPY	ETF	150.97	150.97	150.97	150.97	10000.0
2007-09-25 06:45:00	SPY	ETF	150.98	150.98	150.94	150.94	102000.0
2007-09-25 06:50:00	SPY	ETF	150.94	150.94	150.94	150.94	14900.0
2007-09-25 06:55:00	SPY	ETF	151.01	151.02	151.01	151.02	3000.0
2007-09-25 07:00:00	SPY	ETF	151.02	151.04	151.02	151.04	37700.0
2007-09-25 07:05:00	SPY	ETF	151.07	151.07	151.05	151.05	18400.0
2007-09-25 07:10:00	SPY	ETF	151.05	151.05	150.99	150.99	49000.0
2007-09-25 07:15:00	SPY	ETF	150.97	150.97	150.9	150.97	150100.0
2007-09-25 07:20:00	SPY	ETF	151.02	151.02	150.97	151.01	106000.0
2007-09-25 07:25:00	SPY	ETF	151.0	151.0	150.95	150.95	25200.0
2007-09-25 07:30:00	SPY	ETF	150.95	150.99	150.95	150.96	16200.0
2007-09-25 07:35:00	SPY	ETF	150.98	151.03	150.97	151.03	27100.0
2007-09-25 07:40:00	SPY	ETF	150.97	151.0	150.95	151.0	103500.0
2007-09-25 07:45:00	SPY	ETF	151.02	151.18	151.02	151.18	17200.0
2007-09-25 07:50:00	SPY	ETF	151.18	151.22	151.14	151.2	143700.0
2007-09-25 07:55:00	SPY	ETF	151.2	151.24	151.18	151.18	92500.0
2007-09-25 08:00:00	SPY	ETF	151.2	151.2	151.06	151.06	130300.0
2007-09-25 08:05:00	SPY	ETF	151.09	151.14	151.02	151.04	154500.0
2007-09-25 08:10:00	SPY	ETF	151.03	151.06	151.03	151.05	86400.0
2007-09-25 08:15:00	SPY	ETF	151.07	151.3	151.06	151.14	46700.0
2007-09-25 08:20:00	SPY	ETF	151.14	151.2	151.07	151.07	167600.0
2007-09-25 08:25:00	SPY	ETF	151.08	151.15	151.08	151.14	67200.0
2007-09-25 08:30:00	SPY	ETF	151.13	151.13	151.09	151.09	25600.0
2007-09-25 08:35:00	SPY	ETF	151.08	151.08	151.03	151.03	229300.0
2007-09-25 08:40:00	SPY	ETF	151.02	151.04	150.9	150.9	183300.0
2007-09-25 08:45:00	SPY	ETF	150.9	151.02	150.89	150.97	319700.0
2007-09-25 08:50:00	SPY	ETF	150.98	150.98	150.87	150.87	111700.0
2007-09-25 08:55:00	SPY	ETF	150.89	150.98	150.82	150.86	639700.0
2007-09-25 09:00:00	SPY	ETF	150.85	150.98	150.82	150.91	276500.0
2007-09-25 09:05:00	SPY	ETF	150.93	151.69	150.87	150.9	220200.0
2007-09-25 09:10:00	SPY	ETF	150.9	150.93	150.88	150.9	570200.0
2007-09-25 09:15:00	SPY	ETF	150.9	150.9	150.79	150.82	107515.0
2007-09-25 09:20:00	SPY	ETF	150.81	151.69	150.79	150.84	176500.0
2007-09-25 09:25:00	SPY	ETF	150.84	150.84	150.73	150.83	1395921.0
2007-09-25 09:30:00	SPY	ETF	150.81	150.87	150.66	150.7	2760511.0
2007-09-25 09:35:00	SPY	ETF	150.71	150.79	150.62	150.651	2530919.0
2007-09-25 09:40:00	SPY	ETF	150.65	150.75	150.6	150.62	2778400.0
2007-09-25 09:45:00	SPY	ETF	150.62	150.83	150.58	150.81	2980800.0
2007-09-25 09:50:00	SPY	ETF	150.81	150.91	150.77	150.8001	4973200.0
2007-09-25 09:55:00	SPY	ETF	150.8	150.96	150.61	150.74	2936400.0
2007-09-25 10:00:00	SPY	ETF	150.74	150.82	150.47	150.78	6281700.0
2007-09-25 10:05:00	SPY	ETF	150.77	151.0	150.75	150.97	2592000.0

> showing 50 of 18,316 rows — these rows as CSV

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