PREVIEW / etf_30min / 2008-04-11
file: by_date/etf_30min/2008/2008-04-11.parquet size: 155 KB rows: 5,649
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-11 04:00:00 | SPY | ETF | 136.52 | 136.52 | 136.52 | 136.52 | 1000.0 |
| 2008-04-11 05:00:00 | SPY | ETF | 136.43 | 136.45 | 136.43 | 136.45 | 200.0 |
| 2008-04-11 05:30:00 | SPY | ETF | 136.39 | 136.41 | 136.36 | 136.41 | 5300.0 |
| 2008-04-11 06:00:00 | SPY | ETF | 136.43 | 136.49 | 136.41 | 136.47 | 15600.0 |
| 2008-04-11 06:30:00 | SPY | ETF | 136.44 | 136.44 | 135.2 | 135.28 | 709500.0 |
| 2008-04-11 07:00:00 | SPY | ETF | 135.35 | 135.35 | 134.65 | 134.81 | 1439300.0 |
| 2008-04-11 07:30:00 | SPY | ETF | 134.82 | 135.2 | 134.78 | 134.96 | 1047400.0 |
| 2008-04-11 08:00:00 | SPY | ETF | 134.96 | 135.73 | 134.45 | 134.48 | 6296742.0 |
| 2008-04-11 08:30:00 | SPY | ETF | 134.5 | 134.7 | 134.36 | 134.55 | 1581264.0 |
| 2008-04-11 09:00:00 | SPY | ETF | 134.56 | 134.63 | 134.37 | 134.47 | 1525489.0 |
| 2008-04-11 09:30:00 | SPY | ETF | 134.48 | 134.7 | 134.29 | 134.4 | 27648529.0 |
| 2008-04-11 10:00:00 | SPY | ETF | 134.41 | 134.71 | 134.151 | 134.42 | 23272210.0 |
| 2008-04-11 10:30:00 | SPY | ETF | 134.42 | 135.12 | 134.37 | 134.74 | 17944746.0 |
| 2008-04-11 11:00:00 | SPY | ETF | 134.748 | 134.748 | 134.37 | 134.49 | 13693158.0 |
| 2008-04-11 11:30:00 | SPY | ETF | 134.51 | 134.77 | 134.41 | 134.63 | 8316708.0 |
| 2008-04-11 12:00:00 | SPY | ETF | 134.63 | 134.65 | 133.91 | 133.97 | 13860437.0 |
| 2008-04-11 12:30:00 | SPY | ETF | 133.97 | 134.21 | 133.95 | 134.16 | 7345873.0 |
| 2008-04-11 13:00:00 | SPY | ETF | 134.15 | 134.28 | 133.98 | 134.02 | 7776856.0 |
| 2008-04-11 13:30:00 | SPY | ETF | 134.02 | 134.1 | 133.65 | 133.86 | 12451273.0 |
| 2008-04-11 14:00:00 | SPY | ETF | 133.87 | 133.9 | 133.36 | 133.64 | 13986466.0 |
| 2008-04-11 14:30:00 | SPY | ETF | 133.63 | 133.85 | 133.46 | 133.6 | 8597914.0 |
| 2008-04-11 15:00:00 | SPY | ETF | 133.6 | 134.1 | 133.25 | 133.62 | 15004358.0 |
| 2008-04-11 15:30:00 | SPY | ETF | 133.63 | 135.9837 | 133.01 | 133.28 | 24727837.0 |
| 2008-04-11 16:00:00 | SPY | ETF | 133.35 | 133.4 | 133.17 | 133.23 | 6911400.0 |
| 2008-04-11 16:30:00 | SPY | ETF | 133.21 | 133.38 | 133.15 | 133.22 | 5705900.0 |
| 2008-04-11 17:00:00 | SPY | ETF | 133.22 | 133.3 | 133.17 | 133.2 | 20700.0 |
| 2008-04-11 17:30:00 | SPY | ETF | 133.2 | 133.3 | 133.2 | 133.21 | 3100.0 |
| 2008-04-11 18:00:00 | SPY | ETF | 133.29 | 133.33 | 133.29 | 133.32 | 18800.0 |
| 2008-04-11 18:30:00 | SPY | ETF | 133.31 | 133.9 | 133.22 | 133.28 | 52700.0 |
| 2008-04-11 19:00:00 | SPY | ETF | 133.25 | 133.25 | 133.22 | 133.22 | 2600.0 |
| 2008-04-11 19:30:00 | SPY | ETF | 133.25 | 133.31 | 133.24 | 133.31 | 8000.0 |
| 2008-04-11 04:00:00 | QQQ | ETF | 45.78 | 45.78 | 45.78 | 45.78 | 200.0 |
| 2008-04-11 06:00:00 | QQQ | ETF | 45.8 | 45.8 | 45.8 | 45.8 | 200.0 |
| 2008-04-11 06:30:00 | QQQ | ETF | 45.48 | 45.49 | 45.29 | 45.29 | 8068.0 |
| 2008-04-11 07:00:00 | QQQ | ETF | 45.37 | 45.37 | 45.19 | 45.21 | 340477.0 |
| 2008-04-11 07:30:00 | QQQ | ETF | 45.2 | 45.38 | 45.2 | 45.38 | 441287.0 |
| 2008-04-11 08:00:00 | QQQ | ETF | 45.37 | 45.4 | 45.12 | 45.13 | 2416142.0 |
| 2008-04-11 08:30:00 | QQQ | ETF | 45.12 | 45.13 | 44.95 | 45.0 | 1320005.0 |
| 2008-04-11 09:00:00 | QQQ | ETF | 45.01 | 45.04 | 44.98 | 45.02 | 1090591.0 |
| 2008-04-11 09:30:00 | QQQ | ETF | 45.01 | 45.1 | 44.94 | 44.97 | 15891542.0 |
| 2008-04-11 10:00:00 | QQQ | ETF | 44.96 | 45.02 | 44.75 | 44.868 | 15140276.0 |
| 2008-04-11 10:30:00 | QQQ | ETF | 44.87 | 44.98 | 44.83 | 44.89 | 6761010.0 |
| 2008-04-11 11:00:00 | QQQ | ETF | 44.89 | 44.93 | 44.79 | 44.801 | 6879091.0 |
| 2008-04-11 11:30:00 | QQQ | ETF | 44.81 | 44.94 | 44.78 | 44.91 | 4026596.0 |
| 2008-04-11 12:00:00 | QQQ | ETF | 44.91 | 44.92 | 44.61 | 44.63 | 7349401.0 |
| 2008-04-11 12:30:00 | QQQ | ETF | 44.63 | 44.71 | 44.6 | 44.69 | 4238371.0 |
| 2008-04-11 13:00:00 | QQQ | ETF | 44.6801 | 44.7395 | 44.58 | 44.59 | 4285274.0 |
| 2008-04-11 13:30:00 | QQQ | ETF | 44.59 | 44.59 | 44.4 | 44.4799 | 7955322.0 |
| 2008-04-11 14:00:00 | QQQ | ETF | 44.48 | 44.5 | 44.29 | 44.351 | 7287405.0 |
| 2008-04-11 14:30:00 | QQQ | ETF | 44.35 | 44.4 | 44.24 | 44.32 | 5975658.0 |
> showing 50 of 5,649 rows — these rows as CSV