PREVIEW / etf_30min / 2004-02-10
file: by_date/etf_30min/2004/2004-02-10.parquet size: 35 KB rows: 1,204
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-02-10 08:30:00 | SPY | ETF | 114.4 | 114.4 | 114.38 | 114.38 | 13000.0 |
| 2004-02-10 09:00:00 | SPY | ETF | 114.4 | 114.4 | 114.28 | 114.28 | 15300.0 |
| 2004-02-10 09:30:00 | SPY | ETF | 114.28 | 114.51 | 114.26 | 114.48 | 3113600.0 |
| 2004-02-10 10:00:00 | SPY | ETF | 114.49 | 114.62 | 114.41 | 114.47 | 1190200.0 |
| 2004-02-10 10:30:00 | SPY | ETF | 114.47 | 114.84 | 114.43 | 114.79 | 2521200.0 |
| 2004-02-10 11:00:00 | SPY | ETF | 114.79 | 114.83 | 114.7 | 114.75 | 1172400.0 |
| 2004-02-10 11:30:00 | SPY | ETF | 114.74 | 114.77 | 114.62 | 114.68 | 690000.0 |
| 2004-02-10 12:00:00 | SPY | ETF | 114.68 | 114.81 | 114.64 | 114.8 | 808200.0 |
| 2004-02-10 12:30:00 | SPY | ETF | 114.8 | 115.14 | 114.72 | 115.08 | 1519700.0 |
| 2004-02-10 13:00:00 | SPY | ETF | 115.09 | 115.09 | 114.92 | 114.96 | 1072200.0 |
| 2004-02-10 13:30:00 | SPY | ETF | 114.96 | 115.04 | 114.92 | 115.0 | 669200.0 |
| 2004-02-10 14:00:00 | SPY | ETF | 114.97 | 115.08 | 114.52 | 114.78 | 3090500.0 |
| 2004-02-10 14:30:00 | SPY | ETF | 114.78 | 114.8 | 114.56 | 114.61 | 1864500.0 |
| 2004-02-10 15:00:00 | SPY | ETF | 114.63 | 114.82 | 114.57 | 114.76 | 1248600.0 |
| 2004-02-10 15:30:00 | SPY | ETF | 114.74 | 114.97 | 114.74 | 114.9 | 2638300.0 |
| 2004-02-10 16:00:00 | SPY | ETF | 114.9 | 114.97 | 114.77 | 114.82 | 1601300.0 |
| 2004-02-10 16:30:00 | SPY | ETF | 114.81 | 114.86 | 114.77 | 114.79 | 42900.0 |
| 2004-02-10 17:00:00 | SPY | ETF | 114.79 | 114.87 | 114.79 | 114.87 | 13100.0 |
| 2004-02-10 17:30:00 | SPY | ETF | 114.87 | 114.87 | 114.86 | 114.86 | 4300.0 |
| 2004-02-10 18:00:00 | SPY | ETF | 114.86 | 114.88 | 114.86 | 114.87 | 25100.0 |
| 2004-02-10 08:00:00 | QQQ | ETF | 37.11 | 37.15 | 37.11 | 37.13 | 10700.0 |
| 2004-02-10 08:30:00 | QQQ | ETF | 37.13 | 37.13 | 37.1 | 37.11 | 34300.0 |
| 2004-02-10 09:00:00 | QQQ | ETF | 37.1 | 37.1 | 37.07 | 37.07 | 59800.0 |
| 2004-02-10 09:30:00 | QQQ | ETF | 37.061 | 37.157 | 37.03 | 37.14 | 6339400.0 |
| 2004-02-10 10:00:00 | QQQ | ETF | 37.15 | 37.21 | 37.116 | 37.143 | 5384200.0 |
| 2004-02-10 10:30:00 | QQQ | ETF | 37.14 | 37.35 | 37.14 | 37.33 | 6618200.0 |
| 2004-02-10 11:00:00 | QQQ | ETF | 37.323 | 37.36 | 37.26 | 37.28 | 4919100.0 |
| 2004-02-10 11:30:00 | QQQ | ETF | 37.278 | 37.29 | 37.2 | 37.247 | 3315100.0 |
| 2004-02-10 12:00:00 | QQQ | ETF | 37.24 | 37.29 | 37.23 | 37.29 | 2228200.0 |
| 2004-02-10 12:30:00 | QQQ | ETF | 37.28 | 37.41 | 37.23 | 37.38 | 4772800.0 |
| 2004-02-10 13:00:00 | QQQ | ETF | 37.37 | 37.39 | 37.29 | 37.307 | 2543000.0 |
| 2004-02-10 13:30:00 | QQQ | ETF | 37.307 | 37.33 | 37.27 | 37.3 | 2150000.0 |
| 2004-02-10 14:00:00 | QQQ | ETF | 37.3 | 37.34 | 37.13 | 37.22 | 5745000.0 |
| 2004-02-10 14:30:00 | QQQ | ETF | 37.22 | 37.222 | 37.112 | 37.12 | 3690400.0 |
| 2004-02-10 15:00:00 | QQQ | ETF | 37.13 | 37.2 | 37.08 | 37.18 | 5986200.0 |
| 2004-02-10 15:30:00 | QQQ | ETF | 37.175 | 37.241 | 37.15 | 37.23 | 6835900.0 |
| 2004-02-10 16:00:00 | QQQ | ETF | 37.23 | 37.265 | 37.17 | 37.2 | 2082700.0 |
| 2004-02-10 16:30:00 | QQQ | ETF | 37.218 | 37.218 | 37.19 | 37.204 | 102400.0 |
| 2004-02-10 17:00:00 | QQQ | ETF | 37.201 | 37.22 | 37.2 | 37.219 | 9400.0 |
| 2004-02-10 17:30:00 | QQQ | ETF | 37.219 | 37.3 | 37.191 | 37.23 | 227600.0 |
| 2004-02-10 18:00:00 | QQQ | ETF | 37.24 | 37.25 | 37.23 | 37.25 | 31000.0 |
| 2004-02-10 18:30:00 | QQQ | ETF | 37.25 | 37.25 | 37.24 | 37.24 | 3300.0 |
| 2004-02-10 19:00:00 | QQQ | ETF | 37.23 | 37.25 | 37.23 | 37.25 | 3100.0 |
| 2004-02-10 19:30:00 | QQQ | ETF | 37.24 | 37.25 | 37.24 | 37.24 | 1900.0 |
| 2004-02-10 09:00:00 | IWM | ETF | 58.34 | 58.34 | 58.275 | 58.275 | 1200.0 |
| 2004-02-10 09:30:00 | IWM | ETF | 58.3 | 58.45 | 58.23 | 58.35 | 1187800.0 |
| 2004-02-10 10:00:00 | IWM | ETF | 58.37 | 58.4 | 58.18 | 58.345 | 568200.0 |
| 2004-02-10 10:30:00 | IWM | ETF | 58.36 | 58.6 | 58.295 | 58.575 | 396400.0 |
| 2004-02-10 11:00:00 | IWM | ETF | 58.58 | 58.64 | 58.535 | 58.625 | 236200.0 |
| 2004-02-10 11:30:00 | IWM | ETF | 58.645 | 58.65 | 58.465 | 58.465 | 61400.0 |
> showing 50 of 1,204 rows — these rows as CSV