PREVIEW / etf_30min / 2003-10-07
file: by_date/etf_30min/2003/2003-10-07.parquet size: 25 KB rows: 752
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-07 08:00:00 | SPY | ETF | 103.45 | 103.45 | 103.31 | 103.32 | 26100.0 |
| 2003-10-07 08:30:00 | SPY | ETF | 103.34 | 103.35 | 103.25 | 103.29 | 11500.0 |
| 2003-10-07 09:00:00 | SPY | ETF | 103.31 | 103.31 | 103.2 | 103.24 | 31100.0 |
| 2003-10-07 09:30:00 | SPY | ETF | 103.26 | 103.37 | 103.05 | 103.26 | 4786700.0 |
| 2003-10-07 10:00:00 | SPY | ETF | 103.27 | 103.3 | 102.91 | 103.22 | 3358900.0 |
| 2003-10-07 10:30:00 | SPY | ETF | 103.24 | 103.49 | 103.15 | 103.34 | 2213000.0 |
| 2003-10-07 11:00:00 | SPY | ETF | 103.33 | 103.82 | 103.21 | 103.65 | 3453700.0 |
| 2003-10-07 11:30:00 | SPY | ETF | 103.655 | 103.84 | 103.63 | 103.69 | 1675100.0 |
| 2003-10-07 12:00:00 | SPY | ETF | 103.66 | 103.82 | 103.54 | 103.72 | 1157000.0 |
| 2003-10-07 12:30:00 | SPY | ETF | 103.73 | 103.81 | 103.387 | 103.51 | 1257400.0 |
| 2003-10-07 13:00:00 | SPY | ETF | 103.508 | 103.58 | 103.36 | 103.49 | 787700.0 |
| 2003-10-07 13:30:00 | SPY | ETF | 103.49 | 103.65 | 103.11 | 103.24 | 1400500.0 |
| 2003-10-07 14:00:00 | SPY | ETF | 103.24 | 103.72 | 103.21 | 103.72 | 1442900.0 |
| 2003-10-07 14:30:00 | SPY | ETF | 103.7 | 103.969 | 103.65 | 103.85 | 2381100.0 |
| 2003-10-07 15:00:00 | SPY | ETF | 103.86 | 104.25 | 103.8 | 104.15 | 5169600.0 |
| 2003-10-07 15:30:00 | SPY | ETF | 104.18 | 104.26 | 104.02 | 104.19 | 2623700.0 |
| 2003-10-07 16:00:00 | SPY | ETF | 104.21 | 104.33 | 103.7375 | 104.26 | 2643000.0 |
| 2003-10-07 16:30:00 | SPY | ETF | 104.28 | 104.33 | 104.25 | 104.27 | 79100.0 |
| 2003-10-07 17:00:00 | SPY | ETF | 104.28 | 104.294 | 104.26 | 104.26 | 18200.0 |
| 2003-10-07 17:30:00 | SPY | ETF | 104.28 | 104.28 | 104.26 | 104.26 | 1000.0 |
| 2003-10-07 18:00:00 | SPY | ETF | 104.28 | 104.28 | 104.22 | 104.22 | 5200.0 |
| 2003-10-07 18:30:00 | SPY | ETF | 104.21 | 104.21 | 104.21 | 104.21 | 200.0 |
| 2003-10-07 19:00:00 | SPY | ETF | 104.25 | 104.25 | 104.25 | 104.25 | 2500.0 |
| 2003-10-07 19:30:00 | SPY | ETF | 104.25 | 104.26 | 104.21 | 104.21 | 13000.0 |
| 2003-10-07 08:00:00 | QQQ | ETF | 34.24 | 34.24 | 34.16 | 34.19 | 62900.0 |
| 2003-10-07 08:30:00 | QQQ | ETF | 34.19 | 34.2 | 34.15 | 34.16 | 47700.0 |
| 2003-10-07 09:00:00 | QQQ | ETF | 34.17 | 34.2 | 34.16 | 34.17 | 70500.0 |
| 2003-10-07 09:30:00 | QQQ | ETF | 34.16 | 34.21 | 34.01 | 34.17 | 8588800.0 |
| 2003-10-07 10:00:00 | QQQ | ETF | 34.17 | 34.211 | 34.02 | 34.18 | 8483400.0 |
| 2003-10-07 10:30:00 | QQQ | ETF | 34.179 | 34.26 | 34.08 | 34.18 | 4311400.0 |
| 2003-10-07 11:00:00 | QQQ | ETF | 34.2 | 34.48 | 34.14 | 34.41 | 7034800.0 |
| 2003-10-07 11:30:00 | QQQ | ETF | 34.42 | 34.501 | 34.38 | 34.408 | 4473600.0 |
| 2003-10-07 12:00:00 | QQQ | ETF | 34.41 | 34.465 | 34.34 | 34.38 | 2000500.0 |
| 2003-10-07 12:30:00 | QQQ | ETF | 34.39 | 34.45 | 34.19 | 34.23 | 4193200.0 |
| 2003-10-07 13:00:00 | QQQ | ETF | 34.23 | 34.25 | 34.139 | 34.201 | 2437700.0 |
| 2003-10-07 13:30:00 | QQQ | ETF | 34.2 | 34.3 | 34.06 | 34.13 | 3391600.0 |
| 2003-10-07 14:00:00 | QQQ | ETF | 34.118 | 34.35 | 34.1 | 34.33 | 3256000.0 |
| 2003-10-07 14:30:00 | QQQ | ETF | 34.334 | 34.45 | 34.3 | 34.42 | 4546800.0 |
| 2003-10-07 15:00:00 | QQQ | ETF | 34.416 | 34.6 | 34.37 | 34.575 | 6294900.0 |
| 2003-10-07 15:30:00 | QQQ | ETF | 34.572 | 34.611 | 34.5 | 34.57 | 6063400.0 |
| 2003-10-07 16:00:00 | QQQ | ETF | 34.572 | 34.66 | 34.55 | 34.659 | 2175800.0 |
| 2003-10-07 16:30:00 | QQQ | ETF | 34.659 | 34.69 | 34.64 | 34.69 | 260400.0 |
| 2003-10-07 17:00:00 | QQQ | ETF | 34.661 | 34.677 | 34.3476 | 34.66 | 2389800.0 |
| 2003-10-07 17:30:00 | QQQ | ETF | 34.65 | 34.67 | 34.65 | 34.67 | 6800.0 |
| 2003-10-07 18:00:00 | QQQ | ETF | 34.67 | 34.68 | 34.65 | 34.65 | 60800.0 |
| 2003-10-07 18:30:00 | QQQ | ETF | 34.65 | 34.66 | 34.62 | 34.62 | 4700.0 |
| 2003-10-07 19:00:00 | QQQ | ETF | 34.64 | 34.67 | 34.62 | 34.67 | 6400.0 |
| 2003-10-07 19:30:00 | QQQ | ETF | 34.65 | 34.66 | 34.63 | 34.65 | 5600.0 |
| 2003-10-07 08:00:00 | IWM | ETF | 51.3 | 51.3 | 51.3 | 51.3 | 200.0 |
| 2003-10-07 09:00:00 | IWM | ETF | 51.205 | 51.29 | 51.205 | 51.29 | 14800.0 |
> showing 50 of 752 rows — these rows as CSV