PREVIEW / etf_5min / 2005-07-29
file: by_date/etf_5min/2005/2005-07-29.parquet size: 120 KB rows: 6,629
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-29 07:40:00 | SPY | ETF | 124.7 | 124.7 | 124.7 | 124.7 | 400.0 |
| 2005-07-29 07:45:00 | SPY | ETF | 124.68 | 124.68 | 124.68 | 124.68 | 1400.0 |
| 2005-07-29 07:50:00 | SPY | ETF | 124.64 | 124.64 | 124.64 | 124.64 | 800.0 |
| 2005-07-29 07:55:00 | SPY | ETF | 124.65 | 124.65 | 124.65 | 124.65 | 1600.0 |
| 2005-07-29 08:10:00 | SPY | ETF | 124.7 | 124.7 | 124.65 | 124.65 | 2700.0 |
| 2005-07-29 08:15:00 | SPY | ETF | 124.65 | 124.67 | 124.65 | 124.65 | 50000.0 |
| 2005-07-29 08:20:00 | SPY | ETF | 124.64 | 124.68 | 124.63 | 124.68 | 37500.0 |
| 2005-07-29 08:25:00 | SPY | ETF | 124.65 | 124.68 | 124.64 | 124.67 | 48000.0 |
| 2005-07-29 08:30:00 | SPY | ETF | 124.65 | 124.7 | 124.52 | 124.54 | 160400.0 |
| 2005-07-29 08:35:00 | SPY | ETF | 124.54 | 124.55 | 124.54 | 124.55 | 3700.0 |
| 2005-07-29 08:40:00 | SPY | ETF | 124.55 | 124.57 | 124.55 | 124.57 | 29400.0 |
| 2005-07-29 08:50:00 | SPY | ETF | 124.57 | 124.57 | 124.57 | 124.57 | 400.0 |
| 2005-07-29 08:55:00 | SPY | ETF | 124.56 | 124.56 | 124.54 | 124.54 | 12500.0 |
| 2005-07-29 09:00:00 | SPY | ETF | 124.54 | 124.66 | 124.47 | 124.65 | 142900.0 |
| 2005-07-29 09:05:00 | SPY | ETF | 124.46 | 124.6 | 124.38 | 124.39 | 146000.0 |
| 2005-07-29 09:10:00 | SPY | ETF | 124.4 | 124.4 | 124.39 | 124.4 | 3700.0 |
| 2005-07-29 09:15:00 | SPY | ETF | 124.4 | 124.43 | 124.38 | 124.38 | 14600.0 |
| 2005-07-29 09:20:00 | SPY | ETF | 124.4 | 124.42 | 124.4 | 124.42 | 46200.0 |
| 2005-07-29 09:25:00 | SPY | ETF | 124.42 | 124.43 | 124.41 | 124.41 | 20300.0 |
| 2005-07-29 09:30:00 | SPY | ETF | 124.41 | 124.44 | 124.34 | 124.41 | 1197900.0 |
| 2005-07-29 09:35:00 | SPY | ETF | 124.41 | 124.44 | 124.33 | 124.38 | 677600.0 |
| 2005-07-29 09:40:00 | SPY | ETF | 124.38 | 124.46 | 124.36 | 124.44 | 593700.0 |
| 2005-07-29 09:45:00 | SPY | ETF | 124.45 | 124.51 | 124.41 | 124.5 | 424900.0 |
| 2005-07-29 09:50:00 | SPY | ETF | 124.48 | 124.5 | 124.41 | 124.42 | 530700.0 |
| 2005-07-29 09:55:00 | SPY | ETF | 124.42 | 124.52 | 124.39 | 124.51 | 783900.0 |
| 2005-07-29 10:00:00 | SPY | ETF | 124.53 | 124.63 | 124.49 | 124.5 | 2488100.0 |
| 2005-07-29 10:05:00 | SPY | ETF | 124.49 | 124.51 | 124.44 | 124.44 | 1133900.0 |
| 2005-07-29 10:10:00 | SPY | ETF | 124.43 | 124.44 | 124.31 | 124.34 | 776600.0 |
| 2005-07-29 10:15:00 | SPY | ETF | 124.34 | 124.36 | 124.18 | 124.27 | 1892200.0 |
| 2005-07-29 10:20:00 | SPY | ETF | 124.28 | 124.32 | 124.25 | 124.3 | 415000.0 |
| 2005-07-29 10:25:00 | SPY | ETF | 124.31 | 124.35 | 124.25 | 124.28 | 718900.0 |
| 2005-07-29 10:30:00 | SPY | ETF | 124.26 | 124.29 | 124.14 | 124.23 | 784600.0 |
| 2005-07-29 10:35:00 | SPY | ETF | 124.23 | 124.27 | 124.19 | 124.25 | 415000.0 |
| 2005-07-29 10:40:00 | SPY | ETF | 124.25 | 124.26 | 124.1 | 124.2 | 754700.0 |
| 2005-07-29 10:45:00 | SPY | ETF | 124.2 | 124.2 | 124.1 | 124.15 | 327400.0 |
| 2005-07-29 10:50:00 | SPY | ETF | 124.14 | 124.16 | 124.06 | 124.14 | 509400.0 |
| 2005-07-29 10:55:00 | SPY | ETF | 124.15 | 124.16 | 124.09 | 124.11 | 244900.0 |
| 2005-07-29 11:00:00 | SPY | ETF | 124.11 | 124.16 | 124.05 | 124.08 | 506800.0 |
| 2005-07-29 11:05:00 | SPY | ETF | 124.07 | 124.08 | 123.99 | 124.03 | 1736600.0 |
| 2005-07-29 11:10:00 | SPY | ETF | 124.04 | 124.12 | 124.02 | 124.11 | 487000.0 |
| 2005-07-29 11:15:00 | SPY | ETF | 124.11 | 124.11 | 124.04 | 124.08 | 338000.0 |
| 2005-07-29 11:20:00 | SPY | ETF | 124.08 | 124.19 | 124.06 | 124.15 | 966500.0 |
| 2005-07-29 11:25:00 | SPY | ETF | 124.16 | 124.17 | 124.06 | 124.07 | 971100.0 |
| 2005-07-29 11:30:00 | SPY | ETF | 124.07 | 124.13 | 124.04 | 124.1 | 357800.0 |
| 2005-07-29 11:35:00 | SPY | ETF | 124.09 | 124.12 | 124.01 | 124.04 | 567800.0 |
| 2005-07-29 11:40:00 | SPY | ETF | 124.04 | 124.14 | 123.96 | 124.02 | 609700.0 |
| 2005-07-29 11:45:00 | SPY | ETF | 124.0 | 124.05 | 123.9 | 123.9 | 2786800.0 |
| 2005-07-29 11:50:00 | SPY | ETF | 123.9 | 123.97 | 123.86 | 123.9 | 1462800.0 |
| 2005-07-29 11:55:00 | SPY | ETF | 123.9 | 123.96 | 123.89 | 123.93 | 424400.0 |
| 2005-07-29 12:00:00 | SPY | ETF | 123.93 | 123.99 | 123.92 | 123.92 | 409400.0 |
> showing 50 of 6,629 rows — these rows as CSV