PREVIEW / etf_5min / 2008-10-15
file: by_date/etf_5min/2008/2008-10-15.parquet size: 562 KB rows: 26,456
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-15 04:15:00 | SPY | ETF | 99.0 | 99.0 | 99.0 | 99.0 | 100.0 |
| 2008-10-15 04:25:00 | SPY | ETF | 99.11 | 99.11 | 99.11 | 99.11 | 100.0 |
| 2008-10-15 04:30:00 | SPY | ETF | 99.16 | 99.16 | 99.16 | 99.16 | 100.0 |
| 2008-10-15 04:50:00 | SPY | ETF | 98.5 | 98.5 | 98.5 | 98.5 | 100.0 |
| 2008-10-15 05:05:00 | SPY | ETF | 98.77 | 98.77 | 98.77 | 98.77 | 100.0 |
| 2008-10-15 05:10:00 | SPY | ETF | 98.85 | 98.85 | 98.83 | 98.85 | 5150.0 |
| 2008-10-15 05:25:00 | SPY | ETF | 98.53 | 98.53 | 98.53 | 98.53 | 1000.0 |
| 2008-10-15 05:30:00 | SPY | ETF | 98.33 | 98.33 | 98.0 | 98.2 | 4100.0 |
| 2008-10-15 05:35:00 | SPY | ETF | 98.25 | 98.25 | 98.25 | 98.25 | 100.0 |
| 2008-10-15 05:50:00 | SPY | ETF | 98.25 | 98.25 | 98.23 | 98.23 | 1400.0 |
| 2008-10-15 06:05:00 | SPY | ETF | 99.0 | 99.13 | 99.0 | 99.13 | 200.0 |
| 2008-10-15 06:10:00 | SPY | ETF | 99.2 | 99.2 | 99.1 | 99.1 | 300.0 |
| 2008-10-15 06:15:00 | SPY | ETF | 99.07 | 99.07 | 99.07 | 99.07 | 100.0 |
| 2008-10-15 06:20:00 | SPY | ETF | 99.0 | 99.0 | 99.0 | 99.0 | 100.0 |
| 2008-10-15 06:25:00 | SPY | ETF | 98.9 | 98.9 | 98.7 | 98.84 | 300.0 |
| 2008-10-15 06:30:00 | SPY | ETF | 99.17 | 99.17 | 99.09 | 99.09 | 5000.0 |
| 2008-10-15 06:35:00 | SPY | ETF | 99.24 | 99.3 | 99.24 | 99.3 | 2100.0 |
| 2008-10-15 06:45:00 | SPY | ETF | 99.36 | 99.86 | 99.36 | 99.75 | 9000.0 |
| 2008-10-15 06:50:00 | SPY | ETF | 99.75 | 99.75 | 99.38 | 99.39 | 31700.0 |
| 2008-10-15 06:55:00 | SPY | ETF | 99.5 | 99.75 | 99.29 | 99.45 | 48900.0 |
| 2008-10-15 07:00:00 | SPY | ETF | 99.43 | 99.61 | 99.08 | 99.08 | 229600.0 |
| 2008-10-15 07:05:00 | SPY | ETF | 99.0 | 99.04 | 98.62 | 98.64 | 100850.0 |
| 2008-10-15 07:10:00 | SPY | ETF | 98.77 | 98.9 | 98.67 | 98.86 | 32470.0 |
| 2008-10-15 07:15:00 | SPY | ETF | 98.9 | 99.05 | 98.9 | 99.05 | 42350.0 |
| 2008-10-15 07:20:00 | SPY | ETF | 99.05 | 99.33 | 99.02 | 99.33 | 74500.0 |
| 2008-10-15 07:25:00 | SPY | ETF | 99.27 | 99.27 | 99.0 | 99.0 | 47600.0 |
| 2008-10-15 07:30:00 | SPY | ETF | 99.05 | 99.13 | 99.0 | 99.05 | 17500.0 |
| 2008-10-15 07:35:00 | SPY | ETF | 99.14 | 99.14 | 98.79 | 98.79 | 98812.0 |
| 2008-10-15 07:40:00 | SPY | ETF | 98.76 | 98.76 | 98.41 | 98.43 | 66250.0 |
| 2008-10-15 07:45:00 | SPY | ETF | 98.42 | 98.57 | 98.25 | 98.48 | 99000.0 |
| 2008-10-15 07:50:00 | SPY | ETF | 98.43 | 98.48 | 98.33 | 98.4 | 38700.0 |
| 2008-10-15 07:55:00 | SPY | ETF | 98.36 | 98.36 | 98.21 | 98.21 | 56584.0 |
| 2008-10-15 08:00:00 | SPY | ETF | 98.22 | 99.526 | 98.21 | 98.37 | 1570625.0 |
| 2008-10-15 08:05:00 | SPY | ETF | 98.37 | 98.43 | 98.32 | 98.39 | 329368.0 |
| 2008-10-15 08:10:00 | SPY | ETF | 99.0 | 99.0 | 98.38 | 98.44 | 495708.0 |
| 2008-10-15 08:15:00 | SPY | ETF | 98.45 | 98.45 | 97.87 | 97.9 | 439414.0 |
| 2008-10-15 08:20:00 | SPY | ETF | 97.88 | 98.0 | 97.57 | 97.69 | 300013.0 |
| 2008-10-15 08:25:00 | SPY | ETF | 97.69 | 97.86 | 97.45 | 97.75 | 286577.0 |
| 2008-10-15 08:30:00 | SPY | ETF | 97.71 | 97.81 | 97.18 | 97.41 | 1110009.0 |
| 2008-10-15 08:35:00 | SPY | ETF | 97.39 | 97.39 | 96.86 | 97.28 | 1191624.0 |
| 2008-10-15 08:40:00 | SPY | ETF | 97.27 | 97.44 | 97.12 | 97.39 | 680484.0 |
| 2008-10-15 08:45:00 | SPY | ETF | 97.42 | 97.56 | 97.32 | 97.46 | 527830.0 |
| 2008-10-15 08:50:00 | SPY | ETF | 97.48 | 97.65 | 97.25 | 97.25 | 524671.0 |
| 2008-10-15 08:55:00 | SPY | ETF | 97.25 | 97.45 | 97.25 | 97.35 | 180570.0 |
| 2008-10-15 09:00:00 | SPY | ETF | 97.36 | 97.44 | 97.17 | 97.35 | 204300.0 |
| 2008-10-15 09:05:00 | SPY | ETF | 97.34 | 97.8 | 97.23 | 97.63 | 299230.0 |
| 2008-10-15 09:10:00 | SPY | ETF | 97.62 | 97.75 | 97.51 | 97.74 | 881651.0 |
| 2008-10-15 09:15:00 | SPY | ETF | 97.74 | 97.8 | 97.65 | 97.7 | 1369143.0 |
| 2008-10-15 09:20:00 | SPY | ETF | 97.71 | 97.76 | 97.51 | 97.57 | 480362.0 |
| 2008-10-15 09:25:00 | SPY | ETF | 97.58 | 97.69 | 97.44 | 97.47 | 908692.0 |
> showing 50 of 26,456 rows — these rows as CSV