PREVIEW / etf_5min / 2007-09-27

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-27.parquet
  size:    324 KB
  rows:    18,067

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-27 04:15:00	SPY	ETF	152.97	152.99	152.97	152.99	700.0
2007-09-27 04:45:00	SPY	ETF	152.85	152.85	152.85	152.85	2000.0
2007-09-27 06:00:00	SPY	ETF	152.85	152.85	152.85	152.85	2000.0
2007-09-27 06:45:00	SPY	ETF	152.85	152.85	152.85	152.85	1500.0
2007-09-27 06:50:00	SPY	ETF	152.79	152.79	152.79	152.79	1000.0
2007-09-27 06:55:00	SPY	ETF	152.82	152.82	152.82	152.82	2000.0
2007-09-27 07:00:00	SPY	ETF	152.84	152.84	152.84	152.84	1000.0
2007-09-27 07:05:00	SPY	ETF	152.75	152.75	152.75	152.75	500.0
2007-09-27 07:10:00	SPY	ETF	152.75	152.75	152.58	152.61	16200.0
2007-09-27 07:15:00	SPY	ETF	152.6	152.62	152.5	152.5	23700.0
2007-09-27 07:20:00	SPY	ETF	152.5	152.55	152.5	152.53	1100.0
2007-09-27 07:25:00	SPY	ETF	152.6	152.6	152.58	152.6	30900.0
2007-09-27 07:30:00	SPY	ETF	152.58	152.62	152.58	152.62	44900.0
2007-09-27 07:35:00	SPY	ETF	152.57	152.62	152.57	152.6	54100.0
2007-09-27 07:40:00	SPY	ETF	152.57	152.7	152.57	152.69	34800.0
2007-09-27 07:45:00	SPY	ETF	152.7	152.73	152.65	152.65	71900.0
2007-09-27 07:50:00	SPY	ETF	152.65	152.75	152.65	152.74	37600.0
2007-09-27 07:55:00	SPY	ETF	152.66	152.66	152.65	152.65	46000.0
2007-09-27 08:00:00	SPY	ETF	152.63	152.63	152.59	152.59	47100.0
2007-09-27 08:05:00	SPY	ETF	152.6	152.73	152.59	152.62	688900.0
2007-09-27 08:10:00	SPY	ETF	152.62	152.66	152.59	152.59	56800.0
2007-09-27 08:15:00	SPY	ETF	152.59	152.6	152.55	152.55	63300.0
2007-09-27 08:20:00	SPY	ETF	152.54	152.56	152.51	152.56	65900.0
2007-09-27 08:25:00	SPY	ETF	152.56	152.67	152.56	152.67	160500.0
2007-09-27 08:30:00	SPY	ETF	152.65	152.84	152.61	152.66	370300.0
2007-09-27 08:35:00	SPY	ETF	152.65	152.7	152.6	152.68	110100.0
2007-09-27 08:40:00	SPY	ETF	152.65	152.72	152.64	152.72	24900.0
2007-09-27 08:45:00	SPY	ETF	152.73	152.79	152.71	152.79	77300.0
2007-09-27 08:50:00	SPY	ETF	152.79	152.88	152.79	152.86	514800.0
2007-09-27 08:55:00	SPY	ETF	152.86	152.88	152.81	152.86	266500.0
2007-09-27 09:00:00	SPY	ETF	152.86	152.96	152.86	152.89	518900.0
2007-09-27 09:05:00	SPY	ETF	152.89	152.91	152.88	152.9	54700.0
2007-09-27 09:10:00	SPY	ETF	152.88	152.92	152.88	152.91	19800.0
2007-09-27 09:15:00	SPY	ETF	152.89	152.95	152.88	152.95	67400.0
2007-09-27 09:20:00	SPY	ETF	152.95	152.95	152.86	152.88	35900.0
2007-09-27 09:25:00	SPY	ETF	152.88	152.98	152.87	152.89	225943.0
2007-09-27 09:30:00	SPY	ETF	152.88	152.9	152.74	152.77	1642524.0
2007-09-27 09:35:00	SPY	ETF	152.77	152.98	152.72	152.87	2117207.0
2007-09-27 09:40:00	SPY	ETF	152.89	152.94	152.73	152.765	1198400.0
2007-09-27 09:45:00	SPY	ETF	152.76	152.81	152.67	152.74	1705800.0
2007-09-27 09:50:00	SPY	ETF	152.74	152.75	152.65	152.75	1409400.0
2007-09-27 09:55:00	SPY	ETF	152.75	152.88	152.59	152.64	2493800.0
2007-09-27 10:00:00	SPY	ETF	152.64	152.85	152.51	152.72	5501600.0
2007-09-27 10:05:00	SPY	ETF	152.72	152.75	152.53	152.63	1914800.0
2007-09-27 10:10:00	SPY	ETF	152.62	152.88	152.43	152.44	2295500.0
2007-09-27 10:15:00	SPY	ETF	152.45	152.64	152.42	152.64	963800.0
2007-09-27 10:20:00	SPY	ETF	152.64	152.73	152.63	152.68	1130200.0
2007-09-27 10:25:00	SPY	ETF	152.68	152.83	152.62	152.63	1377400.0
2007-09-27 10:30:00	SPY	ETF	152.64	152.71	152.56	152.6	1457400.0
2007-09-27 10:35:00	SPY	ETF	152.6	152.88	152.6	152.84	2736400.0

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

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