PREVIEW / etf_30min / 2008-03-12
file: by_date/etf_30min/2008/2008-03-12.parquet size: 159 KB rows: 5,721
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-03-12 04:30:00 | SPY | ETF | 132.41 | 132.41 | 132.41 | 132.41 | 200.0 |
| 2008-03-12 05:30:00 | SPY | ETF | 133.03 | 133.04 | 133.03 | 133.04 | 6300.0 |
| 2008-03-12 06:00:00 | SPY | ETF | 133.18 | 133.36 | 133.15 | 133.15 | 46000.0 |
| 2008-03-12 06:30:00 | SPY | ETF | 133.02 | 133.05 | 132.84 | 132.85 | 99100.0 |
| 2008-03-12 07:00:00 | SPY | ETF | 132.82 | 133.03 | 132.71 | 132.96 | 202300.0 |
| 2008-03-12 07:30:00 | SPY | ETF | 132.92 | 132.92 | 132.51 | 132.72 | 752700.0 |
| 2008-03-12 08:00:00 | SPY | ETF | 132.7 | 132.97 | 132.34 | 132.49 | 2644900.0 |
| 2008-03-12 08:30:00 | SPY | ETF | 132.51 | 132.69 | 132.33 | 132.49 | 1623100.0 |
| 2008-03-12 09:00:00 | SPY | ETF | 132.48 | 132.79 | 132.43 | 132.75 | 2659600.0 |
| 2008-03-12 09:30:00 | SPY | ETF | 132.73 | 132.98 | 132.15 | 132.4 | 20036409.0 |
| 2008-03-12 10:00:00 | SPY | ETF | 132.4 | 132.53 | 131.93 | 132.3101 | 15105131.0 |
| 2008-03-12 10:30:00 | SPY | ETF | 132.32 | 133.35 | 132.2 | 132.89 | 18804117.0 |
| 2008-03-12 11:00:00 | SPY | ETF | 132.89 | 133.77 | 132.89 | 133.41 | 26641084.0 |
| 2008-03-12 11:30:00 | SPY | ETF | 133.41 | 133.5 | 132.88 | 132.98 | 12617423.0 |
| 2008-03-12 12:00:00 | SPY | ETF | 132.99 | 133.15 | 132.7 | 132.79 | 9923244.0 |
| 2008-03-12 12:30:00 | SPY | ETF | 132.78 | 133.01 | 132.41 | 132.64 | 11323792.0 |
| 2008-03-12 13:00:00 | SPY | ETF | 132.64 | 132.95 | 132.58 | 132.78 | 7330368.0 |
| 2008-03-12 13:30:00 | SPY | ETF | 132.77 | 132.85 | 132.13 | 132.28 | 14587774.0 |
| 2008-03-12 14:00:00 | SPY | ETF | 132.27 | 132.5 | 132.02 | 132.24 | 15465332.0 |
| 2008-03-12 14:30:00 | SPY | ETF | 132.23 | 132.74 | 132.11 | 132.31 | 10751623.0 |
| 2008-03-12 15:00:00 | SPY | ETF | 132.31 | 132.74 | 131.81 | 131.85 | 15282577.0 |
| 2008-03-12 15:30:00 | SPY | ETF | 131.86 | 131.96 | 131.16 | 131.31 | 31420938.0 |
| 2008-03-12 16:00:00 | SPY | ETF | 131.3499 | 133.0 | 131.19 | 131.3 | 3140800.0 |
| 2008-03-12 16:30:00 | SPY | ETF | 131.34 | 132.47 | 131.32 | 131.35 | 2181200.0 |
| 2008-03-12 17:00:00 | SPY | ETF | 131.35 | 131.37 | 131.21 | 131.32 | 1571600.0 |
| 2008-03-12 17:30:00 | SPY | ETF | 131.27 | 131.29 | 131.13 | 131.21 | 513400.0 |
| 2008-03-12 18:00:00 | SPY | ETF | 131.18 | 131.18 | 130.87 | 131.0 | 134900.0 |
| 2008-03-12 18:30:00 | SPY | ETF | 130.99 | 131.03 | 130.84 | 130.87 | 47500.0 |
| 2008-03-12 19:00:00 | SPY | ETF | 130.87 | 130.93 | 130.86 | 130.92 | 40200.0 |
| 2008-03-12 19:30:00 | SPY | ETF | 130.92 | 130.93 | 130.86 | 130.89 | 12100.0 |
| 2008-03-12 04:00:00 | QQQ | ETF | 42.9 | 42.9 | 42.9 | 42.9 | 8000.0 |
| 2008-03-12 06:00:00 | QQQ | ETF | 43.25 | 43.25 | 43.23 | 43.23 | 700.0 |
| 2008-03-12 06:30:00 | QQQ | ETF | 43.16 | 43.16 | 43.11 | 43.11 | 800.0 |
| 2008-03-12 07:00:00 | QQQ | ETF | 43.06 | 43.11 | 43.05 | 43.08 | 28892.0 |
| 2008-03-12 07:30:00 | QQQ | ETF | 43.06 | 43.07 | 42.95 | 43.07 | 516836.0 |
| 2008-03-12 08:00:00 | QQQ | ETF | 43.01 | 43.06 | 42.9 | 42.96 | 2204933.0 |
| 2008-03-12 08:30:00 | QQQ | ETF | 42.96 | 43.0 | 42.92 | 42.95 | 734766.0 |
| 2008-03-12 09:00:00 | QQQ | ETF | 42.94 | 43.05 | 42.92 | 43.02 | 1627664.0 |
| 2008-03-12 09:30:00 | QQQ | ETF | 43.02 | 43.03 | 42.77 | 42.8704 | 13704574.0 |
| 2008-03-12 10:00:00 | QQQ | ETF | 42.873 | 42.89 | 42.73 | 42.84 | 9219099.0 |
| 2008-03-12 10:30:00 | QQQ | ETF | 42.84 | 43.22 | 42.83 | 43.14 | 17499910.0 |
| 2008-03-12 11:00:00 | QQQ | ETF | 43.13 | 43.44 | 43.13 | 43.33 | 15105220.0 |
| 2008-03-12 11:30:00 | QQQ | ETF | 43.33 | 43.35 | 43.08 | 43.1315 | 8974688.0 |
| 2008-03-12 12:00:00 | QQQ | ETF | 43.14 | 43.24 | 43.08 | 43.1 | 3732866.0 |
| 2008-03-12 12:30:00 | QQQ | ETF | 43.11 | 43.27 | 43.09 | 43.14 | 8054243.0 |
| 2008-03-12 13:00:00 | QQQ | ETF | 43.15 | 43.29 | 43.12 | 43.23 | 4002921.0 |
| 2008-03-12 13:30:00 | QQQ | ETF | 43.23 | 43.23 | 43.05 | 43.09 | 9337773.0 |
| 2008-03-12 14:00:00 | QQQ | ETF | 43.09 | 43.15 | 42.97 | 43.0599 | 8357942.0 |
| 2008-03-12 14:30:00 | QQQ | ETF | 43.05 | 43.23 | 43.02 | 43.15 | 6887605.0 |
| 2008-03-12 15:00:00 | QQQ | ETF | 43.15 | 43.17 | 42.96 | 42.97 | 7906555.0 |
> showing 50 of 5,721 rows — these rows as CSV