PREVIEW / etf_5min / 2009-02-02
file: by_date/etf_5min/2009/2009-02-02.parquet size: 628 KB rows: 27,123
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-02-02 04:15:00 | SPY | ETF | 81.54 | 81.57 | 81.49 | 81.49 | 1139.0 |
| 2009-02-02 04:20:00 | SPY | ETF | 81.52 | 81.54 | 81.49 | 81.54 | 400.0 |
| 2009-02-02 04:25:00 | SPY | ETF | 81.42 | 81.49 | 81.42 | 81.49 | 400.0 |
| 2009-02-02 04:30:00 | SPY | ETF | 81.45 | 81.45 | 81.39 | 81.39 | 200.0 |
| 2009-02-02 04:40:00 | SPY | ETF | 81.33 | 81.33 | 81.26 | 81.31 | 500.0 |
| 2009-02-02 04:45:00 | SPY | ETF | 81.32 | 81.32 | 81.27 | 81.27 | 300.0 |
| 2009-02-02 04:50:00 | SPY | ETF | 81.17 | 81.17 | 81.17 | 81.17 | 100.0 |
| 2009-02-02 04:55:00 | SPY | ETF | 81.24 | 81.24 | 81.24 | 81.24 | 100.0 |
| 2009-02-02 05:05:00 | SPY | ETF | 81.46 | 81.46 | 81.46 | 81.46 | 100.0 |
| 2009-02-02 05:15:00 | SPY | ETF | 81.46 | 81.51 | 81.46 | 81.49 | 600.0 |
| 2009-02-02 05:25:00 | SPY | ETF | 81.42 | 81.42 | 81.42 | 81.42 | 100.0 |
| 2009-02-02 05:30:00 | SPY | ETF | 81.37 | 81.37 | 81.37 | 81.37 | 200.0 |
| 2009-02-02 05:35:00 | SPY | ETF | 81.24 | 81.24 | 81.24 | 81.24 | 159.0 |
| 2009-02-02 05:40:00 | SPY | ETF | 81.19 | 81.19 | 81.18 | 81.18 | 600.0 |
| 2009-02-02 05:45:00 | SPY | ETF | 81.14 | 81.14 | 81.14 | 81.14 | 159.0 |
| 2009-02-02 06:00:00 | SPY | ETF | 81.24 | 81.26 | 81.24 | 81.26 | 200.0 |
| 2009-02-02 06:05:00 | SPY | ETF | 81.32 | 81.38 | 81.32 | 81.38 | 500.0 |
| 2009-02-02 06:15:00 | SPY | ETF | 81.4 | 81.4 | 81.4 | 81.4 | 188.0 |
| 2009-02-02 06:25:00 | SPY | ETF | 81.44 | 81.45 | 81.44 | 81.45 | 500.0 |
| 2009-02-02 06:30:00 | SPY | ETF | 81.47 | 81.47 | 81.47 | 81.47 | 100.0 |
| 2009-02-02 06:35:00 | SPY | ETF | 81.37 | 81.45 | 81.37 | 81.45 | 400.0 |
| 2009-02-02 06:40:00 | SPY | ETF | 81.47 | 81.47 | 81.47 | 81.47 | 500.0 |
| 2009-02-02 06:45:00 | SPY | ETF | 81.58 | 81.69 | 81.58 | 81.69 | 5400.0 |
| 2009-02-02 06:50:00 | SPY | ETF | 81.68 | 81.68 | 81.68 | 81.68 | 1000.0 |
| 2009-02-02 06:55:00 | SPY | ETF | 81.65 | 81.7 | 81.64 | 81.68 | 6300.0 |
| 2009-02-02 07:00:00 | SPY | ETF | 81.69 | 81.71 | 81.63 | 81.63 | 20538.0 |
| 2009-02-02 07:05:00 | SPY | ETF | 81.61 | 81.68 | 81.61 | 81.68 | 17400.0 |
| 2009-02-02 07:10:00 | SPY | ETF | 81.66 | 81.69 | 81.64 | 81.66 | 3500.0 |
| 2009-02-02 07:15:00 | SPY | ETF | 81.69 | 81.81 | 81.69 | 81.78 | 142076.0 |
| 2009-02-02 07:20:00 | SPY | ETF | 81.75 | 81.75 | 81.65 | 81.68 | 89185.0 |
| 2009-02-02 07:25:00 | SPY | ETF | 81.68 | 81.69 | 81.55 | 81.55 | 135303.0 |
| 2009-02-02 07:30:00 | SPY | ETF | 81.56 | 81.62 | 81.53 | 81.58 | 12345.0 |
| 2009-02-02 07:35:00 | SPY | ETF | 81.6 | 81.62 | 81.56 | 81.6 | 13034.0 |
| 2009-02-02 07:40:00 | SPY | ETF | 81.61 | 81.62 | 81.52 | 81.61 | 81069.0 |
| 2009-02-02 07:45:00 | SPY | ETF | 81.61 | 81.63 | 81.58 | 81.58 | 13801.0 |
| 2009-02-02 07:50:00 | SPY | ETF | 81.56 | 81.6 | 81.28 | 81.28 | 86616.0 |
| 2009-02-02 07:55:00 | SPY | ETF | 81.33 | 81.48 | 81.32 | 81.46 | 80021.0 |
| 2009-02-02 08:00:00 | SPY | ETF | 81.43 | 81.86 | 81.43 | 81.58 | 170169.0 |
| 2009-02-02 08:05:00 | SPY | ETF | 81.6 | 81.64 | 81.54 | 81.59 | 123677.0 |
| 2009-02-02 08:10:00 | SPY | ETF | 81.72 | 81.72 | 81.55 | 81.58 | 440906.0 |
| 2009-02-02 08:15:00 | SPY | ETF | 81.59 | 81.59 | 81.37 | 81.41 | 142979.0 |
| 2009-02-02 08:20:00 | SPY | ETF | 81.41 | 81.47 | 81.38 | 81.39 | 156108.0 |
| 2009-02-02 08:25:00 | SPY | ETF | 81.39 | 81.4 | 81.29 | 81.31 | 131509.0 |
| 2009-02-02 08:30:00 | SPY | ETF | 81.31 | 81.57 | 81.15 | 81.23 | 557471.0 |
| 2009-02-02 08:35:00 | SPY | ETF | 81.26 | 81.34 | 81.18 | 81.32 | 203240.0 |
| 2009-02-02 08:40:00 | SPY | ETF | 81.33 | 83.0 | 81.29 | 81.31 | 226452.0 |
| 2009-02-02 08:45:00 | SPY | ETF | 81.35 | 81.4 | 81.17 | 81.26 | 349779.0 |
| 2009-02-02 08:50:00 | SPY | ETF | 81.23 | 81.34 | 81.21 | 81.28 | 315065.0 |
| 2009-02-02 08:55:00 | SPY | ETF | 81.31 | 81.34 | 81.24 | 81.31 | 147444.0 |
| 2009-02-02 09:00:00 | SPY | ETF | 81.31 | 81.34 | 81.25 | 81.3 | 166828.0 |
> showing 50 of 27,123 rows — these rows as CSV