PREVIEW / etf_5min / 2009-08-12
file: by_date/etf_5min/2009/2009-08-12.parquet size: 717 KB rows: 30,152
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-08-12 04:05:00 | SPY | ETF | 99.37 | 99.37 | 99.37 | 99.37 | 2000.0 |
| 2009-08-12 04:15:00 | SPY | ETF | 99.36 | 99.37 | 99.27 | 99.27 | 4200.0 |
| 2009-08-12 04:20:00 | SPY | ETF | 99.36 | 99.36 | 99.29 | 99.29 | 10379.0 |
| 2009-08-12 04:25:00 | SPY | ETF | 99.28 | 99.37 | 99.28 | 99.37 | 5700.0 |
| 2009-08-12 04:30:00 | SPY | ETF | 99.42 | 99.42 | 99.42 | 99.42 | 100.0 |
| 2009-08-12 04:40:00 | SPY | ETF | 99.43 | 99.43 | 99.43 | 99.43 | 5600.0 |
| 2009-08-12 04:45:00 | SPY | ETF | 99.47 | 99.47 | 99.47 | 99.47 | 100.0 |
| 2009-08-12 05:05:00 | SPY | ETF | 99.57 | 99.57 | 99.57 | 99.57 | 100.0 |
| 2009-08-12 05:30:00 | SPY | ETF | 99.51 | 99.51 | 99.43 | 99.43 | 500.0 |
| 2009-08-12 05:40:00 | SPY | ETF | 99.57 | 99.57 | 99.57 | 99.57 | 100.0 |
| 2009-08-12 06:05:00 | SPY | ETF | 99.67 | 99.67 | 99.67 | 99.67 | 100.0 |
| 2009-08-12 06:10:00 | SPY | ETF | 99.77 | 99.77 | 99.77 | 99.77 | 100.0 |
| 2009-08-12 06:15:00 | SPY | ETF | 99.85 | 99.87 | 99.85 | 99.87 | 200.0 |
| 2009-08-12 06:20:00 | SPY | ETF | 99.8 | 99.8 | 99.8 | 99.8 | 1000.0 |
| 2009-08-12 06:25:00 | SPY | ETF | 99.8 | 99.8 | 99.8 | 99.8 | 2000.0 |
| 2009-08-12 06:30:00 | SPY | ETF | 99.83 | 99.83 | 99.83 | 99.83 | 100.0 |
| 2009-08-12 06:35:00 | SPY | ETF | 99.85 | 99.85 | 99.85 | 99.85 | 100.0 |
| 2009-08-12 06:45:00 | SPY | ETF | 99.93 | 99.93 | 99.93 | 99.93 | 100.0 |
| 2009-08-12 06:50:00 | SPY | ETF | 99.91 | 99.91 | 99.9 | 99.9 | 3900.0 |
| 2009-08-12 06:55:00 | SPY | ETF | 99.83 | 99.86 | 99.83 | 99.86 | 1200.0 |
| 2009-08-12 07:00:00 | SPY | ETF | 99.86 | 99.89 | 99.83 | 99.83 | 56900.0 |
| 2009-08-12 07:05:00 | SPY | ETF | 99.84 | 99.89 | 99.81 | 99.84 | 11706.0 |
| 2009-08-12 07:10:00 | SPY | ETF | 99.82 | 99.84 | 99.82 | 99.84 | 3100.0 |
| 2009-08-12 07:15:00 | SPY | ETF | 99.79 | 99.79 | 99.77 | 99.77 | 779.0 |
| 2009-08-12 07:20:00 | SPY | ETF | 99.75 | 99.77 | 99.71 | 99.71 | 7568.0 |
| 2009-08-12 07:25:00 | SPY | ETF | 99.77 | 99.81 | 99.76 | 99.76 | 37368.0 |
| 2009-08-12 07:30:00 | SPY | ETF | 99.74 | 99.77 | 99.71 | 99.77 | 19656.0 |
| 2009-08-12 07:35:00 | SPY | ETF | 99.77 | 99.79 | 99.72 | 99.72 | 59218.0 |
| 2009-08-12 07:40:00 | SPY | ETF | 99.72 | 99.72 | 99.63 | 99.66 | 55525.0 |
| 2009-08-12 07:45:00 | SPY | ETF | 99.66 | 99.67 | 99.56 | 99.61 | 155614.0 |
| 2009-08-12 07:50:00 | SPY | ETF | 99.62 | 99.62 | 99.48 | 99.49 | 138625.0 |
| 2009-08-12 07:55:00 | SPY | ETF | 99.5 | 99.58 | 99.49 | 99.56 | 22522.0 |
| 2009-08-12 08:00:00 | SPY | ETF | 99.56 | 99.9 | 99.55 | 99.76 | 171019.0 |
| 2009-08-12 08:05:00 | SPY | ETF | 99.77 | 99.84 | 99.73 | 99.84 | 302995.0 |
| 2009-08-12 08:10:00 | SPY | ETF | 99.85 | 99.89 | 99.81 | 99.84 | 145044.0 |
| 2009-08-12 08:15:00 | SPY | ETF | 99.85 | 99.91 | 99.83 | 99.83 | 75156.0 |
| 2009-08-12 08:20:00 | SPY | ETF | 99.84 | 99.88 | 99.75 | 99.8 | 117229.0 |
| 2009-08-12 08:25:00 | SPY | ETF | 99.81 | 99.83 | 99.76 | 99.78 | 28679.0 |
| 2009-08-12 08:30:00 | SPY | ETF | 99.76 | 99.81 | 99.68 | 99.68 | 220059.0 |
| 2009-08-12 08:35:00 | SPY | ETF | 99.69 | 99.7 | 99.56 | 99.67 | 295107.0 |
| 2009-08-12 08:40:00 | SPY | ETF | 99.68 | 99.71 | 99.64 | 99.7 | 104401.0 |
| 2009-08-12 08:45:00 | SPY | ETF | 99.69 | 99.75 | 99.68 | 99.73 | 82290.0 |
| 2009-08-12 08:50:00 | SPY | ETF | 99.74 | 99.74 | 99.64 | 99.64 | 155677.0 |
| 2009-08-12 08:55:00 | SPY | ETF | 99.64 | 99.68 | 99.6 | 99.6 | 58032.0 |
| 2009-08-12 09:00:00 | SPY | ETF | 99.61 | 99.7 | 99.58 | 99.64 | 453558.0 |
| 2009-08-12 09:05:00 | SPY | ETF | 99.65 | 99.73 | 99.64 | 99.67 | 247849.0 |
| 2009-08-12 09:10:00 | SPY | ETF | 99.67 | 99.69 | 99.62 | 99.67 | 152674.0 |
| 2009-08-12 09:15:00 | SPY | ETF | 99.67 | 99.68 | 99.61 | 99.62 | 204229.0 |
| 2009-08-12 09:20:00 | SPY | ETF | 99.63 | 99.63 | 99.58 | 99.59 | 25045.0 |
| 2009-08-12 09:25:00 | SPY | ETF | 99.58 | 99.58 | 99.51 | 99.53 | 175525.0 |
> showing 50 of 30,152 rows — these rows as CSV