PREVIEW / etf_30min / 2003-05-16
file: by_date/etf_30min/2003/2003-05-16.parquet size: 22 KB rows: 641
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-05-16 08:00:00 | SPY | ETF | 95.0 | 95.08 | 94.97 | 95.08 | 2900.0 |
| 2003-05-16 08:30:00 | SPY | ETF | 94.96 | 94.96 | 94.73 | 94.74 | 97000.0 |
| 2003-05-16 09:00:00 | SPY | ETF | 94.75 | 94.85 | 94.75 | 94.85 | 51200.0 |
| 2003-05-16 09:30:00 | SPY | ETF | 94.89 | 95.43 | 94.78 | 94.97 | 7873100.0 |
| 2003-05-16 10:00:00 | SPY | ETF | 94.95 | 95.0 | 94.26 | 94.37 | 4831100.0 |
| 2003-05-16 10:30:00 | SPY | ETF | 94.41 | 94.62 | 94.3 | 94.57 | 2679500.0 |
| 2003-05-16 11:00:00 | SPY | ETF | 94.57 | 94.64 | 94.45 | 94.48 | 941500.0 |
| 2003-05-16 11:30:00 | SPY | ETF | 94.48 | 94.69 | 94.48 | 94.5 | 1180700.0 |
| 2003-05-16 12:00:00 | SPY | ETF | 94.52 | 94.7 | 94.45 | 94.65 | 732900.0 |
| 2003-05-16 12:30:00 | SPY | ETF | 94.65 | 94.94 | 94.65 | 94.86 | 1122100.0 |
| 2003-05-16 13:00:00 | SPY | ETF | 94.84 | 94.95 | 94.7 | 94.81 | 1112800.0 |
| 2003-05-16 13:30:00 | SPY | ETF | 94.83 | 95.15 | 94.78 | 95.09 | 1559000.0 |
| 2003-05-16 14:00:00 | SPY | ETF | 95.1 | 95.3 | 95.09 | 95.25 | 2251900.0 |
| 2003-05-16 14:30:00 | SPY | ETF | 95.28 | 95.29 | 95.01 | 95.17 | 1680200.0 |
| 2003-05-16 15:00:00 | SPY | ETF | 95.17 | 95.24 | 94.82 | 94.97 | 1072600.0 |
| 2003-05-16 15:30:00 | SPY | ETF | 94.95 | 95.06 | 94.82 | 94.86 | 1855700.0 |
| 2003-05-16 16:00:00 | SPY | ETF | 94.86 | 94.92 | 93.8 | 94.89 | 3047000.0 |
| 2003-05-16 16:30:00 | SPY | ETF | 94.88 | 94.94 | 94.88 | 94.9 | 68500.0 |
| 2003-05-16 17:00:00 | SPY | ETF | 94.87 | 94.93 | 94.87 | 94.93 | 25100.0 |
| 2003-05-16 18:00:00 | SPY | ETF | 94.9 | 94.9 | 94.9 | 94.9 | 800.0 |
| 2003-05-16 19:00:00 | SPY | ETF | 94.9 | 94.9 | 94.9 | 94.9 | 100.0 |
| 2003-05-16 19:30:00 | SPY | ETF | 94.9 | 94.9 | 94.86 | 94.86 | 7500.0 |
| 2003-05-16 08:00:00 | QQQ | ETF | 28.82 | 28.82 | 28.79 | 28.79 | 30200.0 |
| 2003-05-16 08:30:00 | QQQ | ETF | 28.78 | 28.79 | 28.69 | 28.72 | 41900.0 |
| 2003-05-16 09:00:00 | QQQ | ETF | 28.73 | 28.78 | 28.71 | 28.72 | 35600.0 |
| 2003-05-16 09:30:00 | QQQ | ETF | 28.73 | 28.94 | 28.64 | 28.69 | 11881200.0 |
| 2003-05-16 10:00:00 | QQQ | ETF | 28.69 | 28.76 | 28.48 | 28.52 | 9625900.0 |
| 2003-05-16 10:30:00 | QQQ | ETF | 28.52 | 28.65 | 28.48 | 28.61 | 4078100.0 |
| 2003-05-16 11:00:00 | QQQ | ETF | 28.61 | 28.64 | 28.54 | 28.55 | 1747800.0 |
| 2003-05-16 11:30:00 | QQQ | ETF | 28.55 | 28.69 | 28.52 | 28.57 | 2221300.0 |
| 2003-05-16 12:00:00 | QQQ | ETF | 28.55 | 28.65 | 28.52 | 28.62 | 1711400.0 |
| 2003-05-16 12:30:00 | QQQ | ETF | 28.62 | 28.73 | 28.62 | 28.68 | 2933600.0 |
| 2003-05-16 13:00:00 | QQQ | ETF | 28.68 | 28.7 | 28.61 | 28.64 | 1420400.0 |
| 2003-05-16 13:30:00 | QQQ | ETF | 28.65 | 28.78 | 28.62 | 28.76 | 1728900.0 |
| 2003-05-16 14:00:00 | QQQ | ETF | 28.77 | 28.84 | 28.75 | 28.83 | 3135700.0 |
| 2003-05-16 14:30:00 | QQQ | ETF | 28.83 | 28.85 | 28.72 | 28.78 | 9659000.0 |
| 2003-05-16 15:00:00 | QQQ | ETF | 28.78 | 28.82 | 28.67 | 28.71 | 2671900.0 |
| 2003-05-16 15:30:00 | QQQ | ETF | 28.71 | 28.75 | 28.63 | 28.66 | 5564500.0 |
| 2003-05-16 16:00:00 | QQQ | ETF | 28.66 | 28.75 | 28.65 | 28.7 | 3145000.0 |
| 2003-05-16 16:30:00 | QQQ | ETF | 28.69 | 28.73 | 28.68 | 28.69 | 29100.0 |
| 2003-05-16 17:00:00 | QQQ | ETF | 28.69 | 28.71 | 28.64 | 28.66 | 65900.0 |
| 2003-05-16 17:30:00 | QQQ | ETF | 28.66 | 28.68 | 28.65 | 28.67 | 23900.0 |
| 2003-05-16 18:00:00 | QQQ | ETF | 28.67 | 28.74 | 28.67 | 28.74 | 27800.0 |
| 2003-05-16 18:30:00 | QQQ | ETF | 28.75 | 28.75 | 28.69 | 28.69 | 13000.0 |
| 2003-05-16 19:00:00 | QQQ | ETF | 28.72 | 28.72 | 28.7 | 28.72 | 2700.0 |
| 2003-05-16 19:30:00 | QQQ | ETF | 28.72 | 28.74 | 28.71 | 28.71 | 7600.0 |
| 2003-05-16 09:30:00 | IWM | ETF | 42.055 | 42.09 | 41.91 | 42.025 | 544600.0 |
| 2003-05-16 10:00:00 | IWM | ETF | 42.005 | 42.005 | 41.785 | 41.785 | 523800.0 |
| 2003-05-16 10:30:00 | IWM | ETF | 41.795 | 41.85 | 41.765 | 41.84 | 578400.0 |
| 2003-05-16 11:00:00 | IWM | ETF | 41.865 | 41.885 | 41.83 | 41.865 | 71800.0 |
> showing 50 of 641 rows — these rows as CSV