PREVIEW / etf_5min / 2009-02-10
file: by_date/etf_5min/2009/2009-02-10.parquet size: 691 KB rows: 28,924
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-10 04:15:00 | SPY | ETF | 85.87 | 85.87 | 85.85 | 85.85 | 1000.0 |
| 2009-02-10 04:20:00 | SPY | ETF | 85.85 | 85.85 | 85.83 | 85.83 | 600.0 |
| 2009-02-10 04:25:00 | SPY | ETF | 85.85 | 85.93 | 85.85 | 85.93 | 1000.0 |
| 2009-02-10 04:30:00 | SPY | ETF | 85.93 | 85.93 | 85.93 | 85.93 | 700.0 |
| 2009-02-10 04:55:00 | SPY | ETF | 85.8 | 85.8 | 85.8 | 85.8 | 2100.0 |
| 2009-02-10 05:20:00 | SPY | ETF | 85.91 | 85.91 | 85.9 | 85.9 | 600.0 |
| 2009-02-10 05:30:00 | SPY | ETF | 85.96 | 85.96 | 85.94 | 85.94 | 500.0 |
| 2009-02-10 05:40:00 | SPY | ETF | 85.98 | 85.98 | 85.97 | 85.97 | 600.0 |
| 2009-02-10 05:45:00 | SPY | ETF | 86.0 | 86.06 | 85.99 | 85.99 | 5400.0 |
| 2009-02-10 06:00:00 | SPY | ETF | 85.98 | 85.98 | 85.96 | 85.96 | 1000.0 |
| 2009-02-10 06:10:00 | SPY | ETF | 85.99 | 85.99 | 85.96 | 85.96 | 800.0 |
| 2009-02-10 06:15:00 | SPY | ETF | 85.96 | 86.01 | 85.96 | 86.01 | 700.0 |
| 2009-02-10 06:20:00 | SPY | ETF | 85.99 | 85.99 | 85.99 | 85.99 | 500.0 |
| 2009-02-10 06:25:00 | SPY | ETF | 85.99 | 85.99 | 85.99 | 85.99 | 400.0 |
| 2009-02-10 06:30:00 | SPY | ETF | 85.95 | 85.95 | 85.95 | 85.95 | 5000.0 |
| 2009-02-10 06:40:00 | SPY | ETF | 86.07 | 86.19 | 86.07 | 86.19 | 11750.0 |
| 2009-02-10 06:45:00 | SPY | ETF | 86.18 | 86.24 | 86.09 | 86.1 | 2500.0 |
| 2009-02-10 06:50:00 | SPY | ETF | 86.09 | 86.11 | 86.06 | 86.11 | 1450.0 |
| 2009-02-10 06:55:00 | SPY | ETF | 86.1 | 86.17 | 86.1 | 86.15 | 16400.0 |
| 2009-02-10 07:00:00 | SPY | ETF | 86.14 | 86.29 | 86.08 | 86.29 | 58250.0 |
| 2009-02-10 07:05:00 | SPY | ETF | 86.28 | 86.35 | 86.23 | 86.3 | 33000.0 |
| 2009-02-10 07:10:00 | SPY | ETF | 86.3 | 86.58 | 86.26 | 86.52 | 40249.0 |
| 2009-02-10 07:15:00 | SPY | ETF | 86.5 | 86.7 | 86.49 | 86.57 | 54450.0 |
| 2009-02-10 07:20:00 | SPY | ETF | 86.6 | 86.6 | 86.54 | 86.54 | 34662.0 |
| 2009-02-10 07:25:00 | SPY | ETF | 86.54 | 86.54 | 86.36 | 86.46 | 45361.0 |
| 2009-02-10 07:30:00 | SPY | ETF | 86.48 | 86.6 | 86.43 | 86.6 | 51808.0 |
| 2009-02-10 07:35:00 | SPY | ETF | 86.62 | 86.63 | 86.57 | 86.59 | 22423.0 |
| 2009-02-10 07:40:00 | SPY | ETF | 86.55 | 86.78 | 86.55 | 86.7 | 72918.0 |
| 2009-02-10 07:45:00 | SPY | ETF | 86.68 | 86.76 | 86.66 | 86.66 | 65527.0 |
| 2009-02-10 07:50:00 | SPY | ETF | 86.66 | 86.74 | 86.62 | 86.71 | 146515.0 |
| 2009-02-10 07:55:00 | SPY | ETF | 86.71 | 86.77 | 86.7 | 86.72 | 108986.0 |
| 2009-02-10 08:00:00 | SPY | ETF | 86.71 | 86.72 | 85.63 | 86.63 | 401242.0 |
| 2009-02-10 08:05:00 | SPY | ETF | 86.65 | 86.7 | 86.0 | 86.6 | 421507.0 |
| 2009-02-10 08:10:00 | SPY | ETF | 86.61 | 86.63 | 85.95 | 86.56 | 482755.0 |
| 2009-02-10 08:15:00 | SPY | ETF | 86.58 | 86.58 | 86.54 | 86.54 | 71153.0 |
| 2009-02-10 08:20:00 | SPY | ETF | 86.54 | 86.62 | 86.51 | 86.62 | 283968.0 |
| 2009-02-10 08:25:00 | SPY | ETF | 86.62 | 86.63 | 86.58 | 86.58 | 191190.0 |
| 2009-02-10 08:30:00 | SPY | ETF | 86.58 | 86.73 | 86.54 | 86.73 | 308934.0 |
| 2009-02-10 08:35:00 | SPY | ETF | 86.72 | 86.76 | 86.64 | 86.66 | 234617.0 |
| 2009-02-10 08:40:00 | SPY | ETF | 86.68 | 86.7 | 86.42 | 86.45 | 237227.0 |
| 2009-02-10 08:45:00 | SPY | ETF | 86.45 | 86.49 | 86.36 | 86.45 | 214035.0 |
| 2009-02-10 08:50:00 | SPY | ETF | 86.45 | 86.5 | 86.15 | 86.22 | 377234.0 |
| 2009-02-10 08:55:00 | SPY | ETF | 86.23 | 86.26 | 86.05 | 86.11 | 368423.0 |
| 2009-02-10 09:00:00 | SPY | ETF | 86.11 | 86.25 | 86.11 | 86.16 | 196504.0 |
| 2009-02-10 09:05:00 | SPY | ETF | 86.17 | 86.22 | 86.09 | 86.22 | 410187.0 |
| 2009-02-10 09:10:00 | SPY | ETF | 86.22 | 86.23 | 86.05 | 86.13 | 1168765.0 |
| 2009-02-10 09:15:00 | SPY | ETF | 86.13 | 86.25 | 86.05 | 86.22 | 701088.0 |
| 2009-02-10 09:20:00 | SPY | ETF | 86.22 | 86.31 | 86.14 | 86.22 | 689605.0 |
| 2009-02-10 09:25:00 | SPY | ETF | 86.22 | 86.4 | 86.22 | 86.28 | 523371.0 |
| 2009-02-10 09:30:00 | SPY | ETF | 86.27 | 86.49 | 86.17 | 86.35 | 5180396.0 |
> showing 50 of 28,924 rows — these rows as CSV