PREVIEW / etf_5min / 2007-01-24
file: by_date/etf_5min/2007/2007-01-24.parquet size: 290 KB rows: 14,076
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-01-24 06:45:00 | SPY | ETF | 143.02 | 143.03 | 143.02 | 143.03 | 5000.0 |
| 2007-01-24 06:50:00 | SPY | ETF | 143.05 | 143.05 | 143.05 | 143.05 | 1500.0 |
| 2007-01-24 07:00:00 | SPY | ETF | 143.06 | 143.06 | 143.06 | 143.06 | 7500.0 |
| 2007-01-24 07:05:00 | SPY | ETF | 143.08 | 143.08 | 143.08 | 143.08 | 2000.0 |
| 2007-01-24 07:10:00 | SPY | ETF | 143.07 | 143.09 | 143.07 | 143.08 | 9500.0 |
| 2007-01-24 07:20:00 | SPY | ETF | 143.07 | 143.07 | 143.07 | 143.07 | 5000.0 |
| 2007-01-24 07:30:00 | SPY | ETF | 143.03 | 143.03 | 143.03 | 143.03 | 300.0 |
| 2007-01-24 07:35:00 | SPY | ETF | 143.01 | 143.01 | 143.01 | 143.01 | 600.0 |
| 2007-01-24 07:45:00 | SPY | ETF | 143.01 | 143.01 | 143.01 | 143.01 | 200.0 |
| 2007-01-24 07:55:00 | SPY | ETF | 143.0 | 143.0 | 143.0 | 143.0 | 300.0 |
| 2007-01-24 08:00:00 | SPY | ETF | 143.0 | 143.08 | 143.0 | 143.08 | 58200.0 |
| 2007-01-24 08:05:00 | SPY | ETF | 142.94 | 142.98 | 142.94 | 142.98 | 24800.0 |
| 2007-01-24 08:10:00 | SPY | ETF | 142.97 | 142.97 | 142.97 | 142.97 | 100.0 |
| 2007-01-24 08:15:00 | SPY | ETF | 143.0 | 143.0 | 142.98 | 142.98 | 22400.0 |
| 2007-01-24 08:20:00 | SPY | ETF | 142.99 | 143.0 | 142.99 | 143.0 | 1100.0 |
| 2007-01-24 08:25:00 | SPY | ETF | 143.02 | 143.05 | 143.02 | 143.05 | 3300.0 |
| 2007-01-24 08:30:00 | SPY | ETF | 143.05 | 143.08 | 143.02 | 143.08 | 308400.0 |
| 2007-01-24 08:35:00 | SPY | ETF | 143.08 | 143.11 | 143.08 | 143.09 | 34500.0 |
| 2007-01-24 08:40:00 | SPY | ETF | 143.09 | 143.09 | 143.09 | 143.09 | 500.0 |
| 2007-01-24 08:45:00 | SPY | ETF | 143.08 | 143.1 | 143.07 | 143.09 | 60200.0 |
| 2007-01-24 08:50:00 | SPY | ETF | 143.08 | 143.09 | 143.03 | 143.03 | 10100.0 |
| 2007-01-24 08:55:00 | SPY | ETF | 143.02 | 143.04 | 143.02 | 143.02 | 150300.0 |
| 2007-01-24 09:00:00 | SPY | ETF | 143.01 | 143.03 | 142.99 | 143.03 | 69800.0 |
| 2007-01-24 09:05:00 | SPY | ETF | 143.03 | 143.03 | 143.03 | 143.03 | 20100.0 |
| 2007-01-24 09:10:00 | SPY | ETF | 143.04 | 143.06 | 143.04 | 143.06 | 61000.0 |
| 2007-01-24 09:15:00 | SPY | ETF | 143.04 | 143.09 | 143.04 | 143.06 | 136500.0 |
| 2007-01-24 09:20:00 | SPY | ETF | 143.05 | 143.05 | 143.01 | 143.01 | 28600.0 |
| 2007-01-24 09:25:00 | SPY | ETF | 143.0 | 143.01 | 142.94 | 142.97 | 12800.0 |
| 2007-01-24 09:30:00 | SPY | ETF | 142.97 | 143.12 | 142.91 | 143.08 | 1176800.0 |
| 2007-01-24 09:35:00 | SPY | ETF | 143.07 | 143.08 | 142.97 | 143.0 | 954300.0 |
| 2007-01-24 09:40:00 | SPY | ETF | 143.0 | 143.2 | 142.98 | 143.18 | 915700.0 |
| 2007-01-24 09:45:00 | SPY | ETF | 143.18 | 143.19 | 143.07 | 143.11 | 1104200.0 |
| 2007-01-24 09:50:00 | SPY | ETF | 143.11 | 143.14 | 142.97 | 143.06 | 602600.0 |
| 2007-01-24 09:55:00 | SPY | ETF | 143.07 | 143.09 | 142.91 | 143.08 | 643900.0 |
| 2007-01-24 10:00:00 | SPY | ETF | 143.07 | 143.12 | 142.93 | 143.01 | 1559200.0 |
| 2007-01-24 10:05:00 | SPY | ETF | 143.01 | 143.11 | 142.96 | 143.09 | 760900.0 |
| 2007-01-24 10:10:00 | SPY | ETF | 143.1 | 143.16 | 142.98 | 143.06 | 461900.0 |
| 2007-01-24 10:15:00 | SPY | ETF | 143.06 | 143.17 | 143.04 | 143.13 | 554700.0 |
| 2007-01-24 10:20:00 | SPY | ETF | 143.12 | 143.15 | 142.99 | 143.08 | 555300.0 |
| 2007-01-24 10:25:00 | SPY | ETF | 143.08 | 143.09 | 142.99 | 143.06 | 665900.0 |
| 2007-01-24 10:30:00 | SPY | ETF | 143.05 | 143.2 | 143.02 | 143.18 | 743000.0 |
| 2007-01-24 10:35:00 | SPY | ETF | 143.17 | 143.27 | 143.09 | 143.14 | 1483300.0 |
| 2007-01-24 10:40:00 | SPY | ETF | 143.13 | 143.16 | 143.06 | 143.15 | 856200.0 |
| 2007-01-24 10:45:00 | SPY | ETF | 143.15 | 143.23 | 143.14 | 143.16 | 343600.0 |
| 2007-01-24 10:50:00 | SPY | ETF | 143.16 | 143.26 | 143.13 | 143.23 | 684400.0 |
| 2007-01-24 10:55:00 | SPY | ETF | 143.23 | 143.36 | 143.21 | 143.31 | 817800.0 |
| 2007-01-24 11:00:00 | SPY | ETF | 143.3 | 143.49 | 143.28 | 143.44 | 891300.0 |
| 2007-01-24 11:05:00 | SPY | ETF | 143.44 | 143.52 | 143.41 | 143.45 | 1743500.0 |
| 2007-01-24 11:10:00 | SPY | ETF | 143.45 | 143.49 | 143.39 | 143.405 | 2140000.0 |
| 2007-01-24 11:15:00 | SPY | ETF | 143.4 | 143.45 | 143.39 | 143.43 | 431400.0 |
> showing 50 of 14,076 rows — these rows as CSV