PREVIEW / etf_5min / 2007-09-18

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-18.parquet
  size:    390 KB
  rows:    18,814

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-18 06:55:00	SPY	ETF	148.34	148.34	148.31	148.31	2100.0
2007-09-18 07:00:00	SPY	ETF	148.3	148.31	148.24	148.26	5000.0
2007-09-18 07:05:00	SPY	ETF	148.26	148.26	148.26	148.26	5000.0
2007-09-18 07:10:00	SPY	ETF	148.28	148.3	148.28	148.3	5000.0
2007-09-18 07:15:00	SPY	ETF	148.31	148.41	148.27	148.41	20400.0
2007-09-18 07:20:00	SPY	ETF	148.3	148.3	148.26	148.26	30000.0
2007-09-18 07:25:00	SPY	ETF	148.28	148.29	148.25	148.26	9400.0
2007-09-18 07:30:00	SPY	ETF	148.29	148.31	148.29	148.31	1200.0
2007-09-18 07:35:00	SPY	ETF	148.24	148.37	148.23	148.37	29200.0
2007-09-18 07:40:00	SPY	ETF	148.34	148.34	148.31	148.34	46000.0
2007-09-18 07:45:00	SPY	ETF	148.3	148.34	148.3	148.3	21000.0
2007-09-18 07:50:00	SPY	ETF	148.24	148.24	148.1	148.1	175100.0
2007-09-18 07:55:00	SPY	ETF	148.1	148.23	148.07	148.18	118300.0
2007-09-18 08:00:00	SPY	ETF	148.2	148.7	148.1	148.5	1222000.0
2007-09-18 08:05:00	SPY	ETF	148.45	148.68	148.45	148.66	1690000.0
2007-09-18 08:10:00	SPY	ETF	148.67	148.9	148.62	148.86	1365000.0
2007-09-18 08:15:00	SPY	ETF	148.85	148.95	148.83	148.87	1415400.0
2007-09-18 08:20:00	SPY	ETF	148.88	148.9	148.84	148.85	307100.0
2007-09-18 08:25:00	SPY	ETF	148.83	148.83	148.75	148.76	373800.0
2007-09-18 08:30:00	SPY	ETF	148.74	149.05	148.59	148.97	1552600.0
2007-09-18 08:35:00	SPY	ETF	148.94	149.04	148.94	148.96	465000.0
2007-09-18 08:40:00	SPY	ETF	148.97	148.98	148.88	148.91	633100.0
2007-09-18 08:45:00	SPY	ETF	148.92	148.95	148.88	148.9	42700.0
2007-09-18 08:50:00	SPY	ETF	148.89	148.92	148.83	148.9	78900.0
2007-09-18 08:55:00	SPY	ETF	148.9	148.95	148.86	148.86	150500.0
2007-09-18 09:00:00	SPY	ETF	148.88	148.88	148.81	148.84	126500.0
2007-09-18 09:05:00	SPY	ETF	148.83	148.94	148.82	148.94	92600.0
2007-09-18 09:10:00	SPY	ETF	148.94	148.96	148.89	148.91	176700.0
2007-09-18 09:15:00	SPY	ETF	148.89	148.89	148.83	148.87	166700.0
2007-09-18 09:20:00	SPY	ETF	148.89	148.95	148.87	148.87	201169.0
2007-09-18 09:25:00	SPY	ETF	148.86	148.9	148.83	148.83	99000.0
2007-09-18 09:30:00	SPY	ETF	148.82	148.95	148.81	148.9	2176877.0
2007-09-18 09:35:00	SPY	ETF	148.9	148.94	148.66	148.73	3278351.0
2007-09-18 09:40:00	SPY	ETF	148.73	148.78	148.65	148.67	1279100.0
2007-09-18 09:45:00	SPY	ETF	148.67	148.75	148.58	148.58	1890200.0
2007-09-18 09:50:00	SPY	ETF	148.58	148.58	148.37	148.52	3795500.0
2007-09-18 09:55:00	SPY	ETF	148.52	148.64	148.46	148.62	2333600.0
2007-09-18 10:00:00	SPY	ETF	148.62	148.69	148.58	148.67	1240900.0
2007-09-18 10:05:00	SPY	ETF	148.68	148.73	148.61	148.71	699400.0
2007-09-18 10:10:00	SPY	ETF	148.71	148.83	148.69	148.77	2119400.0
2007-09-18 10:15:00	SPY	ETF	148.76	148.8	148.68	148.73	1223400.0
2007-09-18 10:20:00	SPY	ETF	148.73	148.86	148.7	148.79	1301800.0
2007-09-18 10:25:00	SPY	ETF	148.79	148.93	148.73	148.91	1662900.0
2007-09-18 10:30:00	SPY	ETF	148.92	149.05	148.88	148.96	3176900.0
2007-09-18 10:35:00	SPY	ETF	148.96	148.99	148.83	148.85	5456500.0
2007-09-18 10:40:00	SPY	ETF	148.841	148.94	148.841	148.88	1038300.0
2007-09-18 10:45:00	SPY	ETF	148.89	148.98	148.86	148.94	1181900.0
2007-09-18 10:50:00	SPY	ETF	148.94	149.07	148.91	149.07	1461200.0
2007-09-18 10:55:00	SPY	ETF	149.07	149.21	149.07	149.18	2036700.0
2007-09-18 11:00:00	SPY	ETF	149.17	149.24	149.0	149.23	2516000.0

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

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