PREVIEW / etf_5min / 2007-03-16
file: by_date/etf_5min/2007/2007-03-16.parquet size: 293 KB rows: 13,343
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-03-16 04:15:00 | SPY | ETF | 138.71 | 138.71 | 138.65 | 138.65 | 700.0 |
| 2007-03-16 06:05:00 | SPY | ETF | 138.81 | 138.81 | 138.81 | 138.81 | 4500.0 |
| 2007-03-16 06:25:00 | SPY | ETF | 138.72 | 138.72 | 138.69 | 138.69 | 2100.0 |
| 2007-03-16 06:35:00 | SPY | ETF | 138.67 | 138.67 | 138.67 | 138.67 | 100.0 |
| 2007-03-16 06:40:00 | SPY | ETF | 138.65 | 138.67 | 138.65 | 138.67 | 10100.0 |
| 2007-03-16 06:45:00 | SPY | ETF | 138.67 | 138.67 | 138.67 | 138.67 | 700.0 |
| 2007-03-16 06:50:00 | SPY | ETF | 138.67 | 138.81 | 138.67 | 138.77 | 14700.0 |
| 2007-03-16 06:55:00 | SPY | ETF | 138.81 | 138.81 | 138.81 | 138.81 | 200.0 |
| 2007-03-16 07:00:00 | SPY | ETF | 138.79 | 138.79 | 138.73 | 138.79 | 9000.0 |
| 2007-03-16 07:05:00 | SPY | ETF | 138.79 | 138.79 | 138.66 | 138.68 | 7000.0 |
| 2007-03-16 07:10:00 | SPY | ETF | 138.65 | 138.71 | 138.65 | 138.65 | 20200.0 |
| 2007-03-16 07:15:00 | SPY | ETF | 138.69 | 138.74 | 138.65 | 138.74 | 13700.0 |
| 2007-03-16 07:20:00 | SPY | ETF | 138.72 | 138.82 | 138.72 | 138.82 | 101100.0 |
| 2007-03-16 07:25:00 | SPY | ETF | 138.8 | 138.82 | 138.8 | 138.8 | 102200.0 |
| 2007-03-16 07:30:00 | SPY | ETF | 138.78 | 138.78 | 138.72 | 138.74 | 15600.0 |
| 2007-03-16 07:35:00 | SPY | ETF | 138.74 | 138.74 | 138.59 | 138.62 | 53700.0 |
| 2007-03-16 07:40:00 | SPY | ETF | 138.59 | 138.63 | 138.58 | 138.6 | 50900.0 |
| 2007-03-16 07:45:00 | SPY | ETF | 138.61 | 138.64 | 138.58 | 138.62 | 40400.0 |
| 2007-03-16 07:50:00 | SPY | ETF | 138.61 | 138.64 | 138.6 | 138.61 | 92000.0 |
| 2007-03-16 07:55:00 | SPY | ETF | 138.64 | 138.64 | 138.64 | 138.64 | 400.0 |
| 2007-03-16 08:00:00 | SPY | ETF | 138.68 | 138.81 | 138.58 | 138.68 | 395200.0 |
| 2007-03-16 08:05:00 | SPY | ETF | 138.65 | 138.65 | 138.35 | 138.61 | 268600.0 |
| 2007-03-16 08:10:00 | SPY | ETF | 138.63 | 138.63 | 138.5 | 138.57 | 260800.0 |
| 2007-03-16 08:15:00 | SPY | ETF | 138.55 | 138.61 | 138.52 | 138.61 | 133600.0 |
| 2007-03-16 08:20:00 | SPY | ETF | 138.6 | 138.6 | 138.48 | 138.52 | 565200.0 |
| 2007-03-16 08:25:00 | SPY | ETF | 138.52 | 138.75 | 138.51 | 138.6 | 213200.0 |
| 2007-03-16 08:30:00 | SPY | ETF | 138.6 | 139.13 | 138.5 | 139.09 | 3057300.0 |
| 2007-03-16 08:35:00 | SPY | ETF | 139.09 | 139.12 | 138.78 | 138.96 | 888200.0 |
| 2007-03-16 08:40:00 | SPY | ETF | 138.95 | 139.0 | 138.6 | 138.7 | 1243700.0 |
| 2007-03-16 08:45:00 | SPY | ETF | 138.71 | 138.96 | 138.7 | 138.88 | 1180400.0 |
| 2007-03-16 08:50:00 | SPY | ETF | 138.88 | 138.92 | 138.83 | 138.85 | 167200.0 |
| 2007-03-16 08:55:00 | SPY | ETF | 138.84 | 138.95 | 138.84 | 138.95 | 345000.0 |
| 2007-03-16 09:00:00 | SPY | ETF | 138.95 | 139.06 | 138.95 | 139.06 | 252600.0 |
| 2007-03-16 09:05:00 | SPY | ETF | 139.05 | 139.06 | 139.0 | 139.0 | 473800.0 |
| 2007-03-16 09:10:00 | SPY | ETF | 139.0 | 139.09 | 139.0 | 139.08 | 189400.0 |
| 2007-03-16 09:15:00 | SPY | ETF | 139.09 | 139.29 | 139.08 | 139.22 | 970400.0 |
| 2007-03-16 09:20:00 | SPY | ETF | 139.22 | 139.37 | 139.22 | 139.3 | 660300.0 |
| 2007-03-16 09:25:00 | SPY | ETF | 139.3 | 139.44 | 139.29 | 139.31 | 347700.0 |
| 2007-03-16 09:30:00 | SPY | ETF | 139.31 | 139.32 | 139.06 | 139.08 | 4648200.0 |
| 2007-03-16 09:35:00 | SPY | ETF | 139.08 | 139.15 | 138.87 | 139.09 | 2646215.0 |
| 2007-03-16 09:40:00 | SPY | ETF | 139.09 | 139.22 | 139.02 | 139.19 | 2103200.0 |
| 2007-03-16 09:45:00 | SPY | ETF | 139.2 | 139.34 | 139.15 | 139.31 | 1303600.0 |
| 2007-03-16 09:50:00 | SPY | ETF | 139.325 | 139.53 | 139.2 | 139.48 | 2621300.0 |
| 2007-03-16 09:55:00 | SPY | ETF | 139.4799 | 139.53 | 139.24 | 139.43 | 2553800.0 |
| 2007-03-16 10:00:00 | SPY | ETF | 139.43 | 139.63 | 139.29 | 139.43 | 2989300.0 |
| 2007-03-16 10:05:00 | SPY | ETF | 139.44 | 139.53 | 139.37 | 139.46 | 1551050.0 |
| 2007-03-16 10:10:00 | SPY | ETF | 139.46 | 139.57 | 139.44 | 139.52 | 1089450.0 |
| 2007-03-16 10:15:00 | SPY | ETF | 139.52 | 139.6 | 139.48 | 139.49 | 1069400.0 |
| 2007-03-16 10:20:00 | SPY | ETF | 139.48 | 139.55 | 139.39 | 139.43 | 1196080.0 |
| 2007-03-16 10:25:00 | SPY | ETF | 139.42 | 139.58 | 139.36 | 139.49 | 864600.0 |
> showing 50 of 13,343 rows — these rows as CSV