PREVIEW / etf_30min / 2003-03-12
file: by_date/etf_30min/2003/2003-03-12.parquet size: 23 KB rows: 666
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-03-12 08:00:00 | SPY | ETF | 80.6 | 81.1 | 79.81 | 80.02 | 172100.0 |
| 2003-03-12 08:30:00 | SPY | ETF | 80.1 | 80.43 | 80.0 | 80.3 | 57500.0 |
| 2003-03-12 09:00:00 | SPY | ETF | 80.23 | 80.41 | 80.2 | 80.41 | 31800.0 |
| 2003-03-12 09:30:00 | SPY | ETF | 80.38 | 80.79 | 80.25 | 80.35 | 6684500.0 |
| 2003-03-12 10:00:00 | SPY | ETF | 80.36 | 80.48 | 80.0 | 80.12 | 5389000.0 |
| 2003-03-12 10:30:00 | SPY | ETF | 80.2 | 80.36 | 79.9 | 80.08 | 3891500.0 |
| 2003-03-12 11:00:00 | SPY | ETF | 80.07 | 80.23 | 79.86 | 79.9 | 2555200.0 |
| 2003-03-12 11:30:00 | SPY | ETF | 79.88 | 79.98 | 79.66 | 79.77 | 3217500.0 |
| 2003-03-12 12:00:00 | SPY | ETF | 79.75 | 79.79 | 79.42 | 79.7 | 3633300.0 |
| 2003-03-12 12:30:00 | SPY | ETF | 79.69 | 79.84 | 79.5 | 79.64 | 4080900.0 |
| 2003-03-12 13:00:00 | SPY | ETF | 79.62 | 79.72 | 79.38 | 79.5 | 1744100.0 |
| 2003-03-12 13:30:00 | SPY | ETF | 79.5 | 79.88 | 79.42 | 79.86 | 3084300.0 |
| 2003-03-12 14:00:00 | SPY | ETF | 79.88 | 80.03 | 79.66 | 79.72 | 3474800.0 |
| 2003-03-12 14:30:00 | SPY | ETF | 79.72 | 80.6 | 79.65 | 80.5 | 5133200.0 |
| 2003-03-12 15:00:00 | SPY | ETF | 80.51 | 80.73 | 80.22 | 80.24 | 5745400.0 |
| 2003-03-12 15:30:00 | SPY | ETF | 80.25 | 81.01 | 80.15 | 80.97 | 7675200.0 |
| 2003-03-12 16:00:00 | SPY | ETF | 80.98 | 81.15 | 80.5 | 81.08 | 2219000.0 |
| 2003-03-12 16:30:00 | SPY | ETF | 81.13 | 81.14 | 80.49 | 81.1 | 78000.0 |
| 2003-03-12 17:00:00 | SPY | ETF | 81.05 | 81.13 | 81.05 | 81.1 | 21300.0 |
| 2003-03-12 17:30:00 | SPY | ETF | 81.11 | 81.2 | 81.11 | 81.19 | 8700.0 |
| 2003-03-12 18:00:00 | SPY | ETF | 81.18 | 81.2 | 81.14 | 81.2 | 6500.0 |
| 2003-03-12 18:30:00 | SPY | ETF | 81.2 | 81.2 | 81.1 | 81.1 | 1100.0 |
| 2003-03-12 19:00:00 | SPY | ETF | 81.18 | 81.2 | 81.18 | 81.2 | 4300.0 |
| 2003-03-12 19:30:00 | SPY | ETF | 81.21 | 81.21 | 81.13 | 81.2 | 3400.0 |
| 2003-03-12 08:00:00 | QQQ | ETF | 23.77 | 24.0 | 23.56 | 23.6 | 197100.0 |
| 2003-03-12 08:30:00 | QQQ | ETF | 23.65 | 23.77 | 23.61 | 23.7 | 41700.0 |
| 2003-03-12 09:00:00 | QQQ | ETF | 23.7 | 23.77 | 23.7 | 23.76 | 30600.0 |
| 2003-03-12 09:30:00 | QQQ | ETF | 23.76 | 24.08 | 23.73 | 23.91 | 10972800.0 |
| 2003-03-12 10:00:00 | QQQ | ETF | 23.92 | 23.97 | 23.77 | 23.86 | 4981600.0 |
| 2003-03-12 10:30:00 | QQQ | ETF | 23.86 | 23.91 | 23.76 | 23.79 | 5603900.0 |
| 2003-03-12 11:00:00 | QQQ | ETF | 23.78 | 23.88 | 23.74 | 23.76 | 3552900.0 |
| 2003-03-12 11:30:00 | QQQ | ETF | 23.76 | 23.79 | 23.63 | 23.68 | 4169000.0 |
| 2003-03-12 12:00:00 | QQQ | ETF | 23.67 | 23.69 | 23.55 | 23.66 | 3693400.0 |
| 2003-03-12 12:30:00 | QQQ | ETF | 23.66 | 23.73 | 23.58 | 23.63 | 5784600.0 |
| 2003-03-12 13:00:00 | QQQ | ETF | 23.62 | 23.66 | 23.54 | 23.61 | 2935400.0 |
| 2003-03-12 13:30:00 | QQQ | ETF | 23.59 | 23.74 | 23.58 | 23.74 | 3317100.0 |
| 2003-03-12 14:00:00 | QQQ | ETF | 23.74 | 23.8 | 23.67 | 23.69 | 3841300.0 |
| 2003-03-12 14:30:00 | QQQ | ETF | 23.69 | 24.02 | 23.65 | 23.99 | 7090300.0 |
| 2003-03-12 15:00:00 | QQQ | ETF | 24.02 | 24.06 | 23.88 | 23.91 | 5378300.0 |
| 2003-03-12 15:30:00 | QQQ | ETF | 23.9 | 24.18 | 23.86 | 24.16 | 8194600.0 |
| 2003-03-12 16:00:00 | QQQ | ETF | 24.14 | 24.24 | 24.14 | 24.23 | 4916000.0 |
| 2003-03-12 16:30:00 | QQQ | ETF | 24.22 | 24.25 | 24.18 | 24.23 | 146100.0 |
| 2003-03-12 17:00:00 | QQQ | ETF | 24.21 | 24.24 | 24.19 | 24.23 | 79000.0 |
| 2003-03-12 17:30:00 | QQQ | ETF | 24.24 | 24.25 | 24.22 | 24.25 | 37000.0 |
| 2003-03-12 18:00:00 | QQQ | ETF | 24.25 | 24.25 | 24.2 | 24.21 | 82400.0 |
| 2003-03-12 18:30:00 | QQQ | ETF | 24.22 | 24.24 | 24.22 | 24.24 | 5500.0 |
| 2003-03-12 19:00:00 | QQQ | ETF | 24.23 | 24.23 | 24.22 | 24.22 | 1400.0 |
| 2003-03-12 19:30:00 | QQQ | ETF | 24.24 | 24.29 | 24.23 | 24.28 | 62300.0 |
| 2003-03-12 08:30:00 | IWM | ETF | 34.5 | 34.59 | 34.5 | 34.59 | 1600.0 |
| 2003-03-12 09:30:00 | IWM | ETF | 34.44 | 34.54 | 34.33 | 34.33 | 514600.0 |
> showing 50 of 666 rows — these rows as CSV