PREVIEW / etf_5min / 2005-01-25
file: by_date/etf_5min/2005/2005-01-25.parquet size: 114 KB rows: 6,040
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-25 08:00:00 | SPY | ETF | 116.97 | 117.0 | 116.95 | 116.96 | 25100.0 |
| 2005-01-25 08:05:00 | SPY | ETF | 116.97 | 117.0 | 116.97 | 117.0 | 12400.0 |
| 2005-01-25 08:10:00 | SPY | ETF | 116.98 | 116.98 | 116.97 | 116.97 | 3100.0 |
| 2005-01-25 08:15:00 | SPY | ETF | 116.97 | 116.97 | 116.94 | 116.94 | 2000.0 |
| 2005-01-25 08:20:00 | SPY | ETF | 116.94 | 116.98 | 116.94 | 116.97 | 2700.0 |
| 2005-01-25 08:25:00 | SPY | ETF | 116.99 | 116.99 | 116.99 | 116.99 | 100.0 |
| 2005-01-25 08:30:00 | SPY | ETF | 117.0 | 117.01 | 117.0 | 117.01 | 12800.0 |
| 2005-01-25 08:35:00 | SPY | ETF | 116.97 | 116.97 | 116.97 | 116.97 | 100.0 |
| 2005-01-25 08:40:00 | SPY | ETF | 116.96 | 116.98 | 116.96 | 116.98 | 1400.0 |
| 2005-01-25 08:45:00 | SPY | ETF | 116.98 | 116.99 | 116.98 | 116.99 | 1000.0 |
| 2005-01-25 08:50:00 | SPY | ETF | 116.99 | 116.99 | 116.99 | 116.99 | 500.0 |
| 2005-01-25 08:55:00 | SPY | ETF | 116.98 | 116.98 | 116.98 | 116.98 | 2100.0 |
| 2005-01-25 09:00:00 | SPY | ETF | 116.95 | 116.98 | 116.95 | 116.96 | 11200.0 |
| 2005-01-25 09:05:00 | SPY | ETF | 116.96 | 116.98 | 116.96 | 116.98 | 15400.0 |
| 2005-01-25 09:10:00 | SPY | ETF | 116.98 | 116.98 | 116.93 | 116.96 | 24400.0 |
| 2005-01-25 09:15:00 | SPY | ETF | 116.96 | 116.96 | 116.95 | 116.95 | 2800.0 |
| 2005-01-25 09:20:00 | SPY | ETF | 116.96 | 116.96 | 116.93 | 116.95 | 2800.0 |
| 2005-01-25 09:25:00 | SPY | ETF | 116.92 | 116.93 | 116.9 | 116.9 | 4200.0 |
| 2005-01-25 09:30:00 | SPY | ETF | 116.91 | 117.04 | 116.84 | 117.03 | 2076300.0 |
| 2005-01-25 09:35:00 | SPY | ETF | 117.03 | 117.24 | 116.95 | 117.21 | 2036900.0 |
| 2005-01-25 09:40:00 | SPY | ETF | 117.22 | 117.37 | 117.17 | 117.32 | 8397300.0 |
| 2005-01-25 09:45:00 | SPY | ETF | 117.32 | 117.39 | 117.22 | 117.34 | 3043000.0 |
| 2005-01-25 09:50:00 | SPY | ETF | 117.34 | 117.38 | 117.24 | 117.31 | 1512600.0 |
| 2005-01-25 09:55:00 | SPY | ETF | 117.29 | 117.36 | 117.21 | 117.21 | 1299300.0 |
| 2005-01-25 10:00:00 | SPY | ETF | 117.23 | 117.4 | 117.19 | 117.25 | 2914800.0 |
| 2005-01-25 10:05:00 | SPY | ETF | 117.25 | 117.37 | 117.16 | 117.22 | 960000.0 |
| 2005-01-25 10:10:00 | SPY | ETF | 117.22 | 117.24 | 117.17 | 117.19 | 669300.0 |
| 2005-01-25 10:15:00 | SPY | ETF | 117.2 | 117.33 | 117.15 | 117.29 | 818600.0 |
| 2005-01-25 10:20:00 | SPY | ETF | 117.27 | 117.29 | 117.14 | 117.26 | 957600.0 |
| 2005-01-25 10:25:00 | SPY | ETF | 117.26 | 117.37 | 117.25 | 117.34 | 993800.0 |
| 2005-01-25 10:30:00 | SPY | ETF | 117.35 | 117.47 | 117.32 | 117.39 | 1203400.0 |
| 2005-01-25 10:35:00 | SPY | ETF | 117.41 | 117.41 | 117.29 | 117.37 | 1324600.0 |
| 2005-01-25 10:40:00 | SPY | ETF | 117.38 | 117.4 | 117.3 | 117.32 | 427000.0 |
| 2005-01-25 10:45:00 | SPY | ETF | 117.33 | 117.35 | 117.24 | 117.24 | 317000.0 |
| 2005-01-25 10:50:00 | SPY | ETF | 117.24 | 117.3 | 117.19 | 117.28 | 498500.0 |
| 2005-01-25 10:55:00 | SPY | ETF | 117.29 | 117.29 | 117.2 | 117.28 | 555700.0 |
| 2005-01-25 11:00:00 | SPY | ETF | 117.27 | 117.29 | 117.21 | 117.25 | 541600.0 |
| 2005-01-25 11:05:00 | SPY | ETF | 117.26 | 117.37 | 117.24 | 117.32 | 629500.0 |
| 2005-01-25 11:10:00 | SPY | ETF | 117.32 | 117.33 | 117.26 | 117.2701 | 318600.0 |
| 2005-01-25 11:15:00 | SPY | ETF | 117.27 | 117.45 | 117.24 | 117.3 | 539400.0 |
| 2005-01-25 11:20:00 | SPY | ETF | 117.3 | 117.3 | 117.22 | 117.26 | 246200.0 |
| 2005-01-25 11:25:00 | SPY | ETF | 117.25 | 117.38 | 117.23 | 117.37 | 718500.0 |
| 2005-01-25 11:30:00 | SPY | ETF | 117.37 | 117.38 | 117.28 | 117.3 | 192200.0 |
| 2005-01-25 11:35:00 | SPY | ETF | 117.31 | 117.33 | 117.19 | 117.22 | 290200.0 |
| 2005-01-25 11:40:00 | SPY | ETF | 117.21 | 117.23 | 117.14 | 117.16 | 426500.0 |
| 2005-01-25 11:45:00 | SPY | ETF | 117.16 | 117.19 | 117.13 | 117.17 | 553300.0 |
| 2005-01-25 11:50:00 | SPY | ETF | 117.17 | 117.22 | 117.11 | 117.2 | 743000.0 |
| 2005-01-25 11:55:00 | SPY | ETF | 117.2 | 117.25 | 117.15 | 117.2 | 327700.0 |
| 2005-01-25 12:00:00 | SPY | ETF | 117.21 | 117.22 | 117.11 | 117.12 | 298400.0 |
| 2005-01-25 12:05:00 | SPY | ETF | 117.11 | 117.22 | 117.07 | 117.21 | 1036100.0 |
> showing 50 of 6,040 rows — these rows as CSV