PREVIEW / etf_1min / 2005-10-07
file: by_date/etf_1min/2005/2005-10-07.parquet size: 251 KB rows: 18,493
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-07 06:24:00 | SPY | ETF | 119.5 | 119.5 | 119.5 | 119.5 | 25000.0 |
| 2005-10-07 07:05:00 | SPY | ETF | 119.49 | 119.49 | 119.49 | 119.49 | 1000.0 |
| 2005-10-07 07:20:00 | SPY | ETF | 119.5 | 119.5 | 119.5 | 119.5 | 1000.0 |
| 2005-10-07 07:21:00 | SPY | ETF | 119.53 | 119.53 | 119.53 | 119.53 | 7400.0 |
| 2005-10-07 07:35:00 | SPY | ETF | 119.46 | 119.48 | 119.46 | 119.46 | 500.0 |
| 2005-10-07 07:39:00 | SPY | ETF | 119.47 | 119.47 | 119.47 | 119.47 | 1000.0 |
| 2005-10-07 07:40:00 | SPY | ETF | 119.46 | 119.46 | 119.46 | 119.46 | 100.0 |
| 2005-10-07 07:43:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 10000.0 |
| 2005-10-07 07:47:00 | SPY | ETF | 119.41 | 119.41 | 119.41 | 119.41 | 3000.0 |
| 2005-10-07 07:48:00 | SPY | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 800.0 |
| 2005-10-07 08:00:00 | SPY | ETF | 119.4 | 119.54 | 119.4 | 119.42 | 155800.0 |
| 2005-10-07 08:01:00 | SPY | ETF | 119.44 | 119.53 | 119.4 | 119.43 | 153400.0 |
| 2005-10-07 08:02:00 | SPY | ETF | 119.44 | 119.46 | 119.44 | 119.45 | 10400.0 |
| 2005-10-07 08:03:00 | SPY | ETF | 119.43 | 119.43 | 119.43 | 119.43 | 100.0 |
| 2005-10-07 08:04:00 | SPY | ETF | 119.48 | 119.49 | 119.45 | 119.45 | 1100.0 |
| 2005-10-07 08:06:00 | SPY | ETF | 119.47 | 119.48 | 119.47 | 119.48 | 1000.0 |
| 2005-10-07 08:07:00 | SPY | ETF | 119.45 | 119.48 | 119.45 | 119.48 | 200.0 |
| 2005-10-07 08:08:00 | SPY | ETF | 119.47 | 119.47 | 119.45 | 119.45 | 200.0 |
| 2005-10-07 08:09:00 | SPY | ETF | 119.44 | 119.48 | 119.44 | 119.48 | 47300.0 |
| 2005-10-07 08:10:00 | SPY | ETF | 119.48 | 119.48 | 119.48 | 119.48 | 59800.0 |
| 2005-10-07 08:13:00 | SPY | ETF | 119.47 | 119.47 | 119.47 | 119.47 | 200.0 |
| 2005-10-07 08:14:00 | SPY | ETF | 119.45 | 119.46 | 119.45 | 119.46 | 26500.0 |
| 2005-10-07 08:15:00 | SPY | ETF | 119.46 | 119.46 | 119.46 | 119.46 | 25500.0 |
| 2005-10-07 08:16:00 | SPY | ETF | 119.46 | 119.46 | 119.46 | 119.46 | 1500.0 |
| 2005-10-07 08:17:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 1000.0 |
| 2005-10-07 08:18:00 | SPY | ETF | 119.44 | 119.44 | 119.43 | 119.44 | 25000.0 |
| 2005-10-07 08:19:00 | SPY | ETF | 119.42 | 119.42 | 119.4 | 119.4 | 5100.0 |
| 2005-10-07 08:21:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 1000.0 |
| 2005-10-07 08:22:00 | SPY | ETF | 119.35 | 119.35 | 119.3 | 119.3 | 78800.0 |
| 2005-10-07 08:23:00 | SPY | ETF | 119.31 | 119.36 | 119.31 | 119.34 | 4000.0 |
| 2005-10-07 08:24:00 | SPY | ETF | 119.38 | 119.38 | 119.38 | 119.38 | 500.0 |
| 2005-10-07 08:25:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 500.0 |
| 2005-10-07 08:28:00 | SPY | ETF | 119.39 | 119.39 | 119.35 | 119.37 | 22100.0 |
| 2005-10-07 08:29:00 | SPY | ETF | 119.37 | 119.47 | 119.33 | 119.35 | 53100.0 |
| 2005-10-07 08:30:00 | SPY | ETF | 119.41 | 119.62 | 119.41 | 119.43 | 278900.0 |
| 2005-10-07 08:31:00 | SPY | ETF | 119.41 | 119.41 | 119.25 | 119.25 | 216000.0 |
| 2005-10-07 08:32:00 | SPY | ETF | 119.25 | 119.25 | 119.11 | 119.15 | 188500.0 |
| 2005-10-07 08:33:00 | SPY | ETF | 119.32 | 119.32 | 119.11 | 119.23 | 782900.0 |
| 2005-10-07 08:34:00 | SPY | ETF | 119.24 | 119.31 | 119.2 | 119.3 | 140700.0 |
| 2005-10-07 08:35:00 | SPY | ETF | 119.3 | 119.3 | 119.23 | 119.27 | 64700.0 |
| 2005-10-07 08:36:00 | SPY | ETF | 119.26 | 119.31 | 119.24 | 119.31 | 71800.0 |
| 2005-10-07 08:37:00 | SPY | ETF | 119.3 | 119.3 | 119.14 | 119.19 | 1812800.0 |
| 2005-10-07 08:38:00 | SPY | ETF | 119.27 | 119.28 | 119.1 | 119.1 | 1055500.0 |
| 2005-10-07 08:39:00 | SPY | ETF | 119.27 | 119.28 | 119.25 | 119.26 | 757600.0 |
| 2005-10-07 08:40:00 | SPY | ETF | 119.28 | 119.35 | 119.28 | 119.34 | 63400.0 |
| 2005-10-07 08:41:00 | SPY | ETF | 119.35 | 119.5 | 119.35 | 119.42 | 104100.0 |
| 2005-10-07 08:42:00 | SPY | ETF | 119.42 | 119.48 | 119.42 | 119.48 | 20000.0 |
| 2005-10-07 08:43:00 | SPY | ETF | 119.44 | 119.54 | 119.44 | 119.46 | 283900.0 |
| 2005-10-07 08:44:00 | SPY | ETF | 119.46 | 119.46 | 119.45 | 119.45 | 3000.0 |
| 2005-10-07 08:45:00 | SPY | ETF | 119.51 | 119.54 | 119.51 | 119.52 | 110900.0 |
> showing 50 of 18,493 rows — these rows as CSV