PREVIEW / etf_30min / 2007-10-12
file: by_date/etf_30min/2007/2007-10-12.parquet size: 122 KB rows: 4,673
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-12 04:00:00 | SPY | ETF | 155.01 | 155.01 | 155.01 | 155.01 | 100.0 |
| 2007-10-12 04:30:00 | SPY | ETF | 155.04 | 155.04 | 155.04 | 155.04 | 3000.0 |
| 2007-10-12 05:00:00 | SPY | ETF | 155.24 | 155.24 | 155.24 | 155.24 | 200.0 |
| 2007-10-12 06:30:00 | SPY | ETF | 155.22 | 155.27 | 155.2 | 155.27 | 150000.0 |
| 2007-10-12 07:00:00 | SPY | ETF | 155.29 | 155.31 | 154.99 | 155.09 | 291300.0 |
| 2007-10-12 07:30:00 | SPY | ETF | 155.1 | 155.16 | 155.05 | 155.1 | 42600.0 |
| 2007-10-12 08:00:00 | SPY | ETF | 155.09 | 155.34 | 155.05 | 155.34 | 873800.0 |
| 2007-10-12 08:30:00 | SPY | ETF | 155.32 | 155.59 | 155.23 | 155.52 | 3951400.0 |
| 2007-10-12 09:00:00 | SPY | ETF | 155.55 | 155.59 | 155.43 | 155.47 | 517400.0 |
| 2007-10-12 09:30:00 | SPY | ETF | 155.46 | 155.66 | 155.27 | 155.6 | 12727474.0 |
| 2007-10-12 10:00:00 | SPY | ETF | 155.61 | 155.97 | 155.33 | 155.89 | 12919848.0 |
| 2007-10-12 10:30:00 | SPY | ETF | 155.88 | 155.95 | 155.61 | 155.75 | 6388462.0 |
| 2007-10-12 11:00:00 | SPY | ETF | 155.75 | 156.16 | 155.74 | 156.13 | 9739321.0 |
| 2007-10-12 11:30:00 | SPY | ETF | 156.13 | 156.18 | 155.95 | 155.96 | 5029074.0 |
| 2007-10-12 12:00:00 | SPY | ETF | 155.96 | 156.23 | 155.83 | 156.11 | 4440225.0 |
| 2007-10-12 12:30:00 | SPY | ETF | 156.11 | 156.2 | 155.91 | 156.13 | 5756960.0 |
| 2007-10-12 13:00:00 | SPY | ETF | 156.12 | 156.14 | 155.64 | 155.82 | 6207904.0 |
| 2007-10-12 13:30:00 | SPY | ETF | 155.82 | 156.13 | 155.75 | 155.91 | 4848693.0 |
| 2007-10-12 14:00:00 | SPY | ETF | 155.92 | 156.2 | 155.9 | 155.93 | 6101513.0 |
| 2007-10-12 14:30:00 | SPY | ETF | 155.94 | 156.19 | 155.91 | 155.95 | 4143406.0 |
| 2007-10-12 15:00:00 | SPY | ETF | 155.95 | 156.0 | 155.61 | 155.65 | 11638404.0 |
| 2007-10-12 15:30:00 | SPY | ETF | 155.63 | 156.1 | 155.61 | 156.05 | 15816707.0 |
| 2007-10-12 16:00:00 | SPY | ETF | 156.07 | 156.39 | 155.15 | 156.39 | 5854500.0 |
| 2007-10-12 16:30:00 | SPY | ETF | 156.4 | 156.6 | 155.33 | 156.56 | 3780800.0 |
| 2007-10-12 17:00:00 | SPY | ETF | 156.53 | 156.59 | 156.5 | 156.56 | 18400.0 |
| 2007-10-12 17:30:00 | SPY | ETF | 156.54 | 156.55 | 156.54 | 156.55 | 4300.0 |
| 2007-10-12 18:00:00 | SPY | ETF | 156.49 | 156.56 | 156.49 | 156.53 | 5500.0 |
| 2007-10-12 18:30:00 | SPY | ETF | 156.53 | 156.53 | 156.43 | 156.43 | 5500.0 |
| 2007-10-12 19:00:00 | SPY | ETF | 156.45 | 156.45 | 156.44 | 156.45 | 400.0 |
| 2007-10-12 19:30:00 | SPY | ETF | 156.44 | 156.44 | 156.42 | 156.43 | 1400.0 |
| 2007-10-12 05:00:00 | QQQ | ETF | 52.69 | 52.69 | 52.69 | 52.69 | 100.0 |
| 2007-10-12 06:30:00 | QQQ | ETF | 52.73 | 52.73 | 52.73 | 52.73 | 10000.0 |
| 2007-10-12 07:00:00 | QQQ | ETF | 52.72 | 52.73 | 52.67 | 52.67 | 136762.0 |
| 2007-10-12 07:30:00 | QQQ | ETF | 52.66 | 52.7 | 52.66 | 52.66 | 57022.0 |
| 2007-10-12 08:00:00 | QQQ | ETF | 52.65 | 52.76 | 52.65 | 52.74 | 257041.0 |
| 2007-10-12 08:30:00 | QQQ | ETF | 52.74 | 52.95 | 52.74 | 52.94 | 2316868.0 |
| 2007-10-12 09:00:00 | QQQ | ETF | 52.94 | 52.99 | 52.88 | 52.9 | 1072549.0 |
| 2007-10-12 09:30:00 | QQQ | ETF | 52.91 | 53.12 | 52.8 | 53.08 | 17300095.0 |
| 2007-10-12 10:00:00 | QQQ | ETF | 53.08 | 53.25 | 52.96 | 53.222 | 22174084.0 |
| 2007-10-12 10:30:00 | QQQ | ETF | 53.24 | 53.29 | 53.12 | 53.191 | 8951882.0 |
| 2007-10-12 11:00:00 | QQQ | ETF | 53.2 | 53.41 | 53.2 | 53.361 | 9183825.0 |
| 2007-10-12 11:30:00 | QQQ | ETF | 53.37 | 53.39 | 53.3 | 53.32 | 7873684.0 |
| 2007-10-12 12:00:00 | QQQ | ETF | 53.32 | 53.4 | 53.2 | 53.37 | 6856935.0 |
| 2007-10-12 12:30:00 | QQQ | ETF | 53.37 | 53.47 | 53.33 | 53.45 | 5180180.0 |
| 2007-10-12 13:00:00 | QQQ | ETF | 53.449 | 53.45 | 53.17 | 53.24 | 7560618.0 |
| 2007-10-12 13:30:00 | QQQ | ETF | 53.24 | 53.38 | 53.19 | 53.32 | 6043391.0 |
| 2007-10-12 14:00:00 | QQQ | ETF | 53.312 | 53.5 | 53.312 | 53.41 | 6563429.0 |
| 2007-10-12 14:30:00 | QQQ | ETF | 53.41 | 53.52 | 53.41 | 53.42 | 4452955.0 |
| 2007-10-12 15:00:00 | QQQ | ETF | 53.41 | 53.44 | 53.22 | 53.23 | 7175464.0 |
| 2007-10-12 15:30:00 | QQQ | ETF | 53.23 | 53.54 | 53.22 | 53.53 | 10712485.0 |
> showing 50 of 4,673 rows — these rows as CSV