PREVIEW / etf_5min / 2007-11-28
file: by_date/etf_5min/2007/2007-11-28.parquet size: 448 KB rows: 20,999
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-28 05:55:00 | SPY | ETF | 142.62 | 142.62 | 142.62 | 142.62 | 12500.0 |
| 2007-11-28 06:10:00 | SPY | ETF | 142.84 | 142.84 | 142.84 | 142.84 | 100.0 |
| 2007-11-28 06:20:00 | SPY | ETF | 142.76 | 142.76 | 142.75 | 142.75 | 3000.0 |
| 2007-11-28 06:30:00 | SPY | ETF | 142.91 | 142.91 | 142.91 | 142.91 | 5000.0 |
| 2007-11-28 06:35:00 | SPY | ETF | 143.0 | 143.0 | 143.0 | 143.0 | 200.0 |
| 2007-11-28 06:45:00 | SPY | ETF | 143.16 | 143.16 | 143.16 | 143.16 | 100.0 |
| 2007-11-28 06:50:00 | SPY | ETF | 143.11 | 143.14 | 143.08 | 143.08 | 109000.0 |
| 2007-11-28 06:55:00 | SPY | ETF | 143.08 | 143.08 | 143.07 | 143.07 | 1500.0 |
| 2007-11-28 07:00:00 | SPY | ETF | 143.11 | 143.12 | 143.06 | 143.06 | 31000.0 |
| 2007-11-28 07:05:00 | SPY | ETF | 143.19 | 143.19 | 143.17 | 143.17 | 10100.0 |
| 2007-11-28 07:10:00 | SPY | ETF | 143.1 | 143.2 | 143.1 | 143.14 | 100100.0 |
| 2007-11-28 07:15:00 | SPY | ETF | 143.16 | 143.34 | 143.16 | 143.34 | 259900.0 |
| 2007-11-28 07:20:00 | SPY | ETF | 143.38 | 143.5 | 143.38 | 143.5 | 48700.0 |
| 2007-11-28 07:25:00 | SPY | ETF | 143.5 | 143.78 | 143.47 | 143.7 | 201000.0 |
| 2007-11-28 07:30:00 | SPY | ETF | 143.73 | 143.73 | 143.6 | 143.64 | 68700.0 |
| 2007-11-28 07:35:00 | SPY | ETF | 143.65 | 143.7 | 143.53 | 143.6 | 173400.0 |
| 2007-11-28 07:40:00 | SPY | ETF | 143.6 | 143.63 | 143.58 | 143.63 | 257800.0 |
| 2007-11-28 07:45:00 | SPY | ETF | 143.64 | 143.75 | 143.64 | 143.71 | 210000.0 |
| 2007-11-28 07:50:00 | SPY | ETF | 143.75 | 143.75 | 143.68 | 143.7 | 207500.0 |
| 2007-11-28 07:55:00 | SPY | ETF | 143.68 | 143.68 | 143.57 | 143.57 | 94100.0 |
| 2007-11-28 08:00:00 | SPY | ETF | 143.56 | 144.2 | 143.55 | 144.0 | 3646400.0 |
| 2007-11-28 08:05:00 | SPY | ETF | 144.0 | 144.1 | 143.95 | 144.01 | 362500.0 |
| 2007-11-28 08:10:00 | SPY | ETF | 144.0 | 144.08 | 142.75 | 143.95 | 1386100.0 |
| 2007-11-28 08:15:00 | SPY | ETF | 143.95 | 144.02 | 143.75 | 144.01 | 791000.0 |
| 2007-11-28 08:20:00 | SPY | ETF | 144.0 | 144.07 | 142.5 | 143.88 | 296700.0 |
| 2007-11-28 08:25:00 | SPY | ETF | 143.88 | 144.02 | 143.84 | 143.92 | 805000.0 |
| 2007-11-28 08:30:00 | SPY | ETF | 143.94 | 144.22 | 143.56 | 144.06 | 1857300.0 |
| 2007-11-28 08:35:00 | SPY | ETF | 144.06 | 144.15 | 144.05 | 144.1 | 881300.0 |
| 2007-11-28 08:40:00 | SPY | ETF | 144.07 | 144.19 | 143.99 | 144.08 | 284500.0 |
| 2007-11-28 08:45:00 | SPY | ETF | 144.08 | 144.4 | 144.05 | 144.28 | 1158000.0 |
| 2007-11-28 08:50:00 | SPY | ETF | 144.28 | 144.35 | 144.24 | 144.24 | 333200.0 |
| 2007-11-28 08:55:00 | SPY | ETF | 144.27 | 144.33 | 144.19 | 144.28 | 195800.0 |
| 2007-11-28 09:00:00 | SPY | ETF | 144.27 | 144.27 | 144.14 | 144.16 | 114400.0 |
| 2007-11-28 09:05:00 | SPY | ETF | 144.17 | 144.17 | 143.97 | 144.12 | 269600.0 |
| 2007-11-28 09:10:00 | SPY | ETF | 144.1 | 144.15 | 144.03 | 144.14 | 503400.0 |
| 2007-11-28 09:15:00 | SPY | ETF | 144.14 | 144.15 | 144.05 | 144.11 | 96900.0 |
| 2007-11-28 09:20:00 | SPY | ETF | 144.12 | 144.14 | 144.07 | 144.14 | 145000.0 |
| 2007-11-28 09:25:00 | SPY | ETF | 144.14 | 144.24 | 144.12 | 144.19 | 206100.0 |
| 2007-11-28 09:30:00 | SPY | ETF | 144.19 | 144.58 | 144.14 | 144.53 | 6314236.0 |
| 2007-11-28 09:35:00 | SPY | ETF | 144.54 | 144.7 | 144.52 | 144.63 | 5109276.0 |
| 2007-11-28 09:40:00 | SPY | ETF | 144.62 | 144.67 | 144.45 | 144.55 | 3222949.0 |
| 2007-11-28 09:45:00 | SPY | ETF | 144.55 | 145.0 | 144.48 | 144.932 | 3663500.0 |
| 2007-11-28 09:50:00 | SPY | ETF | 144.94 | 145.15 | 144.63 | 145.05 | 6106800.0 |
| 2007-11-28 09:55:00 | SPY | ETF | 145.05 | 145.26 | 145.0 | 145.19 | 3968300.0 |
| 2007-11-28 10:00:00 | SPY | ETF | 145.19 | 145.31 | 144.9 | 145.02 | 6625035.0 |
| 2007-11-28 10:05:00 | SPY | ETF | 145.02 | 145.27 | 144.86 | 144.88 | 4271043.0 |
| 2007-11-28 10:10:00 | SPY | ETF | 144.89 | 145.12 | 144.78 | 144.9101 | 3425153.0 |
| 2007-11-28 10:15:00 | SPY | ETF | 144.92 | 145.18 | 144.85 | 145.11 | 3705500.0 |
| 2007-11-28 10:20:00 | SPY | ETF | 145.11 | 145.41 | 145.08 | 145.31 | 3592800.0 |
| 2007-11-28 10:25:00 | SPY | ETF | 145.31 | 145.49 | 145.26 | 145.49 | 2150336.0 |
> showing 50 of 20,999 rows — these rows as CSV