PREVIEW / etf_5min / 2010-04-13
file: by_date/etf_5min/2010/2010-04-13.parquet size: 756 KB rows: 32,049
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-04-13 04:15:00 | SPY | ETF | 119.51 | 119.51 | 119.51 | 119.51 | 200.0 |
| 2010-04-13 04:55:00 | SPY | ETF | 119.39 | 119.39 | 119.39 | 119.39 | 930.0 |
| 2010-04-13 05:15:00 | SPY | ETF | 119.36 | 119.37 | 119.36 | 119.37 | 5000.0 |
| 2010-04-13 05:20:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 5000.0 |
| 2010-04-13 05:25:00 | SPY | ETF | 119.37 | 119.37 | 119.37 | 119.37 | 1000.0 |
| 2010-04-13 05:30:00 | SPY | ETF | 119.32 | 119.32 | 119.32 | 119.32 | 500.0 |
| 2010-04-13 05:35:00 | SPY | ETF | 119.37 | 119.37 | 119.36 | 119.37 | 486.0 |
| 2010-04-13 05:55:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 15000.0 |
| 2010-04-13 06:25:00 | SPY | ETF | 119.49 | 119.49 | 119.49 | 119.49 | 100.0 |
| 2010-04-13 06:35:00 | SPY | ETF | 119.49 | 119.49 | 119.49 | 119.49 | 700.0 |
| 2010-04-13 06:40:00 | SPY | ETF | 119.48 | 119.48 | 119.48 | 119.48 | 2000.0 |
| 2010-04-13 06:45:00 | SPY | ETF | 119.52 | 119.53 | 119.52 | 119.53 | 10000.0 |
| 2010-04-13 07:00:00 | SPY | ETF | 119.48 | 119.48 | 119.38 | 119.39 | 281800.0 |
| 2010-04-13 07:05:00 | SPY | ETF | 119.39 | 119.39 | 119.38 | 119.39 | 84100.0 |
| 2010-04-13 07:10:00 | SPY | ETF | 119.39 | 119.42 | 119.39 | 119.41 | 26600.0 |
| 2010-04-13 07:15:00 | SPY | ETF | 119.42 | 119.44 | 119.42 | 119.44 | 54100.0 |
| 2010-04-13 07:20:00 | SPY | ETF | 119.44 | 119.45 | 119.41 | 119.45 | 61271.0 |
| 2010-04-13 07:25:00 | SPY | ETF | 119.44 | 119.48 | 119.44 | 119.46 | 41253.0 |
| 2010-04-13 07:30:00 | SPY | ETF | 119.44 | 119.44 | 119.43 | 119.44 | 47900.0 |
| 2010-04-13 07:35:00 | SPY | ETF | 119.44 | 119.45 | 119.39 | 119.42 | 54710.0 |
| 2010-04-13 07:40:00 | SPY | ETF | 119.41 | 119.45 | 119.41 | 119.44 | 13051.0 |
| 2010-04-13 07:45:00 | SPY | ETF | 119.45 | 119.45 | 119.42 | 119.45 | 28150.0 |
| 2010-04-13 07:50:00 | SPY | ETF | 119.45 | 119.48 | 119.45 | 119.48 | 114600.0 |
| 2010-04-13 07:55:00 | SPY | ETF | 119.46 | 119.46 | 119.46 | 119.46 | 1000.0 |
| 2010-04-13 08:00:00 | SPY | ETF | 119.45 | 119.52 | 119.2 | 119.44 | 247734.0 |
| 2010-04-13 08:05:00 | SPY | ETF | 119.44 | 119.55 | 119.44 | 119.52 | 542400.0 |
| 2010-04-13 08:10:00 | SPY | ETF | 119.52 | 119.56 | 119.52 | 119.54 | 32116.0 |
| 2010-04-13 08:15:00 | SPY | ETF | 119.54 | 119.59 | 119.54 | 119.58 | 24052.0 |
| 2010-04-13 08:20:00 | SPY | ETF | 119.58 | 119.66 | 119.58 | 119.63 | 73630.0 |
| 2010-04-13 08:25:00 | SPY | ETF | 119.63 | 119.67 | 119.61 | 119.64 | 36800.0 |
| 2010-04-13 08:30:00 | SPY | ETF | 119.64 | 119.66 | 119.57 | 119.59 | 65694.0 |
| 2010-04-13 08:35:00 | SPY | ETF | 119.58 | 119.6 | 119.55 | 119.55 | 124920.0 |
| 2010-04-13 08:40:00 | SPY | ETF | 119.55 | 119.63 | 119.55 | 119.63 | 86795.0 |
| 2010-04-13 08:45:00 | SPY | ETF | 119.62 | 119.64 | 119.61 | 119.63 | 33050.0 |
| 2010-04-13 08:50:00 | SPY | ETF | 119.63 | 119.74 | 119.63 | 119.72 | 125210.0 |
| 2010-04-13 08:55:00 | SPY | ETF | 119.72 | 119.74 | 119.67 | 119.7 | 122618.0 |
| 2010-04-13 09:00:00 | SPY | ETF | 119.7 | 119.7 | 119.65 | 119.66 | 29598.0 |
| 2010-04-13 09:05:00 | SPY | ETF | 119.66 | 119.68 | 119.66 | 119.66 | 7700.0 |
| 2010-04-13 09:10:00 | SPY | ETF | 119.67 | 119.67 | 119.62 | 119.62 | 31190.0 |
| 2010-04-13 09:15:00 | SPY | ETF | 119.62 | 119.66 | 119.61 | 119.63 | 38845.0 |
| 2010-04-13 09:20:00 | SPY | ETF | 119.64 | 119.65 | 119.61 | 119.63 | 33759.0 |
| 2010-04-13 09:25:00 | SPY | ETF | 119.63 | 119.63 | 119.56 | 119.61 | 173491.0 |
| 2010-04-13 09:30:00 | SPY | ETF | 119.62 | 119.7 | 119.5 | 119.51 | 2871342.0 |
| 2010-04-13 09:35:00 | SPY | ETF | 119.52 | 119.54 | 119.42 | 119.495 | 3367737.0 |
| 2010-04-13 09:40:00 | SPY | ETF | 119.51 | 119.61 | 119.42 | 119.59 | 2555841.0 |
| 2010-04-13 09:45:00 | SPY | ETF | 119.59 | 119.65 | 119.53 | 119.62 | 2768348.0 |
| 2010-04-13 09:50:00 | SPY | ETF | 119.62 | 119.73 | 119.59 | 119.6499 | 2697731.0 |
| 2010-04-13 09:55:00 | SPY | ETF | 119.64 | 119.69 | 119.54 | 119.55 | 1975529.0 |
| 2010-04-13 10:00:00 | SPY | ETF | 119.55 | 119.59 | 119.45 | 119.54 | 2392007.0 |
| 2010-04-13 10:05:00 | SPY | ETF | 119.54 | 119.55 | 119.47 | 119.515 | 2355437.0 |
> showing 50 of 32,049 rows — these rows as CSV