PREVIEW / etf_5min / 2009-02-24
file: by_date/etf_5min/2009/2009-02-24.parquet size: 716 KB rows: 29,717
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-24 04:15:00 | SPY | ETF | 75.68 | 75.8 | 75.65 | 75.65 | 1100.0 |
| 2009-02-24 04:20:00 | SPY | ETF | 75.62 | 75.62 | 75.62 | 75.62 | 100.0 |
| 2009-02-24 04:25:00 | SPY | ETF | 75.6 | 75.6 | 75.6 | 75.6 | 2500.0 |
| 2009-02-24 04:35:00 | SPY | ETF | 75.42 | 75.42 | 75.4 | 75.41 | 500.0 |
| 2009-02-24 04:40:00 | SPY | ETF | 75.33 | 75.33 | 75.33 | 75.33 | 5000.0 |
| 2009-02-24 04:45:00 | SPY | ETF | 75.3 | 75.3 | 75.3 | 75.3 | 5000.0 |
| 2009-02-24 04:55:00 | SPY | ETF | 75.2 | 75.2 | 75.2 | 75.2 | 100.0 |
| 2009-02-24 05:15:00 | SPY | ETF | 75.3 | 75.3 | 75.25 | 75.27 | 400.0 |
| 2009-02-24 05:30:00 | SPY | ETF | 75.43 | 75.59 | 75.43 | 75.59 | 2600.0 |
| 2009-02-24 05:40:00 | SPY | ETF | 75.5 | 75.5 | 75.5 | 75.5 | 100.0 |
| 2009-02-24 06:00:00 | SPY | ETF | 75.51 | 75.61 | 75.5 | 75.61 | 20000.0 |
| 2009-02-24 06:05:00 | SPY | ETF | 75.69 | 75.77 | 75.69 | 75.77 | 1200.0 |
| 2009-02-24 06:15:00 | SPY | ETF | 75.84 | 75.86 | 75.82 | 75.86 | 1700.0 |
| 2009-02-24 06:20:00 | SPY | ETF | 75.82 | 75.82 | 75.75 | 75.75 | 1500.0 |
| 2009-02-24 06:25:00 | SPY | ETF | 75.72 | 75.72 | 75.7 | 75.7 | 3200.0 |
| 2009-02-24 06:35:00 | SPY | ETF | 75.57 | 75.57 | 75.57 | 75.57 | 200.0 |
| 2009-02-24 06:40:00 | SPY | ETF | 75.6 | 75.6 | 75.6 | 75.6 | 200.0 |
| 2009-02-24 06:45:00 | SPY | ETF | 75.48 | 75.5 | 75.48 | 75.5 | 200.0 |
| 2009-02-24 06:50:00 | SPY | ETF | 75.5 | 75.5 | 75.36 | 75.36 | 8600.0 |
| 2009-02-24 07:00:00 | SPY | ETF | 75.38 | 75.41 | 75.38 | 75.41 | 6100.0 |
| 2009-02-24 07:05:00 | SPY | ETF | 75.39 | 75.45 | 75.35 | 75.45 | 30738.0 |
| 2009-02-24 07:10:00 | SPY | ETF | 75.5 | 75.63 | 75.47 | 75.6 | 138998.0 |
| 2009-02-24 07:15:00 | SPY | ETF | 75.61 | 75.68 | 75.59 | 75.62 | 32369.0 |
| 2009-02-24 07:20:00 | SPY | ETF | 75.61 | 75.65 | 75.5 | 75.5 | 66069.0 |
| 2009-02-24 07:25:00 | SPY | ETF | 75.54 | 75.55 | 75.52 | 75.54 | 21200.0 |
| 2009-02-24 07:30:00 | SPY | ETF | 75.55 | 75.55 | 75.38 | 75.47 | 74114.0 |
| 2009-02-24 07:35:00 | SPY | ETF | 75.46 | 75.48 | 75.43 | 75.47 | 21868.0 |
| 2009-02-24 07:40:00 | SPY | ETF | 75.48 | 75.68 | 75.48 | 75.61 | 186952.0 |
| 2009-02-24 07:45:00 | SPY | ETF | 75.6 | 75.75 | 75.58 | 75.68 | 56594.0 |
| 2009-02-24 07:50:00 | SPY | ETF | 75.68 | 75.73 | 75.64 | 75.73 | 34900.0 |
| 2009-02-24 07:55:00 | SPY | ETF | 75.71 | 75.72 | 75.62 | 75.65 | 23200.0 |
| 2009-02-24 08:00:00 | SPY | ETF | 75.65 | 75.7 | 75.6 | 75.61 | 160239.0 |
| 2009-02-24 08:05:00 | SPY | ETF | 75.63 | 75.63 | 75.46 | 75.53 | 110593.0 |
| 2009-02-24 08:10:00 | SPY | ETF | 75.51 | 75.63 | 75.5 | 75.61 | 56583.0 |
| 2009-02-24 08:15:00 | SPY | ETF | 75.61 | 75.64 | 75.46 | 75.53 | 262642.0 |
| 2009-02-24 08:20:00 | SPY | ETF | 75.54 | 75.76 | 75.42 | 75.58 | 319204.0 |
| 2009-02-24 08:25:00 | SPY | ETF | 75.58 | 75.66 | 75.46 | 75.46 | 443450.0 |
| 2009-02-24 08:30:00 | SPY | ETF | 75.46 | 75.47 | 75.34 | 75.34 | 230696.0 |
| 2009-02-24 08:35:00 | SPY | ETF | 75.34 | 75.35 | 75.25 | 75.25 | 351113.0 |
| 2009-02-24 08:40:00 | SPY | ETF | 75.25 | 75.27 | 75.08 | 75.08 | 393733.0 |
| 2009-02-24 08:45:00 | SPY | ETF | 75.07 | 75.16 | 75.01 | 75.15 | 698512.0 |
| 2009-02-24 08:50:00 | SPY | ETF | 75.15 | 75.2 | 75.03 | 75.16 | 199315.0 |
| 2009-02-24 08:55:00 | SPY | ETF | 75.17 | 75.18 | 75.08 | 75.1 | 250566.0 |
| 2009-02-24 09:00:00 | SPY | ETF | 75.11 | 75.41 | 75.1 | 75.39 | 423632.0 |
| 2009-02-24 09:05:00 | SPY | ETF | 75.4 | 75.6 | 75.39 | 75.41 | 569293.0 |
| 2009-02-24 09:10:00 | SPY | ETF | 75.4 | 75.46 | 75.36 | 75.37 | 127212.0 |
| 2009-02-24 09:15:00 | SPY | ETF | 75.36 | 75.56 | 75.36 | 75.5 | 417829.0 |
| 2009-02-24 09:20:00 | SPY | ETF | 75.5 | 75.63 | 75.42 | 75.43 | 386098.0 |
| 2009-02-24 09:25:00 | SPY | ETF | 75.42 | 75.46 | 75.28 | 75.3 | 249585.0 |
| 2009-02-24 09:30:00 | SPY | ETF | 75.29 | 75.39 | 75.15 | 75.38 | 6961389.0 |
> showing 50 of 29,717 rows — these rows as CSV