PREVIEW / etf_5min / 2007-10-12
file: by_date/etf_5min/2007/2007-10-12.parquet size: 325 KB rows: 17,266
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-10-12 04:15:00 | SPY | ETF | 155.01 | 155.01 | 155.01 | 155.01 | 100.0 |
| 2007-10-12 04:35:00 | SPY | ETF | 155.04 | 155.04 | 155.04 | 155.04 | 3000.0 |
| 2007-10-12 05:10:00 | SPY | ETF | 155.24 | 155.24 | 155.24 | 155.24 | 200.0 |
| 2007-10-12 06:40:00 | SPY | ETF | 155.22 | 155.24 | 155.22 | 155.24 | 118000.0 |
| 2007-10-12 06:45:00 | SPY | ETF | 155.2 | 155.21 | 155.2 | 155.21 | 17000.0 |
| 2007-10-12 06:55:00 | SPY | ETF | 155.27 | 155.27 | 155.27 | 155.27 | 15000.0 |
| 2007-10-12 07:00:00 | SPY | ETF | 155.29 | 155.31 | 155.29 | 155.29 | 28000.0 |
| 2007-10-12 07:05:00 | SPY | ETF | 155.29 | 155.29 | 155.22 | 155.24 | 14400.0 |
| 2007-10-12 07:10:00 | SPY | ETF | 155.22 | 155.24 | 155.12 | 155.12 | 71500.0 |
| 2007-10-12 07:15:00 | SPY | ETF | 155.06 | 155.06 | 154.99 | 155.06 | 136000.0 |
| 2007-10-12 07:20:00 | SPY | ETF | 155.11 | 155.11 | 155.01 | 155.01 | 39000.0 |
| 2007-10-12 07:25:00 | SPY | ETF | 155.09 | 155.09 | 155.07 | 155.09 | 2400.0 |
| 2007-10-12 07:30:00 | SPY | ETF | 155.1 | 155.16 | 155.08 | 155.16 | 16400.0 |
| 2007-10-12 07:35:00 | SPY | ETF | 155.16 | 155.16 | 155.11 | 155.11 | 6300.0 |
| 2007-10-12 07:40:00 | SPY | ETF | 155.13 | 155.13 | 155.12 | 155.12 | 600.0 |
| 2007-10-12 07:45:00 | SPY | ETF | 155.12 | 155.12 | 155.07 | 155.07 | 14400.0 |
| 2007-10-12 07:55:00 | SPY | ETF | 155.07 | 155.1 | 155.05 | 155.1 | 4900.0 |
| 2007-10-12 08:00:00 | SPY | ETF | 155.09 | 155.15 | 155.05 | 155.15 | 17900.0 |
| 2007-10-12 08:05:00 | SPY | ETF | 155.15 | 155.19 | 155.15 | 155.16 | 36600.0 |
| 2007-10-12 08:10:00 | SPY | ETF | 155.19 | 155.19 | 155.18 | 155.19 | 13100.0 |
| 2007-10-12 08:15:00 | SPY | ETF | 155.19 | 155.21 | 155.15 | 155.15 | 19900.0 |
| 2007-10-12 08:20:00 | SPY | ETF | 155.16 | 155.3 | 155.05 | 155.3 | 369200.0 |
| 2007-10-12 08:25:00 | SPY | ETF | 155.3 | 155.34 | 155.2 | 155.34 | 417100.0 |
| 2007-10-12 08:30:00 | SPY | ETF | 155.32 | 155.54 | 155.23 | 155.36 | 1932500.0 |
| 2007-10-12 08:35:00 | SPY | ETF | 155.37 | 155.46 | 155.35 | 155.4 | 118500.0 |
| 2007-10-12 08:40:00 | SPY | ETF | 155.39 | 155.41 | 155.34 | 155.37 | 106600.0 |
| 2007-10-12 08:45:00 | SPY | ETF | 155.37 | 155.53 | 155.37 | 155.51 | 1213000.0 |
| 2007-10-12 08:50:00 | SPY | ETF | 155.51 | 155.59 | 155.5 | 155.59 | 209800.0 |
| 2007-10-12 08:55:00 | SPY | ETF | 155.59 | 155.59 | 155.51 | 155.52 | 371000.0 |
| 2007-10-12 09:00:00 | SPY | ETF | 155.55 | 155.56 | 155.53 | 155.56 | 88100.0 |
| 2007-10-12 09:05:00 | SPY | ETF | 155.55 | 155.58 | 155.51 | 155.58 | 111600.0 |
| 2007-10-12 09:10:00 | SPY | ETF | 155.56 | 155.59 | 155.49 | 155.49 | 152300.0 |
| 2007-10-12 09:15:00 | SPY | ETF | 155.51 | 155.51 | 155.47 | 155.47 | 28600.0 |
| 2007-10-12 09:20:00 | SPY | ETF | 155.47 | 155.48 | 155.46 | 155.47 | 55100.0 |
| 2007-10-12 09:25:00 | SPY | ETF | 155.47 | 155.48 | 155.43 | 155.47 | 81700.0 |
| 2007-10-12 09:30:00 | SPY | ETF | 155.46 | 155.58 | 155.35 | 155.45 | 2036822.0 |
| 2007-10-12 09:35:00 | SPY | ETF | 155.44 | 155.5 | 155.27 | 155.4 | 1663448.0 |
| 2007-10-12 09:40:00 | SPY | ETF | 155.4 | 155.66 | 155.39 | 155.58 | 4161800.0 |
| 2007-10-12 09:45:00 | SPY | ETF | 155.57 | 155.63 | 155.43 | 155.56 | 1836300.0 |
| 2007-10-12 09:50:00 | SPY | ETF | 155.57 | 155.66 | 155.48 | 155.56 | 1307700.0 |
| 2007-10-12 09:55:00 | SPY | ETF | 155.56 | 155.65 | 155.47 | 155.6 | 1721404.0 |
| 2007-10-12 10:00:00 | SPY | ETF | 155.61 | 155.63 | 155.33 | 155.569 | 1967117.0 |
| 2007-10-12 10:05:00 | SPY | ETF | 155.56 | 155.85 | 155.56 | 155.81 | 4761855.0 |
| 2007-10-12 10:10:00 | SPY | ETF | 155.81 | 155.95 | 155.78 | 155.83 | 3397672.0 |
| 2007-10-12 10:15:00 | SPY | ETF | 155.83 | 155.97 | 155.82 | 155.86 | 1172315.0 |
| 2007-10-12 10:20:00 | SPY | ETF | 155.86 | 155.91 | 155.82 | 155.89 | 777689.0 |
| 2007-10-12 10:25:00 | SPY | ETF | 155.89 | 155.94 | 155.79 | 155.89 | 843200.0 |
| 2007-10-12 10:30:00 | SPY | ETF | 155.88 | 155.95 | 155.81 | 155.82 | 823550.0 |
| 2007-10-12 10:35:00 | SPY | ETF | 155.81 | 155.83 | 155.71 | 155.78 | 1567004.0 |
| 2007-10-12 10:40:00 | SPY | ETF | 155.78 | 155.78 | 155.62 | 155.65 | 1571478.0 |
> showing 50 of 17,266 rows — these rows as CSV