PREVIEW / etf_5min / 2010-11-02
file: by_date/etf_5min/2010/2010-11-02.parquet size: 785 KB rows: 33,901
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-02 04:00:00 | SPY | ETF | 118.83 | 118.95 | 118.83 | 118.95 | 700.0 |
| 2010-11-02 04:05:00 | SPY | ETF | 119.0 | 119.05 | 119.0 | 119.05 | 200.0 |
| 2010-11-02 04:20:00 | SPY | ETF | 119.05 | 119.05 | 119.05 | 119.05 | 100.0 |
| 2010-11-02 04:25:00 | SPY | ETF | 119.15 | 119.15 | 119.14 | 119.14 | 320.0 |
| 2010-11-02 04:30:00 | SPY | ETF | 119.07 | 119.07 | 119.07 | 119.07 | 500.0 |
| 2010-11-02 04:35:00 | SPY | ETF | 119.03 | 119.03 | 119.03 | 119.03 | 100.0 |
| 2010-11-02 04:55:00 | SPY | ETF | 119.05 | 119.05 | 119.05 | 119.05 | 100.0 |
| 2010-11-02 05:25:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 100.0 |
| 2010-11-02 05:35:00 | SPY | ETF | 119.18 | 119.18 | 119.18 | 119.18 | 2000.0 |
| 2010-11-02 05:50:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 500.0 |
| 2010-11-02 05:55:00 | SPY | ETF | 119.18 | 119.18 | 119.18 | 119.18 | 500.0 |
| 2010-11-02 06:10:00 | SPY | ETF | 119.13 | 119.15 | 119.12 | 119.15 | 10600.0 |
| 2010-11-02 06:15:00 | SPY | ETF | 119.16 | 119.16 | 119.16 | 119.16 | 200.0 |
| 2010-11-02 06:25:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 100.0 |
| 2010-11-02 06:40:00 | SPY | ETF | 119.22 | 119.28 | 119.22 | 119.28 | 2400.0 |
| 2010-11-02 06:50:00 | SPY | ETF | 119.2 | 119.24 | 119.2 | 119.24 | 200.0 |
| 2010-11-02 06:55:00 | SPY | ETF | 119.21 | 119.22 | 119.21 | 119.22 | 2100.0 |
| 2010-11-02 07:00:00 | SPY | ETF | 119.21 | 119.22 | 119.19 | 119.21 | 40700.0 |
| 2010-11-02 07:05:00 | SPY | ETF | 119.21 | 119.22 | 119.2 | 119.21 | 10495.0 |
| 2010-11-02 07:10:00 | SPY | ETF | 119.21 | 119.21 | 119.19 | 119.21 | 100900.0 |
| 2010-11-02 07:15:00 | SPY | ETF | 119.21 | 119.21 | 119.19 | 119.21 | 16800.0 |
| 2010-11-02 07:20:00 | SPY | ETF | 119.22 | 119.22 | 119.19 | 119.2 | 10500.0 |
| 2010-11-02 07:25:00 | SPY | ETF | 119.21 | 119.3 | 119.19 | 119.29 | 9500.0 |
| 2010-11-02 07:30:00 | SPY | ETF | 119.29 | 119.42 | 119.29 | 119.39 | 46675.0 |
| 2010-11-02 07:35:00 | SPY | ETF | 119.39 | 119.48 | 119.38 | 119.39 | 36570.0 |
| 2010-11-02 07:40:00 | SPY | ETF | 119.39 | 119.45 | 119.38 | 119.45 | 13750.0 |
| 2010-11-02 07:45:00 | SPY | ETF | 119.43 | 119.43 | 119.39 | 119.39 | 155500.0 |
| 2010-11-02 07:50:00 | SPY | ETF | 119.39 | 119.39 | 119.36 | 119.38 | 100500.0 |
| 2010-11-02 07:55:00 | SPY | ETF | 119.39 | 119.43 | 119.38 | 119.4 | 65810.0 |
| 2010-11-02 08:00:00 | SPY | ETF | 119.39 | 119.47 | 118.85 | 119.43 | 109476.0 |
| 2010-11-02 08:05:00 | SPY | ETF | 119.43 | 119.48 | 119.38 | 119.46 | 212914.0 |
| 2010-11-02 08:10:00 | SPY | ETF | 119.46 | 119.49 | 119.41 | 119.42 | 158374.0 |
| 2010-11-02 08:15:00 | SPY | ETF | 119.41 | 119.43 | 119.39 | 119.41 | 39327.0 |
| 2010-11-02 08:20:00 | SPY | ETF | 119.42 | 119.55 | 119.42 | 119.53 | 404518.0 |
| 2010-11-02 08:25:00 | SPY | ETF | 119.52 | 119.59 | 119.52 | 119.54 | 109111.0 |
| 2010-11-02 08:30:00 | SPY | ETF | 119.55 | 119.57 | 119.51 | 119.51 | 43150.0 |
| 2010-11-02 08:35:00 | SPY | ETF | 119.52 | 119.55 | 119.4 | 119.41 | 178820.0 |
| 2010-11-02 08:40:00 | SPY | ETF | 119.41 | 119.45 | 119.4 | 119.45 | 57095.0 |
| 2010-11-02 08:45:00 | SPY | ETF | 119.45 | 119.45 | 119.41 | 119.42 | 93150.0 |
| 2010-11-02 08:50:00 | SPY | ETF | 119.43 | 119.47 | 119.42 | 119.47 | 137452.0 |
| 2010-11-02 08:55:00 | SPY | ETF | 119.47 | 119.47 | 119.42 | 119.42 | 26405.0 |
| 2010-11-02 09:00:00 | SPY | ETF | 119.45 | 119.45 | 119.42 | 119.45 | 98139.0 |
| 2010-11-02 09:05:00 | SPY | ETF | 119.45 | 119.52 | 119.44 | 119.5 | 329440.0 |
| 2010-11-02 09:10:00 | SPY | ETF | 119.5 | 119.5 | 119.43 | 119.43 | 347319.0 |
| 2010-11-02 09:15:00 | SPY | ETF | 119.43 | 119.43 | 119.39 | 119.41 | 64692.0 |
| 2010-11-02 09:20:00 | SPY | ETF | 119.41 | 119.52 | 119.41 | 119.51 | 524393.0 |
| 2010-11-02 09:25:00 | SPY | ETF | 119.52 | 119.57 | 119.41 | 119.43 | 729264.0 |
| 2010-11-02 09:30:00 | SPY | ETF | 119.42 | 119.62 | 119.41 | 119.46 | 5714745.0 |
| 2010-11-02 09:35:00 | SPY | ETF | 119.46 | 119.55 | 119.37 | 119.39 | 5092512.0 |
| 2010-11-02 09:40:00 | SPY | ETF | 119.38 | 119.56 | 119.31 | 119.5 | 4578268.0 |
> showing 50 of 33,901 rows — these rows as CSV