PREVIEW / etf_30min / 2001-11-13
file: by_date/etf_30min/2001/2001-11-13.parquet size: 17 KB rows: 465
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-13 09:30:00 | SPY | ETF | 113.44 | 113.72 | 113.23 | 113.24 | 2706200.0 |
| 2001-11-13 10:00:00 | SPY | ETF | 113.25 | 113.8 | 113.18 | 113.45 | 938900.0 |
| 2001-11-13 10:30:00 | SPY | ETF | 113.42 | 113.86 | 113.41 | 113.7 | 665800.0 |
| 2001-11-13 11:00:00 | SPY | ETF | 113.68 | 114.05 | 113.67 | 113.91 | 805400.0 |
| 2001-11-13 11:30:00 | SPY | ETF | 113.92 | 114.1 | 113.8 | 113.88 | 862400.0 |
| 2001-11-13 12:00:00 | SPY | ETF | 113.9 | 113.98 | 113.7 | 113.78 | 363500.0 |
| 2001-11-13 12:30:00 | SPY | ETF | 113.8 | 114.26 | 113.8 | 114.15 | 838900.0 |
| 2001-11-13 13:00:00 | SPY | ETF | 114.12 | 114.43 | 114.09 | 114.26 | 734400.0 |
| 2001-11-13 13:30:00 | SPY | ETF | 114.27 | 114.29 | 113.71 | 113.93 | 1208700.0 |
| 2001-11-13 14:00:00 | SPY | ETF | 113.99 | 114.11 | 113.68 | 114.0 | 866900.0 |
| 2001-11-13 14:30:00 | SPY | ETF | 113.9 | 113.96 | 113.58 | 113.79 | 938700.0 |
| 2001-11-13 15:00:00 | SPY | ETF | 113.77 | 114.2 | 113.72 | 114.13 | 819300.0 |
| 2001-11-13 15:30:00 | SPY | ETF | 114.14 | 114.4 | 113.98 | 114.39 | 1893400.0 |
| 2001-11-13 16:00:00 | SPY | ETF | 114.39 | 114.58 | 114.25 | 114.55 | 1420200.0 |
| 2001-11-13 16:30:00 | SPY | ETF | 114.59 | 114.63 | 114.46 | 114.6 | 15500.0 |
| 2001-11-13 17:00:00 | SPY | ETF | 114.6 | 114.6 | 114.5 | 114.5 | 27000.0 |
| 2001-11-13 17:30:00 | SPY | ETF | 114.41 | 114.53 | 114.4 | 114.53 | 25700.0 |
| 2001-11-13 09:30:00 | QQQ | ETF | 39.03 | 39.25 | 38.75 | 38.77 | 16301500.0 |
| 2001-11-13 10:00:00 | QQQ | ETF | 38.86 | 39.2 | 38.74 | 38.92 | 8218000.0 |
| 2001-11-13 10:30:00 | QQQ | ETF | 38.9 | 39.15 | 38.9 | 39.1 | 5015800.0 |
| 2001-11-13 11:00:00 | QQQ | ETF | 39.12 | 39.3 | 39.08 | 39.15 | 5677500.0 |
| 2001-11-13 11:30:00 | QQQ | ETF | 39.17 | 39.32 | 39.12 | 39.21 | 3066200.0 |
| 2001-11-13 12:00:00 | QQQ | ETF | 39.21 | 39.24 | 39.06 | 39.16 | 3985500.0 |
| 2001-11-13 12:30:00 | QQQ | ETF | 39.18 | 39.42 | 39.15 | 39.37 | 6628500.0 |
| 2001-11-13 13:00:00 | QQQ | ETF | 39.36 | 39.5 | 39.35 | 39.39 | 6480100.0 |
| 2001-11-13 13:30:00 | QQQ | ETF | 39.38 | 39.4 | 38.85 | 39.04 | 8136300.0 |
| 2001-11-13 14:00:00 | QQQ | ETF | 39.07 | 39.17 | 38.8 | 38.99 | 7823100.0 |
| 2001-11-13 14:30:00 | QQQ | ETF | 39.01 | 39.01 | 38.63 | 38.8 | 7332200.0 |
| 2001-11-13 15:00:00 | QQQ | ETF | 38.8 | 39.2 | 38.72 | 39.09 | 6826400.0 |
| 2001-11-13 15:30:00 | QQQ | ETF | 39.12 | 39.37 | 39.04 | 39.34 | 8325900.0 |
| 2001-11-13 16:00:00 | QQQ | ETF | 39.35 | 39.4 | 39.22 | 39.4 | 2788700.0 |
| 2001-11-13 16:30:00 | QQQ | ETF | 39.4 | 39.45 | 39.08 | 39.36 | 173200.0 |
| 2001-11-13 17:00:00 | QQQ | ETF | 39.36 | 39.37 | 39.3 | 39.3 | 93500.0 |
| 2001-11-13 17:30:00 | QQQ | ETF | 39.3 | 39.4 | 39.3 | 39.33 | 72700.0 |
| 2001-11-13 18:00:00 | QQQ | ETF | 39.31 | 39.31 | 39.26 | 39.26 | 77900.0 |
| 2001-11-13 09:30:00 | IWM | ETF | 44.25 | 44.375 | 44.15 | 44.18 | 48000.0 |
| 2001-11-13 10:00:00 | IWM | ETF | 44.175 | 44.45 | 44.125 | 44.34 | 74000.0 |
| 2001-11-13 10:30:00 | IWM | ETF | 44.325 | 44.365 | 44.285 | 44.355 | 7800.0 |
| 2001-11-13 11:00:00 | IWM | ETF | 44.37 | 44.425 | 44.37 | 44.425 | 1200.0 |
| 2001-11-13 11:30:00 | IWM | ETF | 44.415 | 44.455 | 44.355 | 44.4 | 27200.0 |
| 2001-11-13 12:00:00 | IWM | ETF | 44.41 | 44.41 | 44.315 | 44.315 | 43800.0 |
| 2001-11-13 12:30:00 | IWM | ETF | 44.31 | 44.475 | 44.31 | 44.44 | 21400.0 |
| 2001-11-13 13:00:00 | IWM | ETF | 44.405 | 44.545 | 44.405 | 44.53 | 23400.0 |
| 2001-11-13 13:30:00 | IWM | ETF | 44.525 | 44.545 | 44.3 | 44.39 | 27000.0 |
| 2001-11-13 14:00:00 | IWM | ETF | 44.375 | 44.405 | 44.315 | 44.35 | 14200.0 |
| 2001-11-13 14:30:00 | IWM | ETF | 44.35 | 44.4 | 44.265 | 44.335 | 19600.0 |
| 2001-11-13 15:00:00 | IWM | ETF | 44.33 | 44.425 | 44.26 | 44.4 | 21800.0 |
| 2001-11-13 15:30:00 | IWM | ETF | 44.43 | 44.635 | 44.405 | 44.575 | 19400.0 |
| 2001-11-13 16:00:00 | IWM | ETF | 44.625 | 44.675 | 44.625 | 44.675 | 93200.0 |
| 2001-11-13 09:30:00 | DIA | ETF | 96.79 | 97.0 | 96.61 | 96.74 | 1053900.0 |
> showing 50 of 465 rows — these rows as CSV