PREVIEW / etf_5min / 2010-03-25
file: by_date/etf_5min/2010/2010-03-25.parquet size: 832 KB rows: 34,769
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-25 04:10:00 | SPY | ETF | 117.09 | 117.09 | 117.09 | 117.09 | 100.0 |
| 2010-03-25 05:20:00 | SPY | ETF | 117.11 | 117.11 | 117.11 | 117.11 | 500.0 |
| 2010-03-25 05:25:00 | SPY | ETF | 117.13 | 117.19 | 117.13 | 117.19 | 655.0 |
| 2010-03-25 05:45:00 | SPY | ETF | 117.21 | 117.31 | 117.21 | 117.29 | 8962.0 |
| 2010-03-25 06:00:00 | SPY | ETF | 117.31 | 117.31 | 117.31 | 117.31 | 200.0 |
| 2010-03-25 06:05:00 | SPY | ETF | 117.36 | 117.36 | 117.36 | 117.36 | 100.0 |
| 2010-03-25 06:20:00 | SPY | ETF | 117.3 | 117.3 | 117.3 | 117.3 | 100.0 |
| 2010-03-25 06:25:00 | SPY | ETF | 117.3 | 117.3 | 117.3 | 117.3 | 250.0 |
| 2010-03-25 07:00:00 | SPY | ETF | 117.29 | 117.32 | 117.29 | 117.32 | 13191.0 |
| 2010-03-25 07:05:00 | SPY | ETF | 117.34 | 117.37 | 117.34 | 117.37 | 8600.0 |
| 2010-03-25 07:10:00 | SPY | ETF | 117.37 | 117.37 | 117.34 | 117.34 | 5600.0 |
| 2010-03-25 07:15:00 | SPY | ETF | 117.34 | 117.34 | 117.34 | 117.34 | 3300.0 |
| 2010-03-25 07:20:00 | SPY | ETF | 117.34 | 117.39 | 117.34 | 117.39 | 30700.0 |
| 2010-03-25 07:25:00 | SPY | ETF | 117.37 | 117.45 | 117.37 | 117.45 | 25609.0 |
| 2010-03-25 07:30:00 | SPY | ETF | 117.47 | 117.5 | 117.45 | 117.5 | 67150.0 |
| 2010-03-25 07:35:00 | SPY | ETF | 117.5 | 117.5 | 117.44 | 117.44 | 16950.0 |
| 2010-03-25 07:40:00 | SPY | ETF | 117.42 | 117.44 | 117.42 | 117.42 | 36000.0 |
| 2010-03-25 07:45:00 | SPY | ETF | 117.42 | 117.47 | 117.42 | 117.44 | 75950.0 |
| 2010-03-25 07:50:00 | SPY | ETF | 117.47 | 117.47 | 117.45 | 117.45 | 10790.0 |
| 2010-03-25 07:55:00 | SPY | ETF | 117.45 | 117.47 | 117.42 | 117.46 | 62800.0 |
| 2010-03-25 08:00:00 | SPY | ETF | 117.45 | 117.48 | 117.2 | 117.46 | 348273.0 |
| 2010-03-25 08:05:00 | SPY | ETF | 117.47 | 117.48 | 117.44 | 117.48 | 50953.0 |
| 2010-03-25 08:10:00 | SPY | ETF | 117.48 | 117.52 | 117.41 | 117.42 | 176801.0 |
| 2010-03-25 08:15:00 | SPY | ETF | 117.41 | 117.45 | 117.39 | 117.4 | 77418.0 |
| 2010-03-25 08:20:00 | SPY | ETF | 117.42 | 117.45 | 117.41 | 117.43 | 268700.0 |
| 2010-03-25 08:25:00 | SPY | ETF | 117.43 | 117.44 | 117.38 | 117.43 | 198949.0 |
| 2010-03-25 08:30:00 | SPY | ETF | 117.44 | 117.51 | 117.37 | 117.41 | 1132751.0 |
| 2010-03-25 08:35:00 | SPY | ETF | 117.41 | 117.41 | 117.36 | 117.4 | 157697.0 |
| 2010-03-25 08:40:00 | SPY | ETF | 117.4 | 117.42 | 117.38 | 117.42 | 88934.0 |
| 2010-03-25 08:45:00 | SPY | ETF | 117.41 | 117.43 | 117.39 | 117.39 | 270997.0 |
| 2010-03-25 08:50:00 | SPY | ETF | 117.4 | 117.48 | 117.4 | 117.47 | 269056.0 |
| 2010-03-25 08:55:00 | SPY | ETF | 117.47 | 117.48 | 117.45 | 117.47 | 134686.0 |
| 2010-03-25 09:00:00 | SPY | ETF | 117.48 | 117.61 | 117.47 | 117.6 | 414395.0 |
| 2010-03-25 09:05:00 | SPY | ETF | 117.61 | 117.7 | 117.6 | 117.69 | 235808.0 |
| 2010-03-25 09:10:00 | SPY | ETF | 117.69 | 117.69 | 117.61 | 117.62 | 361183.0 |
| 2010-03-25 09:15:00 | SPY | ETF | 117.63 | 117.63 | 117.6 | 117.6 | 176751.0 |
| 2010-03-25 09:20:00 | SPY | ETF | 117.61 | 117.61 | 117.57 | 117.59 | 127075.0 |
| 2010-03-25 09:25:00 | SPY | ETF | 117.58 | 117.64 | 117.56 | 117.64 | 308104.0 |
| 2010-03-25 09:30:00 | SPY | ETF | 117.63 | 117.73 | 117.6 | 117.62 | 5554850.0 |
| 2010-03-25 09:35:00 | SPY | ETF | 117.62 | 117.64 | 117.54 | 117.56 | 3382720.0 |
| 2010-03-25 09:40:00 | SPY | ETF | 117.561 | 117.63 | 117.51 | 117.63 | 2611599.0 |
| 2010-03-25 09:45:00 | SPY | ETF | 117.63 | 117.64 | 117.42 | 117.431 | 3175398.0 |
| 2010-03-25 09:50:00 | SPY | ETF | 117.43 | 117.53 | 117.3919 | 117.41 | 2944910.0 |
| 2010-03-25 09:55:00 | SPY | ETF | 117.41 | 117.57 | 117.39 | 117.48 | 2724958.0 |
| 2010-03-25 10:00:00 | SPY | ETF | 117.48 | 117.58 | 117.43 | 117.44 | 3567262.0 |
| 2010-03-25 10:05:00 | SPY | ETF | 117.44 | 117.65 | 117.24 | 117.3699 | 3872622.0 |
| 2010-03-25 10:10:00 | SPY | ETF | 117.37 | 117.5 | 117.34 | 117.47 | 2440216.0 |
| 2010-03-25 10:15:00 | SPY | ETF | 117.48 | 117.65 | 117.35 | 117.5504 | 2318429.0 |
| 2010-03-25 10:20:00 | SPY | ETF | 117.56 | 117.64 | 117.55 | 117.6 | 2333460.0 |
| 2010-03-25 10:25:00 | SPY | ETF | 117.6 | 117.61 | 117.44 | 117.45 | 1654674.0 |
> showing 50 of 34,769 rows — these rows as CSV