PREVIEW / etf_5min / 2007-11-26
file: by_date/etf_5min/2007/2007-11-26.parquet size: 438 KB rows: 20,511
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-11-26 04:10:00 | SPY | ETF | 145.2 | 145.2 | 145.2 | 145.2 | 700.0 |
| 2007-11-26 04:15:00 | SPY | ETF | 145.19 | 145.19 | 145.19 | 145.19 | 800.0 |
| 2007-11-26 04:25:00 | SPY | ETF | 145.13 | 145.13 | 145.13 | 145.13 | 100.0 |
| 2007-11-26 05:10:00 | SPY | ETF | 144.84 | 144.84 | 144.84 | 144.84 | 500.0 |
| 2007-11-26 05:15:00 | SPY | ETF | 145.0 | 145.0 | 145.0 | 145.0 | 300.0 |
| 2007-11-26 05:30:00 | SPY | ETF | 145.1 | 145.1 | 145.1 | 145.1 | 500.0 |
| 2007-11-26 05:40:00 | SPY | ETF | 145.11 | 145.11 | 145.11 | 145.11 | 2000.0 |
| 2007-11-26 06:00:00 | SPY | ETF | 145.05 | 145.05 | 145.05 | 145.05 | 11300.0 |
| 2007-11-26 06:05:00 | SPY | ETF | 145.06 | 145.06 | 145.06 | 145.06 | 500.0 |
| 2007-11-26 06:15:00 | SPY | ETF | 145.02 | 145.02 | 145.02 | 145.02 | 10000.0 |
| 2007-11-26 06:25:00 | SPY | ETF | 144.85 | 144.85 | 144.85 | 144.85 | 200.0 |
| 2007-11-26 06:30:00 | SPY | ETF | 144.88 | 144.91 | 144.88 | 144.91 | 25800.0 |
| 2007-11-26 06:35:00 | SPY | ETF | 144.87 | 144.87 | 144.87 | 144.87 | 300.0 |
| 2007-11-26 06:40:00 | SPY | ETF | 144.79 | 144.79 | 144.79 | 144.79 | 200.0 |
| 2007-11-26 06:55:00 | SPY | ETF | 144.9 | 144.9 | 144.9 | 144.9 | 5000.0 |
| 2007-11-26 07:00:00 | SPY | ETF | 144.95 | 144.95 | 144.87 | 144.9 | 11700.0 |
| 2007-11-26 07:05:00 | SPY | ETF | 144.81 | 144.85 | 144.74 | 144.75 | 67200.0 |
| 2007-11-26 07:10:00 | SPY | ETF | 144.77 | 144.79 | 144.65 | 144.7 | 112100.0 |
| 2007-11-26 07:15:00 | SPY | ETF | 144.7 | 144.7 | 144.65 | 144.65 | 44800.0 |
| 2007-11-26 07:20:00 | SPY | ETF | 144.66 | 144.7 | 144.65 | 144.67 | 6200.0 |
| 2007-11-26 07:25:00 | SPY | ETF | 144.69 | 144.72 | 144.69 | 144.72 | 33700.0 |
| 2007-11-26 07:30:00 | SPY | ETF | 144.72 | 144.72 | 144.62 | 144.64 | 143600.0 |
| 2007-11-26 07:35:00 | SPY | ETF | 144.66 | 144.66 | 144.55 | 144.57 | 151700.0 |
| 2007-11-26 07:40:00 | SPY | ETF | 144.57 | 144.57 | 144.49 | 144.52 | 214400.0 |
| 2007-11-26 07:45:00 | SPY | ETF | 144.54 | 144.57 | 144.5 | 144.57 | 60700.0 |
| 2007-11-26 07:50:00 | SPY | ETF | 144.55 | 144.56 | 144.5 | 144.55 | 63900.0 |
| 2007-11-26 07:55:00 | SPY | ETF | 144.54 | 144.54 | 144.45 | 144.48 | 117100.0 |
| 2007-11-26 08:00:00 | SPY | ETF | 144.49 | 145.15 | 144.4 | 144.6 | 441600.0 |
| 2007-11-26 08:05:00 | SPY | ETF | 144.6 | 144.63 | 144.54 | 144.6 | 453100.0 |
| 2007-11-26 08:10:00 | SPY | ETF | 144.6 | 144.79 | 144.6 | 144.79 | 133800.0 |
| 2007-11-26 08:15:00 | SPY | ETF | 144.78 | 144.78 | 144.63 | 144.64 | 176700.0 |
| 2007-11-26 08:20:00 | SPY | ETF | 144.65 | 144.67 | 144.6 | 144.61 | 71200.0 |
| 2007-11-26 08:25:00 | SPY | ETF | 144.6 | 144.6 | 144.53 | 144.55 | 81600.0 |
| 2007-11-26 08:30:00 | SPY | ETF | 144.57 | 144.62 | 144.54 | 144.58 | 81500.0 |
| 2007-11-26 08:35:00 | SPY | ETF | 144.58 | 144.59 | 144.28 | 144.28 | 382100.0 |
| 2007-11-26 08:40:00 | SPY | ETF | 144.28 | 144.33 | 144.09 | 144.12 | 378600.0 |
| 2007-11-26 08:45:00 | SPY | ETF | 144.14 | 144.21 | 144.03 | 144.21 | 507700.0 |
| 2007-11-26 08:50:00 | SPY | ETF | 144.2 | 144.28 | 144.2 | 144.24 | 151500.0 |
| 2007-11-26 08:55:00 | SPY | ETF | 144.23 | 144.34 | 144.23 | 144.32 | 99100.0 |
| 2007-11-26 09:00:00 | SPY | ETF | 144.32 | 144.35 | 144.25 | 144.26 | 60200.0 |
| 2007-11-26 09:05:00 | SPY | ETF | 144.26 | 144.26 | 144.18 | 144.21 | 77900.0 |
| 2007-11-26 09:10:00 | SPY | ETF | 144.23 | 144.25 | 144.15 | 144.23 | 86200.0 |
| 2007-11-26 09:15:00 | SPY | ETF | 144.24 | 144.43 | 144.24 | 144.42 | 258900.0 |
| 2007-11-26 09:20:00 | SPY | ETF | 144.43 | 144.43 | 144.31 | 144.31 | 184300.0 |
| 2007-11-26 09:25:00 | SPY | ETF | 144.31 | 144.39 | 144.31 | 144.37 | 582502.0 |
| 2007-11-26 09:30:00 | SPY | ETF | 144.39 | 144.4 | 143.96 | 143.96 | 4188083.0 |
| 2007-11-26 09:35:00 | SPY | ETF | 143.96 | 144.4 | 143.91 | 144.37 | 5602875.0 |
| 2007-11-26 09:40:00 | SPY | ETF | 144.37 | 144.58 | 144.29 | 144.55 | 2619647.0 |
| 2007-11-26 09:45:00 | SPY | ETF | 144.55 | 144.68 | 144.0 | 144.53 | 6754500.0 |
| 2007-11-26 09:50:00 | SPY | ETF | 144.54 | 144.6 | 144.38 | 144.44 | 1839447.0 |
> showing 50 of 20,511 rows — these rows as CSV