PREVIEW / etf_30min / 2004-12-08
file: by_date/etf_30min/2004/2004-12-08.parquet size: 40 KB rows: 1,333
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-12-08 08:00:00 | SPY | ETF | 118.09 | 118.2 | 118.07 | 118.1 | 21100.0 |
| 2004-12-08 08:30:00 | SPY | ETF | 118.14 | 118.24 | 118.08 | 118.17 | 163500.0 |
| 2004-12-08 09:00:00 | SPY | ETF | 118.17 | 118.29 | 118.17 | 118.2 | 25500.0 |
| 2004-12-08 09:30:00 | SPY | ETF | 118.21 | 118.37 | 118.01 | 118.28 | 6828300.0 |
| 2004-12-08 10:00:00 | SPY | ETF | 118.28 | 118.39 | 118.21 | 118.37 | 3261300.0 |
| 2004-12-08 10:30:00 | SPY | ETF | 118.37 | 118.54 | 118.18 | 118.25 | 5598500.0 |
| 2004-12-08 11:00:00 | SPY | ETF | 118.24 | 118.44 | 118.13 | 118.44 | 2766800.0 |
| 2004-12-08 11:30:00 | SPY | ETF | 118.41 | 118.66 | 118.36 | 118.48 | 2454900.0 |
| 2004-12-08 12:00:00 | SPY | ETF | 118.48 | 118.65 | 118.37 | 118.54 | 3635500.0 |
| 2004-12-08 12:30:00 | SPY | ETF | 118.54 | 118.66 | 118.44 | 118.58 | 1917800.0 |
| 2004-12-08 13:00:00 | SPY | ETF | 118.59 | 118.81 | 118.55 | 118.78 | 2514200.0 |
| 2004-12-08 13:30:00 | SPY | ETF | 118.78 | 118.79 | 118.6 | 118.73 | 1374100.0 |
| 2004-12-08 14:00:00 | SPY | ETF | 118.74 | 118.82 | 118.47 | 118.53 | 2282000.0 |
| 2004-12-08 14:30:00 | SPY | ETF | 118.55 | 118.72 | 118.47 | 118.55 | 1768600.0 |
| 2004-12-08 15:00:00 | SPY | ETF | 118.55 | 118.63 | 118.37 | 118.47 | 2559800.0 |
| 2004-12-08 15:30:00 | SPY | ETF | 118.47 | 118.72 | 118.42 | 118.62 | 2495800.0 |
| 2004-12-08 16:00:00 | SPY | ETF | 118.62 | 118.8 | 118.58 | 118.75 | 2026600.0 |
| 2004-12-08 16:30:00 | SPY | ETF | 118.73 | 118.74 | 118.48 | 118.48 | 135100.0 |
| 2004-12-08 17:00:00 | SPY | ETF | 118.5 | 118.55 | 118.45 | 118.53 | 61100.0 |
| 2004-12-08 17:30:00 | SPY | ETF | 118.6 | 118.6 | 118.59 | 118.59 | 3900.0 |
| 2004-12-08 18:00:00 | SPY | ETF | 118.57 | 118.6 | 118.56 | 118.6 | 1500.0 |
| 2004-12-08 18:30:00 | SPY | ETF | 118.56 | 118.56 | 118.56 | 118.56 | 400.0 |
| 2004-12-08 19:00:00 | SPY | ETF | 118.55 | 118.55 | 118.54 | 118.54 | 1100.0 |
| 2004-12-08 19:30:00 | SPY | ETF | 118.6 | 118.6 | 118.6 | 118.6 | 2700.0 |
| 2004-12-08 08:00:00 | QQQ | ETF | 39.56 | 39.65 | 39.56 | 39.6 | 929521.0 |
| 2004-12-08 08:30:00 | QQQ | ETF | 39.6 | 39.67 | 39.598 | 39.65 | 317810.0 |
| 2004-12-08 09:00:00 | QQQ | ETF | 39.66 | 39.67 | 39.6 | 39.66 | 397684.0 |
| 2004-12-08 09:30:00 | QQQ | ETF | 39.66 | 39.72 | 39.5 | 39.685 | 12477167.0 |
| 2004-12-08 10:00:00 | QQQ | ETF | 39.69 | 39.76 | 39.63 | 39.721 | 7427476.0 |
| 2004-12-08 10:30:00 | QQQ | ETF | 39.72 | 39.85 | 39.63 | 39.72 | 9251097.0 |
| 2004-12-08 11:00:00 | QQQ | ETF | 39.707 | 39.76 | 39.63 | 39.75 | 4815049.0 |
| 2004-12-08 11:30:00 | QQQ | ETF | 39.75 | 39.91 | 39.71 | 39.83 | 5937243.0 |
| 2004-12-08 12:00:00 | QQQ | ETF | 39.83 | 39.889 | 39.785 | 39.812 | 6219597.0 |
| 2004-12-08 12:30:00 | QQQ | ETF | 39.81 | 39.9 | 39.75 | 39.89 | 4135307.0 |
| 2004-12-08 13:00:00 | QQQ | ETF | 39.89 | 39.98 | 39.85 | 39.941 | 4907902.0 |
| 2004-12-08 13:30:00 | QQQ | ETF | 39.944 | 39.957 | 39.82 | 39.89 | 4803374.0 |
| 2004-12-08 14:00:00 | QQQ | ETF | 39.882 | 39.92 | 39.76 | 39.81 | 5245066.0 |
| 2004-12-08 14:30:00 | QQQ | ETF | 39.8201 | 39.9 | 39.76 | 39.79 | 3789116.0 |
| 2004-12-08 15:00:00 | QQQ | ETF | 39.79 | 39.85 | 39.71 | 39.74 | 5525656.0 |
| 2004-12-08 15:30:00 | QQQ | ETF | 39.74 | 39.86 | 39.71 | 39.811 | 7122725.0 |
| 2004-12-08 16:00:00 | QQQ | ETF | 39.818 | 39.86 | 39.73 | 39.74 | 1653089.0 |
| 2004-12-08 16:30:00 | QQQ | ETF | 39.79 | 39.81 | 39.57 | 39.61 | 5257288.0 |
| 2004-12-08 17:00:00 | QQQ | ETF | 39.6 | 39.64 | 39.6 | 39.63 | 236465.0 |
| 2004-12-08 17:30:00 | QQQ | ETF | 39.66 | 39.68 | 39.65 | 39.67 | 57845.0 |
| 2004-12-08 18:00:00 | QQQ | ETF | 39.67 | 39.68 | 39.63 | 39.68 | 56968.0 |
| 2004-12-08 08:00:00 | IWM | ETF | 62.52 | 62.52 | 62.44 | 62.44 | 11800.0 |
| 2004-12-08 08:30:00 | IWM | ETF | 62.44 | 62.44 | 62.44 | 62.44 | 4800.0 |
| 2004-12-08 09:00:00 | IWM | ETF | 62.49 | 62.5 | 62.49 | 62.5 | 22800.0 |
| 2004-12-08 09:30:00 | IWM | ETF | 62.5 | 62.635 | 62.3 | 62.435 | 1632200.0 |
| 2004-12-08 10:00:00 | IWM | ETF | 62.455 | 62.61 | 62.445 | 62.6 | 1263800.0 |
> showing 50 of 1,333 rows — these rows as CSV