PREVIEW / etf_5min / 2009-02-03
file: by_date/etf_5min/2009/2009-02-03.parquet size: 642 KB rows: 27,274
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-03 04:15:00 | SPY | ETF | 82.9 | 82.9 | 82.9 | 82.9 | 900.0 |
| 2009-02-03 04:25:00 | SPY | ETF | 82.65 | 82.67 | 82.65 | 82.67 | 500.0 |
| 2009-02-03 04:40:00 | SPY | ETF | 82.57 | 82.57 | 82.57 | 82.57 | 100.0 |
| 2009-02-03 04:45:00 | SPY | ETF | 82.62 | 82.62 | 82.62 | 82.62 | 100.0 |
| 2009-02-03 05:10:00 | SPY | ETF | 82.17 | 82.17 | 82.17 | 82.17 | 106.0 |
| 2009-02-03 05:45:00 | SPY | ETF | 82.25 | 82.25 | 82.18 | 82.18 | 7500.0 |
| 2009-02-03 05:50:00 | SPY | ETF | 82.2 | 82.2 | 82.2 | 82.2 | 2500.0 |
| 2009-02-03 05:55:00 | SPY | ETF | 82.11 | 82.11 | 82.11 | 82.11 | 400.0 |
| 2009-02-03 06:00:00 | SPY | ETF | 82.21 | 82.21 | 82.21 | 82.21 | 5000.0 |
| 2009-02-03 06:05:00 | SPY | ETF | 82.26 | 82.26 | 82.26 | 82.26 | 100.0 |
| 2009-02-03 06:15:00 | SPY | ETF | 82.41 | 82.41 | 82.41 | 82.41 | 5000.0 |
| 2009-02-03 06:25:00 | SPY | ETF | 82.54 | 82.59 | 82.54 | 82.59 | 7300.0 |
| 2009-02-03 06:45:00 | SPY | ETF | 82.24 | 82.24 | 82.24 | 82.24 | 100.0 |
| 2009-02-03 06:50:00 | SPY | ETF | 82.29 | 82.29 | 82.29 | 82.29 | 700.0 |
| 2009-02-03 06:55:00 | SPY | ETF | 82.3 | 82.35 | 82.3 | 82.35 | 9000.0 |
| 2009-02-03 07:00:00 | SPY | ETF | 82.35 | 82.44 | 82.28 | 82.33 | 55794.0 |
| 2009-02-03 07:05:00 | SPY | ETF | 82.4 | 82.43 | 82.37 | 82.41 | 13969.0 |
| 2009-02-03 07:10:00 | SPY | ETF | 82.41 | 82.5 | 82.41 | 82.45 | 68500.0 |
| 2009-02-03 07:15:00 | SPY | ETF | 82.49 | 82.53 | 82.49 | 82.53 | 1569.0 |
| 2009-02-03 07:20:00 | SPY | ETF | 82.55 | 82.79 | 82.5 | 82.74 | 49033.0 |
| 2009-02-03 07:25:00 | SPY | ETF | 82.74 | 82.74 | 82.65 | 82.7 | 83706.0 |
| 2009-02-03 07:30:00 | SPY | ETF | 82.79 | 82.98 | 82.78 | 82.87 | 206791.0 |
| 2009-02-03 07:35:00 | SPY | ETF | 82.84 | 82.85 | 82.81 | 82.81 | 35795.0 |
| 2009-02-03 07:40:00 | SPY | ETF | 82.84 | 82.84 | 82.69 | 82.69 | 148450.0 |
| 2009-02-03 07:45:00 | SPY | ETF | 82.68 | 82.72 | 82.48 | 82.58 | 72739.0 |
| 2009-02-03 07:50:00 | SPY | ETF | 82.57 | 82.68 | 82.57 | 82.63 | 42465.0 |
| 2009-02-03 07:55:00 | SPY | ETF | 82.63 | 82.76 | 82.63 | 82.72 | 71688.0 |
| 2009-02-03 08:00:00 | SPY | ETF | 82.07 | 82.76 | 82.07 | 82.08 | 982419.0 |
| 2009-02-03 08:05:00 | SPY | ETF | 82.68 | 82.74 | 82.55 | 82.72 | 64250.0 |
| 2009-02-03 08:10:00 | SPY | ETF | 82.72 | 82.8 | 82.57 | 82.61 | 100246.0 |
| 2009-02-03 08:15:00 | SPY | ETF | 82.61 | 83.2 | 82.47 | 82.5 | 80044.0 |
| 2009-02-03 08:20:00 | SPY | ETF | 82.51 | 82.59 | 82.5 | 82.58 | 94194.0 |
| 2009-02-03 08:25:00 | SPY | ETF | 82.58 | 82.59 | 82.48 | 82.49 | 141330.0 |
| 2009-02-03 08:30:00 | SPY | ETF | 82.5 | 82.61 | 82.46 | 82.57 | 42034.0 |
| 2009-02-03 08:35:00 | SPY | ETF | 82.57 | 82.61 | 82.5 | 82.5 | 40835.0 |
| 2009-02-03 08:40:00 | SPY | ETF | 82.5 | 82.58 | 82.49 | 82.53 | 39178.0 |
| 2009-02-03 08:45:00 | SPY | ETF | 82.53 | 82.78 | 82.53 | 82.75 | 83954.0 |
| 2009-02-03 08:50:00 | SPY | ETF | 82.74 | 82.83 | 82.71 | 82.75 | 219123.0 |
| 2009-02-03 08:55:00 | SPY | ETF | 82.76 | 82.85 | 82.73 | 82.78 | 331469.0 |
| 2009-02-03 09:00:00 | SPY | ETF | 82.78 | 82.94 | 82.78 | 82.9 | 438982.0 |
| 2009-02-03 09:05:00 | SPY | ETF | 82.89 | 82.99 | 82.87 | 82.99 | 363751.0 |
| 2009-02-03 09:10:00 | SPY | ETF | 82.99 | 83.15 | 82.99 | 83.09 | 614833.0 |
| 2009-02-03 09:15:00 | SPY | ETF | 83.08 | 83.13 | 83.05 | 83.08 | 453169.0 |
| 2009-02-03 09:20:00 | SPY | ETF | 83.07 | 83.11 | 83.01 | 83.04 | 336232.0 |
| 2009-02-03 09:25:00 | SPY | ETF | 83.04 | 83.19 | 83.03 | 83.11 | 289497.0 |
| 2009-02-03 09:30:00 | SPY | ETF | 83.1 | 83.24 | 82.84 | 82.93 | 7076967.0 |
| 2009-02-03 09:35:00 | SPY | ETF | 82.92 | 83.06 | 82.68 | 82.74 | 3910527.0 |
| 2009-02-03 09:40:00 | SPY | ETF | 82.74 | 82.85 | 82.53 | 82.62 | 5018619.0 |
| 2009-02-03 09:45:00 | SPY | ETF | 82.62 | 82.76 | 82.31 | 82.48 | 4763593.0 |
| 2009-02-03 09:50:00 | SPY | ETF | 82.48 | 82.76 | 82.22 | 82.38 | 5121365.0 |
> showing 50 of 27,274 rows — these rows as CSV