PREVIEW / etf_5min / 2009-01-28
file: by_date/etf_5min/2009/2009-01-28.parquet size: 658 KB rows: 28,204
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-28 04:10:00 | SPY | ETF | 86.1 | 86.1 | 86.1 | 86.1 | 10000.0 |
| 2009-01-28 04:15:00 | SPY | ETF | 86.1 | 86.18 | 86.1 | 86.12 | 4610.0 |
| 2009-01-28 04:20:00 | SPY | ETF | 86.21 | 86.21 | 86.11 | 86.11 | 200.0 |
| 2009-01-28 04:25:00 | SPY | ETF | 86.09 | 86.09 | 86.09 | 86.09 | 177.0 |
| 2009-01-28 04:30:00 | SPY | ETF | 86.07 | 86.07 | 86.07 | 86.07 | 2500.0 |
| 2009-01-28 04:35:00 | SPY | ETF | 86.11 | 86.11 | 86.11 | 86.11 | 2500.0 |
| 2009-01-28 04:40:00 | SPY | ETF | 86.1 | 86.1 | 86.1 | 86.1 | 177.0 |
| 2009-01-28 05:00:00 | SPY | ETF | 86.17 | 86.24 | 86.17 | 86.24 | 200.0 |
| 2009-01-28 05:05:00 | SPY | ETF | 86.33 | 86.34 | 86.33 | 86.34 | 200.0 |
| 2009-01-28 05:15:00 | SPY | ETF | 86.25 | 86.25 | 86.25 | 86.25 | 100.0 |
| 2009-01-28 05:25:00 | SPY | ETF | 86.09 | 86.09 | 86.03 | 86.03 | 6000.0 |
| 2009-01-28 05:30:00 | SPY | ETF | 86.04 | 86.04 | 86.04 | 86.04 | 100.0 |
| 2009-01-28 05:40:00 | SPY | ETF | 86.06 | 86.15 | 86.06 | 86.13 | 14800.0 |
| 2009-01-28 05:45:00 | SPY | ETF | 86.13 | 86.18 | 86.13 | 86.18 | 300.0 |
| 2009-01-28 05:50:00 | SPY | ETF | 86.09 | 86.09 | 86.09 | 86.09 | 100.0 |
| 2009-01-28 05:55:00 | SPY | ETF | 86.02 | 86.02 | 86.02 | 86.02 | 100.0 |
| 2009-01-28 06:00:00 | SPY | ETF | 86.09 | 86.09 | 86.09 | 86.09 | 2900.0 |
| 2009-01-28 06:05:00 | SPY | ETF | 86.05 | 86.08 | 86.05 | 86.08 | 10000.0 |
| 2009-01-28 06:10:00 | SPY | ETF | 86.1 | 86.15 | 86.1 | 86.15 | 823.0 |
| 2009-01-28 06:20:00 | SPY | ETF | 86.12 | 86.12 | 86.12 | 86.12 | 700.0 |
| 2009-01-28 06:30:00 | SPY | ETF | 86.16 | 86.22 | 86.14 | 86.22 | 4900.0 |
| 2009-01-28 06:35:00 | SPY | ETF | 86.2 | 86.28 | 86.2 | 86.28 | 3000.0 |
| 2009-01-28 06:40:00 | SPY | ETF | 86.29 | 86.34 | 86.28 | 86.34 | 55705.0 |
| 2009-01-28 06:45:00 | SPY | ETF | 86.21 | 86.23 | 86.15 | 86.23 | 500.0 |
| 2009-01-28 06:50:00 | SPY | ETF | 86.25 | 86.31 | 86.25 | 86.31 | 51600.0 |
| 2009-01-28 06:55:00 | SPY | ETF | 86.32 | 86.38 | 86.32 | 86.38 | 605.0 |
| 2009-01-28 07:00:00 | SPY | ETF | 86.28 | 86.28 | 86.22 | 86.25 | 40213.0 |
| 2009-01-28 07:05:00 | SPY | ETF | 86.25 | 86.25 | 86.17 | 86.24 | 71540.0 |
| 2009-01-28 07:10:00 | SPY | ETF | 86.22 | 86.29 | 86.2 | 86.2 | 13438.0 |
| 2009-01-28 07:15:00 | SPY | ETF | 86.2 | 86.2 | 86.0 | 86.1 | 40631.0 |
| 2009-01-28 07:20:00 | SPY | ETF | 86.1 | 86.1 | 86.04 | 86.05 | 17726.0 |
| 2009-01-28 07:25:00 | SPY | ETF | 86.07 | 86.15 | 86.01 | 86.15 | 29604.0 |
| 2009-01-28 07:30:00 | SPY | ETF | 86.19 | 86.25 | 86.07 | 86.11 | 78685.0 |
| 2009-01-28 07:35:00 | SPY | ETF | 86.12 | 86.16 | 86.09 | 86.09 | 21043.0 |
| 2009-01-28 07:40:00 | SPY | ETF | 86.16 | 86.16 | 85.95 | 85.98 | 557558.0 |
| 2009-01-28 07:45:00 | SPY | ETF | 86.01 | 86.21 | 86.0 | 86.21 | 327552.0 |
| 2009-01-28 07:50:00 | SPY | ETF | 86.21 | 86.42 | 86.21 | 86.37 | 176151.0 |
| 2009-01-28 07:55:00 | SPY | ETF | 86.37 | 86.5 | 86.36 | 86.5 | 154736.0 |
| 2009-01-28 08:00:00 | SPY | ETF | 86.5 | 86.5 | 86.2 | 86.47 | 736953.0 |
| 2009-01-28 08:05:00 | SPY | ETF | 86.46 | 86.58 | 86.09 | 86.46 | 829581.0 |
| 2009-01-28 08:10:00 | SPY | ETF | 86.45 | 86.57 | 86.29 | 86.49 | 785053.0 |
| 2009-01-28 08:15:00 | SPY | ETF | 86.49 | 86.67 | 86.41 | 86.65 | 239408.0 |
| 2009-01-28 08:20:00 | SPY | ETF | 86.65 | 86.78 | 86.63 | 86.72 | 659087.0 |
| 2009-01-28 08:25:00 | SPY | ETF | 86.72 | 86.74 | 86.01 | 86.01 | 365263.0 |
| 2009-01-28 08:30:00 | SPY | ETF | 86.61 | 86.71 | 86.0 | 86.58 | 662504.0 |
| 2009-01-28 08:35:00 | SPY | ETF | 86.58 | 86.59 | 86.44 | 86.47 | 195653.0 |
| 2009-01-28 08:40:00 | SPY | ETF | 86.47 | 86.52 | 86.28 | 86.29 | 266582.0 |
| 2009-01-28 08:45:00 | SPY | ETF | 86.3 | 86.41 | 86.28 | 86.38 | 221328.0 |
| 2009-01-28 08:50:00 | SPY | ETF | 86.38 | 86.47 | 86.0 | 86.41 | 149074.0 |
| 2009-01-28 08:55:00 | SPY | ETF | 86.42 | 86.54 | 86.42 | 86.49 | 82906.0 |
> showing 50 of 28,204 rows — these rows as CSV