PREVIEW / etf_5min / 2007-07-11
file: by_date/etf_5min/2007/2007-07-11.parquet size: 312 KB rows: 17,069
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-07-11 04:10:00 | SPY | ETF | 151.22 | 151.22 | 151.19 | 151.19 | 6200.0 |
| 2007-07-11 04:30:00 | SPY | ETF | 151.22 | 151.22 | 151.22 | 151.22 | 1000.0 |
| 2007-07-11 05:15:00 | SPY | ETF | 151.36 | 151.36 | 151.36 | 151.36 | 2000.0 |
| 2007-07-11 05:20:00 | SPY | ETF | 151.37 | 151.37 | 151.37 | 151.37 | 1000.0 |
| 2007-07-11 05:25:00 | SPY | ETF | 151.36 | 151.36 | 151.36 | 151.36 | 5000.0 |
| 2007-07-11 05:30:00 | SPY | ETF | 151.36 | 151.36 | 151.36 | 151.36 | 5000.0 |
| 2007-07-11 05:40:00 | SPY | ETF | 151.32 | 151.35 | 151.32 | 151.35 | 20000.0 |
| 2007-07-11 06:00:00 | SPY | ETF | 151.43 | 151.43 | 151.43 | 151.43 | 5000.0 |
| 2007-07-11 06:05:00 | SPY | ETF | 151.39 | 151.4 | 151.39 | 151.4 | 14500.0 |
| 2007-07-11 06:25:00 | SPY | ETF | 151.3 | 151.3 | 151.29 | 151.29 | 11000.0 |
| 2007-07-11 06:35:00 | SPY | ETF | 151.28 | 151.28 | 151.28 | 151.28 | 10000.0 |
| 2007-07-11 06:45:00 | SPY | ETF | 151.27 | 151.27 | 151.24 | 151.24 | 26000.0 |
| 2007-07-11 07:00:00 | SPY | ETF | 151.15 | 151.15 | 151.02 | 151.03 | 30800.0 |
| 2007-07-11 07:05:00 | SPY | ETF | 151.03 | 151.05 | 150.88 | 150.97 | 205900.0 |
| 2007-07-11 07:10:00 | SPY | ETF | 150.97 | 151.01 | 150.8 | 150.8 | 276500.0 |
| 2007-07-11 07:15:00 | SPY | ETF | 150.8 | 150.85 | 150.75 | 150.8 | 150000.0 |
| 2007-07-11 07:20:00 | SPY | ETF | 150.8 | 150.83 | 150.69 | 150.78 | 104000.0 |
| 2007-07-11 07:25:00 | SPY | ETF | 150.77 | 150.81 | 150.66 | 150.7 | 244100.0 |
| 2007-07-11 07:30:00 | SPY | ETF | 150.7 | 150.8 | 150.69 | 150.7 | 224900.0 |
| 2007-07-11 07:35:00 | SPY | ETF | 150.67 | 150.67 | 150.4 | 150.45 | 466700.0 |
| 2007-07-11 07:40:00 | SPY | ETF | 150.45 | 150.57 | 150.45 | 150.57 | 242500.0 |
| 2007-07-11 07:45:00 | SPY | ETF | 150.57 | 150.63 | 150.45 | 150.6 | 589500.0 |
| 2007-07-11 07:50:00 | SPY | ETF | 150.55 | 150.73 | 150.55 | 150.73 | 167500.0 |
| 2007-07-11 07:55:00 | SPY | ETF | 150.74 | 150.89 | 150.74 | 150.79 | 323600.0 |
| 2007-07-11 08:00:00 | SPY | ETF | 150.55 | 151.07 | 150.46 | 150.7 | 2533200.0 |
| 2007-07-11 08:05:00 | SPY | ETF | 150.7 | 150.75 | 150.67 | 150.67 | 194800.0 |
| 2007-07-11 08:10:00 | SPY | ETF | 150.67 | 151.34 | 150.65 | 150.82 | 197600.0 |
| 2007-07-11 08:15:00 | SPY | ETF | 150.8 | 150.99 | 150.77 | 150.88 | 1004400.0 |
| 2007-07-11 08:20:00 | SPY | ETF | 150.88 | 150.92 | 150.85 | 150.89 | 986700.0 |
| 2007-07-11 08:25:00 | SPY | ETF | 150.88 | 150.91 | 150.7 | 150.84 | 746800.0 |
| 2007-07-11 08:30:00 | SPY | ETF | 150.84 | 151.08 | 150.83 | 151.08 | 719100.0 |
| 2007-07-11 08:35:00 | SPY | ETF | 151.08 | 151.22 | 151.0 | 151.15 | 1255600.0 |
| 2007-07-11 08:40:00 | SPY | ETF | 151.14 | 151.18 | 151.09 | 151.11 | 223900.0 |
| 2007-07-11 08:45:00 | SPY | ETF | 151.11 | 151.14 | 151.01 | 151.06 | 399400.0 |
| 2007-07-11 08:50:00 | SPY | ETF | 151.05 | 151.05 | 150.83 | 150.92 | 912600.0 |
| 2007-07-11 08:55:00 | SPY | ETF | 150.92 | 151.05 | 150.83 | 151.03 | 1055300.0 |
| 2007-07-11 09:00:00 | SPY | ETF | 150.97 | 150.99 | 150.92 | 150.92 | 112000.0 |
| 2007-07-11 09:05:00 | SPY | ETF | 150.92 | 150.94 | 150.82 | 150.85 | 915000.0 |
| 2007-07-11 09:10:00 | SPY | ETF | 150.86 | 150.86 | 150.79 | 150.83 | 244700.0 |
| 2007-07-11 09:15:00 | SPY | ETF | 150.83 | 150.86 | 150.77 | 150.8 | 428400.0 |
| 2007-07-11 09:20:00 | SPY | ETF | 150.8 | 150.85 | 150.78 | 150.84 | 775500.0 |
| 2007-07-11 09:25:00 | SPY | ETF | 150.83 | 150.84 | 150.73 | 150.73 | 463000.0 |
| 2007-07-11 09:30:00 | SPY | ETF | 150.75 | 151.1 | 150.74 | 151.05 | 4468000.0 |
| 2007-07-11 09:35:00 | SPY | ETF | 151.05 | 151.18 | 151.0 | 151.05 | 3568344.0 |
| 2007-07-11 09:40:00 | SPY | ETF | 151.05 | 151.11 | 150.93 | 150.99 | 2298100.0 |
| 2007-07-11 09:45:00 | SPY | ETF | 150.97 | 151.19 | 150.96 | 151.12 | 3146700.0 |
| 2007-07-11 09:50:00 | SPY | ETF | 151.115 | 151.12 | 150.59 | 150.6 | 5740750.0 |
| 2007-07-11 09:55:00 | SPY | ETF | 150.62 | 150.77 | 150.52 | 150.76 | 5801000.0 |
| 2007-07-11 10:00:00 | SPY | ETF | 150.76 | 151.01 | 150.54 | 151.0 | 6121400.0 |
| 2007-07-11 10:05:00 | SPY | ETF | 150.99 | 151.03 | 150.84 | 150.99 | 2745300.0 |
> showing 50 of 17,069 rows — these rows as CSV