PREVIEW / etf_5min / 2009-01-23
file: by_date/etf_5min/2009/2009-01-23.parquet size: 667 KB rows: 28,282
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-01-23 04:15:00 | SPY | ETF | 81.61 | 81.61 | 81.55 | 81.55 | 2900.0 |
| 2009-01-23 04:20:00 | SPY | ETF | 81.45 | 81.45 | 81.44 | 81.44 | 200.0 |
| 2009-01-23 04:25:00 | SPY | ETF | 81.44 | 81.44 | 81.27 | 81.27 | 1406.0 |
| 2009-01-23 04:30:00 | SPY | ETF | 81.07 | 81.2 | 81.05 | 81.1 | 3505.0 |
| 2009-01-23 04:35:00 | SPY | ETF | 81.05 | 81.07 | 80.94 | 80.97 | 1010.0 |
| 2009-01-23 04:40:00 | SPY | ETF | 81.08 | 81.08 | 81.08 | 81.08 | 100.0 |
| 2009-01-23 04:45:00 | SPY | ETF | 81.11 | 81.11 | 81.11 | 81.11 | 3000.0 |
| 2009-01-23 04:55:00 | SPY | ETF | 80.97 | 80.97 | 80.67 | 80.67 | 1310.0 |
| 2009-01-23 05:00:00 | SPY | ETF | 80.75 | 80.75 | 80.68 | 80.68 | 400.0 |
| 2009-01-23 05:25:00 | SPY | ETF | 80.7 | 80.94 | 80.69 | 80.9 | 900.0 |
| 2009-01-23 05:35:00 | SPY | ETF | 80.84 | 81.03 | 80.84 | 81.03 | 500.0 |
| 2009-01-23 05:40:00 | SPY | ETF | 81.12 | 81.12 | 81.08 | 81.08 | 800.0 |
| 2009-01-23 05:45:00 | SPY | ETF | 80.98 | 80.98 | 80.98 | 80.98 | 300.0 |
| 2009-01-23 05:50:00 | SPY | ETF | 80.98 | 81.08 | 80.98 | 81.08 | 1910.0 |
| 2009-01-23 05:55:00 | SPY | ETF | 81.0 | 81.05 | 81.0 | 81.05 | 1000.0 |
| 2009-01-23 06:00:00 | SPY | ETF | 80.95 | 81.04 | 80.95 | 81.04 | 7000.0 |
| 2009-01-23 06:05:00 | SPY | ETF | 81.18 | 81.28 | 81.18 | 81.25 | 800.0 |
| 2009-01-23 06:10:00 | SPY | ETF | 81.24 | 81.33 | 81.21 | 81.21 | 2300.0 |
| 2009-01-23 06:15:00 | SPY | ETF | 81.21 | 81.21 | 81.17 | 81.17 | 606.0 |
| 2009-01-23 06:20:00 | SPY | ETF | 80.94 | 80.99 | 80.89 | 80.94 | 2700.0 |
| 2009-01-23 06:25:00 | SPY | ETF | 81.03 | 81.28 | 81.03 | 81.28 | 1850.0 |
| 2009-01-23 06:30:00 | SPY | ETF | 81.25 | 81.48 | 81.18 | 81.48 | 50700.0 |
| 2009-01-23 06:35:00 | SPY | ETF | 81.4 | 81.54 | 81.4 | 81.49 | 109450.0 |
| 2009-01-23 06:40:00 | SPY | ETF | 81.42 | 81.42 | 81.24 | 81.35 | 216500.0 |
| 2009-01-23 06:45:00 | SPY | ETF | 81.32 | 81.32 | 81.32 | 81.32 | 29000.0 |
| 2009-01-23 06:50:00 | SPY | ETF | 81.27 | 81.3 | 81.27 | 81.3 | 18250.0 |
| 2009-01-23 06:55:00 | SPY | ETF | 81.33 | 81.33 | 81.19 | 81.25 | 26350.0 |
| 2009-01-23 07:00:00 | SPY | ETF | 81.26 | 81.58 | 81.25 | 81.58 | 85200.0 |
| 2009-01-23 07:05:00 | SPY | ETF | 81.6 | 81.61 | 81.29 | 81.36 | 28307.0 |
| 2009-01-23 07:10:00 | SPY | ETF | 81.37 | 81.39 | 81.24 | 81.28 | 106594.0 |
| 2009-01-23 07:15:00 | SPY | ETF | 81.3 | 81.38 | 81.26 | 81.27 | 63211.0 |
| 2009-01-23 07:20:00 | SPY | ETF | 81.26 | 81.4 | 81.23 | 81.4 | 31125.0 |
| 2009-01-23 07:25:00 | SPY | ETF | 81.41 | 81.53 | 81.36 | 81.53 | 97141.0 |
| 2009-01-23 07:30:00 | SPY | ETF | 81.55 | 81.64 | 81.44 | 81.44 | 67912.0 |
| 2009-01-23 07:35:00 | SPY | ETF | 81.44 | 81.47 | 81.36 | 81.4 | 64082.0 |
| 2009-01-23 07:40:00 | SPY | ETF | 81.39 | 81.41 | 81.25 | 81.3 | 92283.0 |
| 2009-01-23 07:45:00 | SPY | ETF | 81.3 | 81.35 | 81.13 | 81.24 | 341028.0 |
| 2009-01-23 07:50:00 | SPY | ETF | 81.23 | 81.4 | 81.23 | 81.26 | 72383.0 |
| 2009-01-23 07:55:00 | SPY | ETF | 81.24 | 81.24 | 81.14 | 81.15 | 159241.0 |
| 2009-01-23 08:00:00 | SPY | ETF | 81.15 | 81.4 | 81.07 | 81.17 | 364755.0 |
| 2009-01-23 08:05:00 | SPY | ETF | 81.16 | 81.34 | 81.16 | 81.34 | 181861.0 |
| 2009-01-23 08:10:00 | SPY | ETF | 81.25 | 81.32 | 80.94 | 81.08 | 634110.0 |
| 2009-01-23 08:15:00 | SPY | ETF | 81.08 | 81.2 | 81.02 | 81.13 | 168511.0 |
| 2009-01-23 08:20:00 | SPY | ETF | 81.15 | 81.2 | 81.0 | 81.02 | 155143.0 |
| 2009-01-23 08:25:00 | SPY | ETF | 81.01 | 81.02 | 80.63 | 80.63 | 645181.0 |
| 2009-01-23 08:30:00 | SPY | ETF | 80.63 | 80.75 | 80.54 | 80.7 | 777537.0 |
| 2009-01-23 08:35:00 | SPY | ETF | 80.71 | 80.73 | 80.46 | 80.52 | 1300998.0 |
| 2009-01-23 08:40:00 | SPY | ETF | 80.52 | 80.76 | 80.51 | 80.76 | 419892.0 |
| 2009-01-23 08:45:00 | SPY | ETF | 80.75 | 80.85 | 80.69 | 80.84 | 446591.0 |
| 2009-01-23 08:50:00 | SPY | ETF | 80.85 | 80.85 | 80.62 | 80.66 | 253299.0 |
> showing 50 of 28,282 rows — these rows as CSV