PREVIEW / etf_5min / 2009-05-04
file: by_date/etf_5min/2009/2009-05-04.parquet size: 725 KB rows: 31,240
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-05-04 04:15:00 | SPY | ETF | 88.64 | 88.64 | 88.63 | 88.63 | 5300.0 |
| 2009-05-04 04:25:00 | SPY | ETF | 88.66 | 88.66 | 88.66 | 88.66 | 100.0 |
| 2009-05-04 04:35:00 | SPY | ETF | 88.57 | 88.57 | 88.54 | 88.54 | 2800.0 |
| 2009-05-04 04:40:00 | SPY | ETF | 88.59 | 88.62 | 88.59 | 88.62 | 600.0 |
| 2009-05-04 04:50:00 | SPY | ETF | 88.51 | 88.57 | 88.51 | 88.57 | 500.0 |
| 2009-05-04 05:00:00 | SPY | ETF | 88.74 | 88.74 | 88.74 | 88.74 | 300.0 |
| 2009-05-04 05:15:00 | SPY | ETF | 88.8 | 88.8 | 88.8 | 88.8 | 100.0 |
| 2009-05-04 05:30:00 | SPY | ETF | 88.78 | 88.78 | 88.78 | 88.78 | 2500.0 |
| 2009-05-04 05:35:00 | SPY | ETF | 88.8 | 88.8 | 88.78 | 88.78 | 25300.0 |
| 2009-05-04 05:40:00 | SPY | ETF | 88.8 | 88.8 | 88.76 | 88.76 | 2230.0 |
| 2009-05-04 05:45:00 | SPY | ETF | 88.74 | 88.74 | 88.74 | 88.74 | 500.0 |
| 2009-05-04 05:50:00 | SPY | ETF | 88.75 | 88.75 | 88.75 | 88.75 | 10800.0 |
| 2009-05-04 05:55:00 | SPY | ETF | 88.73 | 88.73 | 88.73 | 88.73 | 300.0 |
| 2009-05-04 06:00:00 | SPY | ETF | 88.73 | 88.73 | 88.66 | 88.66 | 1400.0 |
| 2009-05-04 06:05:00 | SPY | ETF | 88.66 | 88.67 | 88.66 | 88.67 | 300.0 |
| 2009-05-04 06:10:00 | SPY | ETF | 88.65 | 88.65 | 88.62 | 88.62 | 4500.0 |
| 2009-05-04 06:30:00 | SPY | ETF | 88.62 | 88.62 | 88.62 | 88.62 | 100.0 |
| 2009-05-04 06:35:00 | SPY | ETF | 88.56 | 88.56 | 88.56 | 88.56 | 800.0 |
| 2009-05-04 06:40:00 | SPY | ETF | 88.58 | 88.58 | 88.52 | 88.54 | 13200.0 |
| 2009-05-04 06:45:00 | SPY | ETF | 88.54 | 88.54 | 88.54 | 88.54 | 7300.0 |
| 2009-05-04 06:50:00 | SPY | ETF | 88.5 | 88.5 | 88.5 | 88.5 | 1509.0 |
| 2009-05-04 06:55:00 | SPY | ETF | 88.5 | 88.53 | 88.49 | 88.49 | 1669.0 |
| 2009-05-04 07:00:00 | SPY | ETF | 88.49 | 88.55 | 88.49 | 88.53 | 15819.0 |
| 2009-05-04 07:05:00 | SPY | ETF | 88.51 | 88.51 | 88.41 | 88.42 | 110368.0 |
| 2009-05-04 07:10:00 | SPY | ETF | 88.43 | 88.53 | 88.39 | 88.51 | 33789.0 |
| 2009-05-04 07:15:00 | SPY | ETF | 88.5 | 88.53 | 88.38 | 88.38 | 84625.0 |
| 2009-05-04 07:20:00 | SPY | ETF | 88.37 | 88.38 | 88.3 | 88.33 | 49969.0 |
| 2009-05-04 07:25:00 | SPY | ETF | 88.31 | 88.34 | 88.26 | 88.34 | 6200.0 |
| 2009-05-04 07:30:00 | SPY | ETF | 88.31 | 88.37 | 88.29 | 88.36 | 51836.0 |
| 2009-05-04 07:35:00 | SPY | ETF | 88.37 | 88.4 | 88.36 | 88.38 | 29516.0 |
| 2009-05-04 07:40:00 | SPY | ETF | 88.37 | 88.46 | 88.37 | 88.43 | 43150.0 |
| 2009-05-04 07:45:00 | SPY | ETF | 88.44 | 88.53 | 88.44 | 88.46 | 34948.0 |
| 2009-05-04 07:50:00 | SPY | ETF | 88.46 | 88.46 | 88.42 | 88.45 | 11671.0 |
| 2009-05-04 07:55:00 | SPY | ETF | 88.45 | 88.49 | 88.45 | 88.48 | 10303.0 |
| 2009-05-04 08:00:00 | SPY | ETF | 88.48 | 88.93 | 88.47 | 88.52 | 945211.0 |
| 2009-05-04 08:05:00 | SPY | ETF | 88.52 | 88.53 | 88.398 | 88.53 | 166372.0 |
| 2009-05-04 08:10:00 | SPY | ETF | 88.52 | 88.58 | 88.51 | 88.58 | 58031.0 |
| 2009-05-04 08:15:00 | SPY | ETF | 88.58 | 88.61 | 88.54 | 88.54 | 164139.0 |
| 2009-05-04 08:20:00 | SPY | ETF | 88.54 | 88.665 | 88.37 | 88.37 | 148012.0 |
| 2009-05-04 08:25:00 | SPY | ETF | 88.37 | 88.6 | 88.31 | 88.36 | 299967.0 |
| 2009-05-04 08:30:00 | SPY | ETF | 88.36 | 88.38 | 88.25 | 88.29 | 244871.0 |
| 2009-05-04 08:35:00 | SPY | ETF | 88.29 | 88.35 | 88.29 | 88.35 | 63468.0 |
| 2009-05-04 08:40:00 | SPY | ETF | 88.35 | 88.4 | 88.32 | 88.35 | 150687.0 |
| 2009-05-04 08:45:00 | SPY | ETF | 88.35 | 88.46 | 88.31 | 88.42 | 330163.0 |
| 2009-05-04 08:50:00 | SPY | ETF | 88.43 | 88.54 | 88.4 | 88.53 | 783984.0 |
| 2009-05-04 08:55:00 | SPY | ETF | 88.52 | 88.54 | 88.46 | 88.5 | 286722.0 |
| 2009-05-04 09:00:00 | SPY | ETF | 88.51 | 88.55 | 88.49 | 88.51 | 371930.0 |
| 2009-05-04 09:05:00 | SPY | ETF | 88.51 | 88.52 | 88.45 | 88.48 | 100422.0 |
| 2009-05-04 09:10:00 | SPY | ETF | 88.48 | 88.52 | 88.45 | 88.5 | 120508.0 |
| 2009-05-04 09:15:00 | SPY | ETF | 88.49 | 88.58 | 88.48 | 88.55 | 207402.0 |
> showing 50 of 31,240 rows — these rows as CSV