PREVIEW / etf_5min / 2009-04-22
file: by_date/etf_5min/2009/2009-04-22.parquet size: 693 KB rows: 30,223
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-22 04:15:00 | SPY | ETF | 84.6 | 84.6 | 84.34 | 84.34 | 2900.0 |
| 2009-04-22 04:20:00 | SPY | ETF | 84.5 | 84.5 | 84.5 | 84.5 | 250.0 |
| 2009-04-22 04:25:00 | SPY | ETF | 84.47 | 84.47 | 84.47 | 84.47 | 5000.0 |
| 2009-04-22 04:30:00 | SPY | ETF | 84.6 | 84.6 | 84.6 | 84.6 | 600.0 |
| 2009-04-22 04:50:00 | SPY | ETF | 84.43 | 84.43 | 84.43 | 84.43 | 300.0 |
| 2009-04-22 05:00:00 | SPY | ETF | 84.57 | 84.59 | 84.57 | 84.59 | 1600.0 |
| 2009-04-22 05:20:00 | SPY | ETF | 84.7 | 84.7 | 84.7 | 84.7 | 500.0 |
| 2009-04-22 05:40:00 | SPY | ETF | 84.67 | 84.82 | 84.67 | 84.82 | 1200.0 |
| 2009-04-22 05:45:00 | SPY | ETF | 84.81 | 84.81 | 84.81 | 84.81 | 200.0 |
| 2009-04-22 05:55:00 | SPY | ETF | 84.84 | 84.84 | 84.84 | 84.84 | 100.0 |
| 2009-04-22 06:00:00 | SPY | ETF | 84.71 | 84.71 | 84.71 | 84.71 | 100.0 |
| 2009-04-22 06:05:00 | SPY | ETF | 84.7 | 84.7 | 84.65 | 84.65 | 4250.0 |
| 2009-04-22 06:10:00 | SPY | ETF | 84.56 | 84.76 | 84.56 | 84.76 | 1400.0 |
| 2009-04-22 06:15:00 | SPY | ETF | 84.79 | 84.84 | 84.79 | 84.84 | 900.0 |
| 2009-04-22 06:20:00 | SPY | ETF | 84.84 | 84.84 | 84.84 | 84.84 | 1400.0 |
| 2009-04-22 06:30:00 | SPY | ETF | 84.8 | 84.8 | 84.8 | 84.8 | 100.0 |
| 2009-04-22 06:35:00 | SPY | ETF | 84.64 | 84.64 | 84.64 | 84.64 | 100.0 |
| 2009-04-22 06:40:00 | SPY | ETF | 84.8 | 84.88 | 84.8 | 84.84 | 10600.0 |
| 2009-04-22 06:45:00 | SPY | ETF | 84.84 | 84.84 | 84.84 | 84.84 | 100.0 |
| 2009-04-22 06:50:00 | SPY | ETF | 84.86 | 84.86 | 84.79 | 84.79 | 2200.0 |
| 2009-04-22 06:55:00 | SPY | ETF | 84.79 | 84.79 | 84.74 | 84.74 | 4199.0 |
| 2009-04-22 07:00:00 | SPY | ETF | 84.7 | 84.7 | 84.63 | 84.7 | 15700.0 |
| 2009-04-22 07:05:00 | SPY | ETF | 84.67 | 84.67 | 84.54 | 84.61 | 41650.0 |
| 2009-04-22 07:10:00 | SPY | ETF | 84.63 | 84.63 | 84.52 | 84.53 | 11600.0 |
| 2009-04-22 07:15:00 | SPY | ETF | 84.52 | 84.55 | 84.43 | 84.54 | 159170.0 |
| 2009-04-22 07:20:00 | SPY | ETF | 84.54 | 84.61 | 84.53 | 84.57 | 96827.0 |
| 2009-04-22 07:25:00 | SPY | ETF | 84.6 | 84.7 | 84.58 | 84.64 | 111201.0 |
| 2009-04-22 07:30:00 | SPY | ETF | 84.64 | 84.64 | 84.48 | 84.61 | 84967.0 |
| 2009-04-22 07:35:00 | SPY | ETF | 84.65 | 84.69 | 84.61 | 84.66 | 85784.0 |
| 2009-04-22 07:40:00 | SPY | ETF | 84.67 | 84.83 | 84.67 | 84.77 | 99645.0 |
| 2009-04-22 07:45:00 | SPY | ETF | 84.77 | 84.84 | 84.76 | 84.8 | 97517.0 |
| 2009-04-22 07:50:00 | SPY | ETF | 84.82 | 84.98 | 84.82 | 84.96 | 131040.0 |
| 2009-04-22 07:55:00 | SPY | ETF | 84.96 | 84.96 | 84.86 | 84.86 | 51814.0 |
| 2009-04-22 08:00:00 | SPY | ETF | 84.85 | 84.91 | 84.38 | 84.6 | 1007447.0 |
| 2009-04-22 08:05:00 | SPY | ETF | 84.6 | 84.79 | 84.52 | 84.75 | 781260.0 |
| 2009-04-22 08:10:00 | SPY | ETF | 84.75 | 84.76 | 84.55 | 84.59 | 272584.0 |
| 2009-04-22 08:15:00 | SPY | ETF | 84.58 | 84.58 | 84.22 | 84.23 | 602678.0 |
| 2009-04-22 08:20:00 | SPY | ETF | 84.24 | 84.24 | 84.1 | 84.2 | 1039984.0 |
| 2009-04-22 08:25:00 | SPY | ETF | 84.19 | 84.34 | 84.15 | 84.29 | 437794.0 |
| 2009-04-22 08:30:00 | SPY | ETF | 84.3 | 84.3 | 84.08 | 84.08 | 509373.0 |
| 2009-04-22 08:35:00 | SPY | ETF | 84.07 | 84.25 | 84.06 | 84.19 | 549886.0 |
| 2009-04-22 08:40:00 | SPY | ETF | 84.19 | 84.19 | 84.1 | 84.14 | 350584.0 |
| 2009-04-22 08:45:00 | SPY | ETF | 84.15 | 84.22 | 84.11 | 84.21 | 179891.0 |
| 2009-04-22 08:50:00 | SPY | ETF | 84.22 | 84.34 | 84.22 | 84.3 | 571279.0 |
| 2009-04-22 08:55:00 | SPY | ETF | 84.29 | 85.08 | 84.18 | 84.23 | 478213.0 |
| 2009-04-22 09:00:00 | SPY | ETF | 84.23 | 84.24 | 84.16 | 84.18 | 196685.0 |
| 2009-04-22 09:05:00 | SPY | ETF | 84.2 | 84.2 | 84.03 | 84.06 | 246141.0 |
| 2009-04-22 09:10:00 | SPY | ETF | 84.07 | 84.23 | 84.06 | 84.21 | 174514.0 |
| 2009-04-22 09:15:00 | SPY | ETF | 84.21 | 84.28 | 84.19 | 84.21 | 415056.0 |
| 2009-04-22 09:20:00 | SPY | ETF | 84.21 | 84.22 | 84.12 | 84.18 | 216694.0 |
> showing 50 of 30,223 rows — these rows as CSV