PREVIEW / etf_5min / 2004-10-19
file: by_date/etf_5min/2004/2004-10-19.parquet size: 104 KB rows: 4,942
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-19 08:00:00 | SPY | ETF | 112.2 | 112.2 | 112.19 | 112.2 | 25100.0 |
| 2004-10-19 08:05:00 | SPY | ETF | 112.16 | 112.16 | 112.15 | 112.15 | 5500.0 |
| 2004-10-19 08:10:00 | SPY | ETF | 112.17 | 112.2 | 112.17 | 112.18 | 30500.0 |
| 2004-10-19 08:15:00 | SPY | ETF | 112.19 | 112.19 | 112.19 | 112.19 | 200.0 |
| 2004-10-19 08:20:00 | SPY | ETF | 112.17 | 112.17 | 112.16 | 112.17 | 9400.0 |
| 2004-10-19 08:25:00 | SPY | ETF | 112.17 | 112.18 | 112.17 | 112.18 | 1400.0 |
| 2004-10-19 08:30:00 | SPY | ETF | 112.17 | 112.17 | 112.09 | 112.14 | 41200.0 |
| 2004-10-19 08:35:00 | SPY | ETF | 112.14 | 112.15 | 112.1 | 112.1 | 3200.0 |
| 2004-10-19 08:40:00 | SPY | ETF | 112.08 | 112.11 | 112.07 | 112.11 | 9400.0 |
| 2004-10-19 08:45:00 | SPY | ETF | 112.1 | 112.1 | 112.07 | 112.07 | 1500.0 |
| 2004-10-19 08:50:00 | SPY | ETF | 112.07 | 112.09 | 112.07 | 112.09 | 1500.0 |
| 2004-10-19 08:55:00 | SPY | ETF | 112.08 | 112.08 | 112.06 | 112.07 | 7100.0 |
| 2004-10-19 09:00:00 | SPY | ETF | 112.08 | 112.09 | 112.07 | 112.09 | 2300.0 |
| 2004-10-19 09:05:00 | SPY | ETF | 112.09 | 112.1 | 112.08 | 112.08 | 32700.0 |
| 2004-10-19 09:10:00 | SPY | ETF | 112.08 | 112.1 | 112.08 | 112.1 | 4200.0 |
| 2004-10-19 09:15:00 | SPY | ETF | 112.08 | 112.09 | 112.05 | 112.05 | 2300.0 |
| 2004-10-19 09:20:00 | SPY | ETF | 112.07 | 112.07 | 112.07 | 112.07 | 1700.0 |
| 2004-10-19 09:25:00 | SPY | ETF | 112.07 | 112.07 | 112.03 | 112.03 | 4500.0 |
| 2004-10-19 09:30:00 | SPY | ETF | 112.02 | 112.05 | 111.94 | 111.99 | 1174300.0 |
| 2004-10-19 09:35:00 | SPY | ETF | 111.99 | 112.0 | 111.9 | 112.0 | 663800.0 |
| 2004-10-19 09:40:00 | SPY | ETF | 111.99 | 112.08 | 111.97 | 111.97 | 588900.0 |
| 2004-10-19 09:45:00 | SPY | ETF | 112.03 | 112.12 | 111.99 | 112.09 | 1232500.0 |
| 2004-10-19 09:50:00 | SPY | ETF | 112.06 | 112.09 | 111.95 | 112.03 | 793000.0 |
| 2004-10-19 09:55:00 | SPY | ETF | 112.03 | 112.07 | 111.89 | 111.92 | 572800.0 |
| 2004-10-19 10:00:00 | SPY | ETF | 111.92 | 112.18 | 111.9 | 112.18 | 918500.0 |
| 2004-10-19 10:05:00 | SPY | ETF | 112.17 | 112.23 | 112.14 | 112.14 | 870400.0 |
| 2004-10-19 10:10:00 | SPY | ETF | 112.16 | 112.19 | 112.08 | 112.15 | 1716200.0 |
| 2004-10-19 10:15:00 | SPY | ETF | 112.17 | 112.21 | 112.05 | 112.05 | 409500.0 |
| 2004-10-19 10:20:00 | SPY | ETF | 112.09 | 112.1 | 111.93 | 112.04 | 971300.0 |
| 2004-10-19 10:25:00 | SPY | ETF | 112.03 | 112.06 | 111.87 | 111.88 | 621300.0 |
| 2004-10-19 10:30:00 | SPY | ETF | 111.89 | 111.97 | 111.86 | 111.86 | 658100.0 |
| 2004-10-19 10:35:00 | SPY | ETF | 111.86 | 111.88 | 111.77 | 111.85 | 1087700.0 |
| 2004-10-19 10:40:00 | SPY | ETF | 111.85 | 111.86 | 111.74 | 111.83 | 1615000.0 |
| 2004-10-19 10:45:00 | SPY | ETF | 111.82 | 111.89 | 111.81 | 111.81 | 629600.0 |
| 2004-10-19 10:50:00 | SPY | ETF | 111.82 | 111.89 | 111.71 | 111.86 | 545300.0 |
| 2004-10-19 10:55:00 | SPY | ETF | 111.86 | 111.89 | 111.68 | 111.73 | 635400.0 |
| 2004-10-19 11:00:00 | SPY | ETF | 111.72 | 111.79 | 111.67 | 111.68 | 591000.0 |
| 2004-10-19 11:05:00 | SPY | ETF | 111.68 | 111.7 | 111.52 | 111.55 | 1234500.0 |
| 2004-10-19 11:10:00 | SPY | ETF | 111.55 | 111.66 | 111.51 | 111.55 | 1050500.0 |
| 2004-10-19 11:15:00 | SPY | ETF | 111.54 | 111.57 | 111.3 | 111.33 | 1064400.0 |
| 2004-10-19 11:20:00 | SPY | ETF | 111.38 | 111.44 | 111.32 | 111.42 | 764300.0 |
| 2004-10-19 11:25:00 | SPY | ETF | 111.43 | 111.47 | 111.35 | 111.4 | 491200.0 |
| 2004-10-19 11:30:00 | SPY | ETF | 111.41 | 111.52 | 111.32 | 111.51 | 884100.0 |
| 2004-10-19 11:35:00 | SPY | ETF | 111.52 | 111.52 | 111.32 | 111.48 | 342800.0 |
| 2004-10-19 11:40:00 | SPY | ETF | 111.49 | 111.53 | 111.42 | 111.48 | 757200.0 |
| 2004-10-19 11:45:00 | SPY | ETF | 111.49 | 111.5 | 111.37 | 111.37 | 368200.0 |
| 2004-10-19 11:50:00 | SPY | ETF | 111.37 | 111.45 | 111.31 | 111.41 | 490200.0 |
| 2004-10-19 11:55:00 | SPY | ETF | 111.41 | 111.48 | 111.38 | 111.44 | 381200.0 |
| 2004-10-19 12:00:00 | SPY | ETF | 111.45 | 111.57 | 111.43 | 111.55 | 492200.0 |
| 2004-10-19 12:05:00 | SPY | ETF | 111.57 | 111.6 | 111.52 | 111.53 | 312100.0 |
> showing 50 of 4,942 rows — these rows as CSV