PREVIEW / etf_5min / 2009-04-06
file: by_date/etf_5min/2009/2009-04-06.parquet size: 662 KB rows: 28,322
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-04-06 04:15:00 | SPY | ETF | 84.99 | 85.08 | 84.99 | 85.08 | 800.0 |
| 2009-04-06 04:25:00 | SPY | ETF | 84.79 | 84.83 | 84.79 | 84.83 | 855.0 |
| 2009-04-06 04:30:00 | SPY | ETF | 84.83 | 84.83 | 84.83 | 84.83 | 2000.0 |
| 2009-04-06 04:35:00 | SPY | ETF | 84.95 | 84.95 | 84.95 | 84.95 | 7500.0 |
| 2009-04-06 04:40:00 | SPY | ETF | 84.98 | 85.0 | 84.93 | 85.0 | 446.0 |
| 2009-04-06 04:50:00 | SPY | ETF | 84.93 | 84.93 | 84.93 | 84.93 | 354.0 |
| 2009-04-06 05:00:00 | SPY | ETF | 84.81 | 84.81 | 84.81 | 84.81 | 400.0 |
| 2009-04-06 05:20:00 | SPY | ETF | 84.84 | 84.84 | 84.74 | 84.74 | 2200.0 |
| 2009-04-06 05:25:00 | SPY | ETF | 84.76 | 84.76 | 84.76 | 84.76 | 400.0 |
| 2009-04-06 05:35:00 | SPY | ETF | 84.93 | 84.93 | 84.93 | 84.93 | 100.0 |
| 2009-04-06 05:40:00 | SPY | ETF | 85.0 | 85.0 | 85.0 | 85.0 | 100.0 |
| 2009-04-06 05:50:00 | SPY | ETF | 84.86 | 84.86 | 84.76 | 84.76 | 2700.0 |
| 2009-04-06 05:55:00 | SPY | ETF | 84.71 | 84.74 | 84.71 | 84.71 | 700.0 |
| 2009-04-06 06:00:00 | SPY | ETF | 84.71 | 84.71 | 84.71 | 84.71 | 300.0 |
| 2009-04-06 06:05:00 | SPY | ETF | 84.66 | 84.66 | 84.64 | 84.64 | 2000.0 |
| 2009-04-06 06:10:00 | SPY | ETF | 84.64 | 84.64 | 84.64 | 84.64 | 2000.0 |
| 2009-04-06 06:25:00 | SPY | ETF | 84.79 | 84.79 | 84.79 | 84.79 | 100.0 |
| 2009-04-06 06:35:00 | SPY | ETF | 84.81 | 84.81 | 84.81 | 84.81 | 100.0 |
| 2009-04-06 06:45:00 | SPY | ETF | 84.78 | 84.78 | 84.71 | 84.71 | 200.0 |
| 2009-04-06 06:50:00 | SPY | ETF | 84.75 | 84.75 | 84.74 | 84.75 | 800.0 |
| 2009-04-06 06:55:00 | SPY | ETF | 84.73 | 84.76 | 84.69 | 84.69 | 2700.0 |
| 2009-04-06 07:00:00 | SPY | ETF | 84.7 | 84.7 | 84.68 | 84.68 | 700.0 |
| 2009-04-06 07:05:00 | SPY | ETF | 84.68 | 84.68 | 84.62 | 84.62 | 2650.0 |
| 2009-04-06 07:10:00 | SPY | ETF | 84.62 | 84.69 | 84.61 | 84.61 | 7650.0 |
| 2009-04-06 07:15:00 | SPY | ETF | 84.61 | 84.61 | 84.44 | 84.49 | 91409.0 |
| 2009-04-06 07:20:00 | SPY | ETF | 84.46 | 84.46 | 84.34 | 84.36 | 63800.0 |
| 2009-04-06 07:25:00 | SPY | ETF | 84.36 | 84.42 | 84.34 | 84.38 | 39137.0 |
| 2009-04-06 07:30:00 | SPY | ETF | 84.38 | 84.38 | 84.06 | 84.07 | 240991.0 |
| 2009-04-06 07:35:00 | SPY | ETF | 84.06 | 84.1 | 84.01 | 84.1 | 195141.0 |
| 2009-04-06 07:40:00 | SPY | ETF | 84.1 | 84.13 | 84.05 | 84.1 | 57100.0 |
| 2009-04-06 07:45:00 | SPY | ETF | 84.09 | 84.15 | 84.08 | 84.13 | 35450.0 |
| 2009-04-06 07:50:00 | SPY | ETF | 84.1 | 84.13 | 84.07 | 84.1 | 59879.0 |
| 2009-04-06 07:55:00 | SPY | ETF | 84.06 | 84.06 | 83.96 | 84.0 | 18000.0 |
| 2009-04-06 08:00:00 | SPY | ETF | 84.945 | 85.1 | 83.98 | 83.98 | 523157.0 |
| 2009-04-06 08:05:00 | SPY | ETF | 83.99 | 83.99 | 83.91 | 83.95 | 58427.0 |
| 2009-04-06 08:10:00 | SPY | ETF | 83.95 | 83.96 | 83.76 | 83.81 | 693453.0 |
| 2009-04-06 08:15:00 | SPY | ETF | 83.81 | 83.81 | 83.72 | 83.72 | 278752.0 |
| 2009-04-06 08:20:00 | SPY | ETF | 83.73 | 83.78 | 83.6 | 83.67 | 577852.0 |
| 2009-04-06 08:25:00 | SPY | ETF | 83.67 | 83.7 | 83.58 | 83.59 | 120441.0 |
| 2009-04-06 08:30:00 | SPY | ETF | 83.6 | 83.63 | 83.54 | 83.63 | 113864.0 |
| 2009-04-06 08:35:00 | SPY | ETF | 83.63 | 83.65 | 83.51 | 83.55 | 198624.0 |
| 2009-04-06 08:40:00 | SPY | ETF | 83.56 | 83.62 | 83.42 | 83.46 | 312779.0 |
| 2009-04-06 08:45:00 | SPY | ETF | 83.45 | 83.6 | 83.43 | 83.58 | 230754.0 |
| 2009-04-06 08:50:00 | SPY | ETF | 83.57 | 83.62 | 83.54 | 83.6 | 97191.0 |
| 2009-04-06 08:55:00 | SPY | ETF | 83.62 | 83.62 | 83.51 | 83.55 | 145434.0 |
| 2009-04-06 09:00:00 | SPY | ETF | 83.54 | 83.55 | 83.39 | 83.52 | 348233.0 |
| 2009-04-06 09:05:00 | SPY | ETF | 83.53 | 83.53 | 83.37 | 83.43 | 255716.0 |
| 2009-04-06 09:10:00 | SPY | ETF | 83.43 | 83.44 | 83.23 | 83.28 | 548720.0 |
| 2009-04-06 09:15:00 | SPY | ETF | 83.28 | 83.3 | 83.18 | 83.28 | 216043.0 |
| 2009-04-06 09:20:00 | SPY | ETF | 83.28 | 83.34 | 83.27 | 83.29 | 689990.0 |
> showing 50 of 28,322 rows — these rows as CSV