PREVIEW / etf_5min / 2005-07-21
file: by_date/etf_5min/2005/2005-07-21.parquet size: 133 KB rows: 6,976
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-07-21 07:05:00 | SPY | ETF | 123.5 | 123.72 | 123.5 | 123.72 | 67000.0 |
| 2005-07-21 07:10:00 | SPY | ETF | 123.75 | 124.33 | 123.75 | 123.83 | 95200.0 |
| 2005-07-21 07:15:00 | SPY | ETF | 123.87 | 124.03 | 123.87 | 123.93 | 9200.0 |
| 2005-07-21 07:20:00 | SPY | ETF | 123.92 | 123.92 | 123.82 | 123.87 | 12700.0 |
| 2005-07-21 07:25:00 | SPY | ETF | 124.04 | 124.06 | 123.97 | 123.97 | 122900.0 |
| 2005-07-21 07:30:00 | SPY | ETF | 123.92 | 124.02 | 123.89 | 123.96 | 176600.0 |
| 2005-07-21 07:35:00 | SPY | ETF | 123.96 | 123.97 | 123.95 | 123.96 | 7800.0 |
| 2005-07-21 07:40:00 | SPY | ETF | 123.86 | 123.89 | 123.69 | 123.69 | 85800.0 |
| 2005-07-21 07:45:00 | SPY | ETF | 123.62 | 123.64 | 123.42 | 123.53 | 187100.0 |
| 2005-07-21 07:50:00 | SPY | ETF | 123.59 | 123.65 | 123.59 | 123.63 | 81700.0 |
| 2005-07-21 07:55:00 | SPY | ETF | 123.61 | 123.69 | 123.61 | 123.69 | 50700.0 |
| 2005-07-21 08:00:00 | SPY | ETF | 123.98 | 123.98 | 123.36 | 123.68 | 446900.0 |
| 2005-07-21 08:05:00 | SPY | ETF | 123.65 | 123.8 | 123.65 | 123.75 | 160300.0 |
| 2005-07-21 08:10:00 | SPY | ETF | 123.78 | 123.79 | 123.48 | 123.48 | 500600.0 |
| 2005-07-21 08:15:00 | SPY | ETF | 123.47 | 123.5 | 123.16 | 123.2 | 524900.0 |
| 2005-07-21 08:20:00 | SPY | ETF | 123.17 | 123.45 | 123.15 | 123.45 | 1047400.0 |
| 2005-07-21 08:25:00 | SPY | ETF | 123.45 | 123.47 | 123.24 | 123.38 | 1577500.0 |
| 2005-07-21 08:30:00 | SPY | ETF | 123.41 | 123.6 | 123.28 | 123.28 | 1286000.0 |
| 2005-07-21 08:35:00 | SPY | ETF | 123.26 | 123.55 | 123.12 | 123.32 | 454300.0 |
| 2005-07-21 08:40:00 | SPY | ETF | 123.22 | 123.42 | 123.2 | 123.42 | 486200.0 |
| 2005-07-21 08:45:00 | SPY | ETF | 123.43 | 123.77 | 123.43 | 123.53 | 656100.0 |
| 2005-07-21 08:50:00 | SPY | ETF | 123.53 | 123.75 | 123.5 | 123.72 | 259900.0 |
| 2005-07-21 08:55:00 | SPY | ETF | 123.7 | 123.85 | 123.59 | 123.61 | 183200.0 |
| 2005-07-21 09:00:00 | SPY | ETF | 123.64 | 123.77 | 123.63 | 123.68 | 273100.0 |
| 2005-07-21 09:05:00 | SPY | ETF | 123.65 | 123.65 | 123.62 | 123.65 | 60300.0 |
| 2005-07-21 09:10:00 | SPY | ETF | 123.63 | 123.63 | 123.58 | 123.63 | 195300.0 |
| 2005-07-21 09:15:00 | SPY | ETF | 123.6 | 123.63 | 123.49 | 123.51 | 78900.0 |
| 2005-07-21 09:20:00 | SPY | ETF | 123.53 | 123.56 | 123.52 | 123.53 | 24500.0 |
| 2005-07-21 09:25:00 | SPY | ETF | 123.57 | 123.58 | 123.55 | 123.58 | 59300.0 |
| 2005-07-21 09:30:00 | SPY | ETF | 123.55 | 123.6 | 123.2 | 123.28 | 1831600.0 |
| 2005-07-21 09:35:00 | SPY | ETF | 123.28 | 123.4 | 123.2 | 123.39 | 1596300.0 |
| 2005-07-21 09:40:00 | SPY | ETF | 123.39 | 123.41 | 123.21 | 123.32 | 1102100.0 |
| 2005-07-21 09:45:00 | SPY | ETF | 123.32 | 123.43 | 123.24 | 123.29 | 1582400.0 |
| 2005-07-21 09:50:00 | SPY | ETF | 123.28 | 123.39 | 123.22 | 123.38 | 923800.0 |
| 2005-07-21 09:55:00 | SPY | ETF | 123.39 | 123.43 | 123.29 | 123.31 | 846700.0 |
| 2005-07-21 10:00:00 | SPY | ETF | 123.29 | 123.41 | 123.0 | 123.26 | 2169000.0 |
| 2005-07-21 10:05:00 | SPY | ETF | 123.26 | 123.36 | 123.22 | 123.26 | 805300.0 |
| 2005-07-21 10:10:00 | SPY | ETF | 123.27 | 123.28 | 123.14 | 123.16 | 1229900.0 |
| 2005-07-21 10:15:00 | SPY | ETF | 123.16 | 123.16 | 122.9 | 122.96 | 2085200.0 |
| 2005-07-21 10:20:00 | SPY | ETF | 122.96 | 122.99 | 122.77 | 122.882 | 2439100.0 |
| 2005-07-21 10:25:00 | SPY | ETF | 122.89 | 122.99 | 122.82 | 122.93 | 1082000.0 |
| 2005-07-21 10:30:00 | SPY | ETF | 122.94 | 122.96 | 122.85 | 122.92 | 659300.0 |
| 2005-07-21 10:35:00 | SPY | ETF | 122.92 | 122.96 | 122.61 | 122.66 | 1482700.0 |
| 2005-07-21 10:40:00 | SPY | ETF | 122.68 | 122.68 | 122.47 | 122.63 | 3910900.0 |
| 2005-07-21 10:45:00 | SPY | ETF | 122.63 | 122.68 | 122.56 | 122.64 | 1729700.0 |
| 2005-07-21 10:50:00 | SPY | ETF | 122.64 | 122.7 | 122.55 | 122.64 | 756700.0 |
| 2005-07-21 10:55:00 | SPY | ETF | 122.65 | 122.68 | 122.59 | 122.64 | 490600.0 |
| 2005-07-21 11:00:00 | SPY | ETF | 122.63 | 122.67 | 122.56 | 122.64 | 603600.0 |
| 2005-07-21 11:05:00 | SPY | ETF | 122.65 | 122.73 | 122.61 | 122.72 | 482900.0 |
| 2005-07-21 11:10:00 | SPY | ETF | 122.73 | 122.9 | 122.7 | 122.85 | 2536600.0 |
> showing 50 of 6,976 rows — these rows as CSV