PREVIEW / etf_30min / 2003-03-27
file: by_date/etf_30min/2003/2003-03-27.parquet size: 21 KB rows: 608
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-27 08:00:00 | SPY | ETF | 86.44 | 86.47 | 86.3 | 86.31 | 23700.0 |
| 2003-03-27 08:30:00 | SPY | ETF | 86.35 | 86.54 | 86.35 | 86.35 | 71900.0 |
| 2003-03-27 09:00:00 | SPY | ETF | 86.38 | 86.45 | 86.33 | 86.39 | 54400.0 |
| 2003-03-27 09:30:00 | SPY | ETF | 86.4 | 86.59 | 86.11 | 86.13 | 7043300.0 |
| 2003-03-27 10:00:00 | SPY | ETF | 86.13 | 86.44 | 85.99 | 86.34 | 3935100.0 |
| 2003-03-27 10:30:00 | SPY | ETF | 86.34 | 86.41 | 86.1 | 86.24 | 1592100.0 |
| 2003-03-27 11:00:00 | SPY | ETF | 86.24 | 86.7 | 86.15 | 86.46 | 2357000.0 |
| 2003-03-27 11:30:00 | SPY | ETF | 86.45 | 86.58 | 86.35 | 86.51 | 1158000.0 |
| 2003-03-27 12:00:00 | SPY | ETF | 86.52 | 86.72 | 86.44 | 86.62 | 1346500.0 |
| 2003-03-27 12:30:00 | SPY | ETF | 86.63 | 87.24 | 86.62 | 87.11 | 3524700.0 |
| 2003-03-27 13:00:00 | SPY | ETF | 87.16 | 87.2 | 86.92 | 87.01 | 1703700.0 |
| 2003-03-27 13:30:00 | SPY | ETF | 87.01 | 87.33 | 86.9 | 87.3 | 1860900.0 |
| 2003-03-27 14:00:00 | SPY | ETF | 87.31 | 87.66 | 87.17 | 87.41 | 5201200.0 |
| 2003-03-27 14:30:00 | SPY | ETF | 87.37 | 87.58 | 87.21 | 87.25 | 4264400.0 |
| 2003-03-27 15:00:00 | SPY | ETF | 87.25 | 87.57 | 87.11 | 87.16 | 2376500.0 |
| 2003-03-27 15:30:00 | SPY | ETF | 87.16 | 87.22 | 86.85 | 87.1 | 4357600.0 |
| 2003-03-27 16:00:00 | SPY | ETF | 87.09 | 87.15 | 87.0 | 87.12 | 1866500.0 |
| 2003-03-27 16:30:00 | SPY | ETF | 87.12 | 87.14 | 87.05 | 87.1 | 18600.0 |
| 2003-03-27 17:00:00 | SPY | ETF | 87.09 | 87.12 | 87.08 | 87.11 | 7800.0 |
| 2003-03-27 17:30:00 | SPY | ETF | 87.11 | 87.17 | 87.09 | 87.17 | 164400.0 |
| 2003-03-27 18:00:00 | SPY | ETF | 87.17 | 87.17 | 87.11 | 87.12 | 4000.0 |
| 2003-03-27 18:30:00 | SPY | ETF | 87.16 | 87.16 | 87.12 | 87.12 | 1400.0 |
| 2003-03-27 19:00:00 | SPY | ETF | 87.13 | 87.13 | 87.12 | 87.13 | 900.0 |
| 2003-03-27 19:30:00 | SPY | ETF | 87.12 | 87.12 | 87.09 | 87.09 | 900.0 |
| 2003-03-27 08:00:00 | QQQ | ETF | 26.33 | 26.34 | 26.23 | 26.24 | 59200.0 |
| 2003-03-27 08:30:00 | QQQ | ETF | 26.24 | 26.32 | 26.23 | 26.26 | 50500.0 |
| 2003-03-27 09:00:00 | QQQ | ETF | 26.28 | 26.3 | 26.25 | 26.28 | 128000.0 |
| 2003-03-27 09:30:00 | QQQ | ETF | 26.27 | 26.35 | 26.16 | 26.17 | 9208800.0 |
| 2003-03-27 10:00:00 | QQQ | ETF | 26.17 | 26.24 | 26.1 | 26.21 | 6665100.0 |
| 2003-03-27 10:30:00 | QQQ | ETF | 26.22 | 26.23 | 26.1 | 26.18 | 4484700.0 |
| 2003-03-27 11:00:00 | QQQ | ETF | 26.18 | 26.33 | 26.15 | 26.21 | 4674900.0 |
| 2003-03-27 11:30:00 | QQQ | ETF | 26.2 | 26.29 | 26.2 | 26.24 | 1928400.0 |
| 2003-03-27 12:00:00 | QQQ | ETF | 26.25 | 26.33 | 26.2 | 26.25 | 3787500.0 |
| 2003-03-27 12:30:00 | QQQ | ETF | 26.25 | 26.51 | 26.22 | 26.46 | 5734300.0 |
| 2003-03-27 13:00:00 | QQQ | ETF | 26.46 | 26.47 | 26.35 | 26.38 | 2009100.0 |
| 2003-03-27 13:30:00 | QQQ | ETF | 26.4 | 26.52 | 26.34 | 26.51 | 3599300.0 |
| 2003-03-27 14:00:00 | QQQ | ETF | 26.51 | 26.64 | 26.47 | 26.54 | 4961700.0 |
| 2003-03-27 14:30:00 | QQQ | ETF | 26.53 | 26.62 | 26.44 | 26.51 | 3041400.0 |
| 2003-03-27 15:00:00 | QQQ | ETF | 26.49 | 26.62 | 26.43 | 26.45 | 3886800.0 |
| 2003-03-27 15:30:00 | QQQ | ETF | 26.44 | 26.5 | 26.34 | 26.38 | 3706400.0 |
| 2003-03-27 16:00:00 | QQQ | ETF | 26.38 | 26.43 | 26.32 | 26.36 | 1302200.0 |
| 2003-03-27 16:30:00 | QQQ | ETF | 26.36 | 26.38 | 26.34 | 26.36 | 69400.0 |
| 2003-03-27 17:00:00 | QQQ | ETF | 26.36 | 26.37 | 26.36 | 26.37 | 16700.0 |
| 2003-03-27 17:30:00 | QQQ | ETF | 26.37 | 26.37 | 26.3 | 26.37 | 11700.0 |
| 2003-03-27 18:00:00 | QQQ | ETF | 26.36 | 26.38 | 26.35 | 26.38 | 21300.0 |
| 2003-03-27 18:30:00 | QQQ | ETF | 26.37 | 26.4 | 26.37 | 26.4 | 3000.0 |
| 2003-03-27 19:00:00 | QQQ | ETF | 26.38 | 26.38 | 26.38 | 26.38 | 200.0 |
| 2003-03-27 19:30:00 | QQQ | ETF | 26.39 | 26.41 | 26.37 | 26.39 | 8300.0 |
| 2003-03-27 09:30:00 | IWM | ETF | 36.35 | 36.525 | 36.3 | 36.375 | 211000.0 |
| 2003-03-27 10:00:00 | IWM | ETF | 36.36 | 36.435 | 36.3 | 36.38 | 117400.0 |
> showing 50 of 608 rows — these rows as CSV