PREVIEW / etf_30min / 2005-03-18
file: by_date/etf_30min/2005/2005-03-18.parquet size: 44 KB rows: 1,505
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-03-18 08:00:00 | SPY | ETF | 119.1 | 119.1 | 119.04 | 119.08 | 67100.0 |
| 2005-03-18 08:30:00 | SPY | ETF | 119.06 | 119.09 | 119.0 | 119.01 | 62000.0 |
| 2005-03-18 09:00:00 | SPY | ETF | 119.04 | 119.16 | 119.01 | 119.12 | 388400.0 |
| 2005-03-18 09:30:00 | SPY | ETF | 119.11 | 119.16 | 118.76 | 118.87 | 6199800.0 |
| 2005-03-18 10:00:00 | SPY | ETF | 118.86 | 119.03 | 118.71 | 118.84 | 3951600.0 |
| 2005-03-18 10:30:00 | SPY | ETF | 118.84 | 118.89 | 118.47 | 118.64 | 4458800.0 |
| 2005-03-18 11:00:00 | SPY | ETF | 118.62 | 118.95 | 118.59 | 118.86 | 3449500.0 |
| 2005-03-18 11:30:00 | SPY | ETF | 118.86 | 118.86 | 118.6 | 118.73 | 4214300.0 |
| 2005-03-18 12:00:00 | SPY | ETF | 118.74 | 118.91 | 118.65 | 118.72 | 1442300.0 |
| 2005-03-18 12:30:00 | SPY | ETF | 118.7 | 118.8 | 118.54 | 118.58 | 1356000.0 |
| 2005-03-18 13:00:00 | SPY | ETF | 118.58 | 118.984 | 118.28 | 118.42 | 4471600.0 |
| 2005-03-18 13:30:00 | SPY | ETF | 118.42 | 118.48 | 118.15 | 118.41 | 5849700.0 |
| 2005-03-18 14:00:00 | SPY | ETF | 118.4 | 118.54 | 118.28 | 118.48 | 5599200.0 |
| 2005-03-18 14:30:00 | SPY | ETF | 118.49 | 118.69 | 118.34 | 118.39 | 2735500.0 |
| 2005-03-18 15:00:00 | SPY | ETF | 118.391 | 119.53 | 118.16 | 118.5 | 3377200.0 |
| 2005-03-18 15:30:00 | SPY | ETF | 118.51 | 118.92 | 118.45 | 118.81 | 7311200.0 |
| 2005-03-18 16:00:00 | SPY | ETF | 118.72 | 118.88 | 118.46 | 118.6 | 2896600.0 |
| 2005-03-18 16:30:00 | SPY | ETF | 118.6 | 118.88 | 118.6 | 118.61 | 351300.0 |
| 2005-03-18 17:00:00 | SPY | ETF | 118.62 | 118.82 | 118.6 | 118.61 | 1264300.0 |
| 2005-03-18 17:30:00 | SPY | ETF | 118.61 | 118.61 | 118.5874 | 118.59 | 14000.0 |
| 2005-03-18 18:00:00 | SPY | ETF | 118.6 | 118.61 | 118.54 | 118.58 | 2600.0 |
| 2005-03-18 18:30:00 | SPY | ETF | 118.58 | 118.58 | 118.58 | 118.58 | 600.0 |
| 2005-03-18 19:00:00 | SPY | ETF | 118.58 | 118.6 | 118.58 | 118.6 | 400.0 |
| 2005-03-18 19:30:00 | SPY | ETF | 118.6 | 118.6 | 118.6 | 118.6 | 300.0 |
| 2005-03-18 09:30:00 | QQQ | ETF | 36.75 | 36.78 | 36.55 | 36.59 | 11862000.0 |
| 2005-03-18 10:00:00 | QQQ | ETF | 36.59 | 36.69 | 36.54 | 36.63 | 8490800.0 |
| 2005-03-18 10:30:00 | QQQ | ETF | 36.63 | 36.65 | 36.52 | 36.58 | 8156400.0 |
| 2005-03-18 11:00:00 | QQQ | ETF | 36.58 | 36.67 | 36.56 | 36.63 | 5764300.0 |
| 2005-03-18 11:30:00 | QQQ | ETF | 36.62 | 36.63 | 36.56 | 36.6 | 3404900.0 |
| 2005-03-18 12:00:00 | QQQ | ETF | 36.6 | 36.64 | 36.55 | 36.58 | 4608200.0 |
| 2005-03-18 12:30:00 | QQQ | ETF | 36.58 | 36.6 | 36.49 | 36.51 | 3841800.0 |
| 2005-03-18 13:00:00 | QQQ | ETF | 36.5 | 36.53 | 36.45 | 36.48 | 7193200.0 |
| 2005-03-18 13:30:00 | QQQ | ETF | 36.48 | 36.52 | 36.37 | 36.48 | 8277100.0 |
| 2005-03-18 14:00:00 | QQQ | ETF | 36.47 | 36.5 | 36.4 | 36.47 | 5762200.0 |
| 2005-03-18 14:30:00 | QQQ | ETF | 36.47 | 36.52 | 36.42 | 36.42 | 6357600.0 |
| 2005-03-18 15:00:00 | QQQ | ETF | 36.43 | 36.66 | 36.35 | 36.48 | 9974200.0 |
| 2005-03-18 15:30:00 | QQQ | ETF | 36.48 | 36.58 | 36.45 | 36.52 | 12223200.0 |
| 2005-03-18 09:00:00 | IWM | ETF | 62.375 | 62.375 | 62.185 | 62.36 | 9800.0 |
| 2005-03-18 09:30:00 | IWM | ETF | 62.28 | 62.35 | 61.975 | 62.125 | 4507400.0 |
| 2005-03-18 10:00:00 | IWM | ETF | 62.11 | 62.205 | 62.045 | 62.135 | 1330200.0 |
| 2005-03-18 10:30:00 | IWM | ETF | 62.15 | 62.165 | 61.975 | 62.005 | 1487200.0 |
| 2005-03-18 11:00:00 | IWM | ETF | 62.005 | 62.13 | 61.985 | 62.065 | 765800.0 |
| 2005-03-18 11:30:00 | IWM | ETF | 62.07 | 62.07 | 61.99 | 62.05 | 367200.0 |
| 2005-03-18 12:00:00 | IWM | ETF | 62.05 | 62.085 | 62.01 | 62.02 | 342800.0 |
| 2005-03-18 12:30:00 | IWM | ETF | 62.025 | 62.075 | 61.97 | 61.97 | 676200.0 |
| 2005-03-18 13:00:00 | IWM | ETF | 61.98 | 61.98 | 61.805 | 61.87 | 2155200.0 |
| 2005-03-18 13:30:00 | IWM | ETF | 61.875 | 61.925 | 61.74 | 61.925 | 918200.0 |
| 2005-03-18 14:00:00 | IWM | ETF | 61.925 | 61.97 | 61.845 | 61.915 | 1642600.0 |
| 2005-03-18 14:30:00 | IWM | ETF | 61.915 | 62.135 | 61.9 | 61.995 | 1221600.0 |
| 2005-03-18 15:00:00 | IWM | ETF | 61.995 | 62.125 | 61.895 | 62.015 | 1482400.0 |
> showing 50 of 1,505 rows — these rows as CSV