PREVIEW / etf_30min / 2010-02-02
file: by_date/etf_30min/2010/2010-02-02.parquet size: 244 KB rows: 8,204
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-02 04:00:00 | SPY | ETF | 108.93 | 109.08 | 108.87 | 109.08 | 1500.0 |
| 2010-02-02 04:30:00 | SPY | ETF | 109.13 | 109.22 | 109.13 | 109.22 | 800.0 |
| 2010-02-02 05:00:00 | SPY | ETF | 109.24 | 109.52 | 109.24 | 109.44 | 5700.0 |
| 2010-02-02 05:30:00 | SPY | ETF | 109.54 | 109.61 | 109.54 | 109.61 | 1000.0 |
| 2010-02-02 06:00:00 | SPY | ETF | 109.53 | 109.53 | 109.32 | 109.35 | 22050.0 |
| 2010-02-02 06:30:00 | SPY | ETF | 109.44 | 109.5 | 109.3 | 109.34 | 36050.0 |
| 2010-02-02 07:00:00 | SPY | ETF | 109.34 | 109.42 | 109.33 | 109.37 | 90999.0 |
| 2010-02-02 07:30:00 | SPY | ETF | 109.37 | 109.56 | 109.36 | 109.41 | 308595.0 |
| 2010-02-02 08:00:00 | SPY | ETF | 109.39 | 109.5 | 109.23 | 109.33 | 1875354.0 |
| 2010-02-02 08:30:00 | SPY | ETF | 109.32 | 109.34 | 109.11 | 109.17 | 1564542.0 |
| 2010-02-02 09:00:00 | SPY | ETF | 109.15 | 109.38 | 109.13 | 109.27 | 1659410.0 |
| 2010-02-02 09:30:00 | SPY | ETF | 109.26 | 109.36 | 108.93 | 109.07 | 23585289.0 |
| 2010-02-02 10:00:00 | SPY | ETF | 109.07 | 109.75 | 108.88 | 109.71 | 22045736.0 |
| 2010-02-02 10:30:00 | SPY | ETF | 109.71 | 109.99 | 109.705 | 109.85 | 18391287.0 |
| 2010-02-02 11:00:00 | SPY | ETF | 109.86 | 109.88 | 109.57 | 109.81 | 12421010.0 |
| 2010-02-02 11:30:00 | SPY | ETF | 109.82 | 109.94 | 109.71 | 109.83 | 8010653.0 |
| 2010-02-02 12:00:00 | SPY | ETF | 109.83 | 110.15 | 109.74 | 110.14 | 11378624.0 |
| 2010-02-02 12:30:00 | SPY | ETF | 110.15 | 110.15 | 109.85 | 110.15 | 7539834.0 |
| 2010-02-02 13:00:00 | SPY | ETF | 110.14 | 110.21 | 109.95 | 110.2 | 8147752.0 |
| 2010-02-02 13:30:00 | SPY | ETF | 110.2 | 110.42 | 110.15 | 110.34 | 12172025.0 |
| 2010-02-02 14:00:00 | SPY | ETF | 110.35 | 110.38 | 110.08 | 110.2399 | 9510481.0 |
| 2010-02-02 14:30:00 | SPY | ETF | 110.235 | 110.29 | 110.01 | 110.24 | 13811803.0 |
| 2010-02-02 15:00:00 | SPY | ETF | 110.24 | 110.59 | 110.11 | 110.39 | 19757291.0 |
| 2010-02-02 15:30:00 | SPY | ETF | 110.382 | 110.51 | 110.28 | 110.4 | 23595379.0 |
| 2010-02-02 16:00:00 | SPY | ETF | 110.4 | 110.51 | 109.15 | 110.23 | 6475933.0 |
| 2010-02-02 16:30:00 | SPY | ETF | 110.19 | 110.41 | 109.032 | 110.34 | 11881783.0 |
| 2010-02-02 17:00:00 | SPY | ETF | 110.31 | 110.33 | 109.0321 | 110.29 | 1039729.0 |
| 2010-02-02 17:30:00 | SPY | ETF | 110.3 | 110.31 | 110.25 | 110.3 | 25163.0 |
| 2010-02-02 18:00:00 | SPY | ETF | 110.28 | 110.41 | 110.28 | 110.4 | 68001.0 |
| 2010-02-02 18:30:00 | SPY | ETF | 110.39 | 110.39 | 110.33 | 110.33 | 7580.0 |
| 2010-02-02 19:00:00 | SPY | ETF | 110.33 | 110.33 | 110.27 | 110.31 | 10238.0 |
| 2010-02-02 19:30:00 | SPY | ETF | 110.32 | 110.34 | 110.21 | 110.21 | 40032.0 |
| 2010-02-02 04:00:00 | QQQ | ETF | 43.24 | 43.24 | 43.24 | 43.24 | 200.0 |
| 2010-02-02 05:00:00 | QQQ | ETF | 43.33 | 43.38 | 43.33 | 43.38 | 200.0 |
| 2010-02-02 05:30:00 | QQQ | ETF | 43.39 | 43.39 | 43.39 | 43.39 | 195.0 |
| 2010-02-02 06:00:00 | QQQ | ETF | 43.34 | 43.35 | 43.31 | 43.31 | 38000.0 |
| 2010-02-02 06:30:00 | QQQ | ETF | 43.36 | 43.36 | 43.29 | 43.31 | 10187.0 |
| 2010-02-02 07:00:00 | QQQ | ETF | 43.36 | 43.36 | 43.32 | 43.33 | 8100.0 |
| 2010-02-02 07:30:00 | QQQ | ETF | 43.33 | 43.4 | 43.33 | 43.35 | 68144.0 |
| 2010-02-02 08:00:00 | QQQ | ETF | 43.36 | 43.36 | 43.26 | 43.3 | 277940.0 |
| 2010-02-02 08:30:00 | QQQ | ETF | 43.3 | 43.31 | 43.22 | 43.24 | 205565.0 |
| 2010-02-02 09:00:00 | QQQ | ETF | 43.23 | 43.37 | 43.23 | 43.31 | 560294.0 |
| 2010-02-02 09:30:00 | QQQ | ETF | 43.31 | 43.3902 | 43.15 | 43.18 | 13256858.0 |
| 2010-02-02 10:00:00 | QQQ | ETF | 43.18 | 43.47 | 43.03 | 43.44 | 16218474.0 |
| 2010-02-02 10:30:00 | QQQ | ETF | 43.45 | 43.52 | 43.33 | 43.375 | 9671790.0 |
| 2010-02-02 11:00:00 | QQQ | ETF | 43.38 | 43.45 | 43.28 | 43.43 | 5905676.0 |
| 2010-02-02 11:30:00 | QQQ | ETF | 43.425 | 43.51 | 43.4 | 43.4697 | 4761125.0 |
| 2010-02-02 12:00:00 | QQQ | ETF | 43.4699 | 43.56 | 43.42 | 43.55 | 4870229.0 |
| 2010-02-02 12:30:00 | QQQ | ETF | 43.549 | 43.5578 | 43.49 | 43.5501 | 2691420.0 |
| 2010-02-02 13:00:00 | QQQ | ETF | 43.56 | 43.57 | 43.42 | 43.505 | 5168603.0 |
> showing 50 of 8,204 rows — these rows as CSV