PREVIEW / etf_5min / 2009-08-21
file: by_date/etf_5min/2009/2009-08-21.parquet size: 716 KB rows: 30,513
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-21 04:15:00 | SPY | ETF | 100.79 | 100.79 | 100.79 | 100.79 | 500.0 |
| 2009-08-21 04:40:00 | SPY | ETF | 100.86 | 100.86 | 100.86 | 100.86 | 500.0 |
| 2009-08-21 04:45:00 | SPY | ETF | 101.0 | 101.0 | 101.0 | 101.0 | 500.0 |
| 2009-08-21 05:05:00 | SPY | ETF | 101.02 | 101.02 | 101.02 | 101.02 | 5100.0 |
| 2009-08-21 05:45:00 | SPY | ETF | 101.11 | 101.11 | 101.11 | 101.11 | 100.0 |
| 2009-08-21 05:50:00 | SPY | ETF | 101.15 | 101.2 | 101.15 | 101.2 | 500.0 |
| 2009-08-21 05:55:00 | SPY | ETF | 101.25 | 101.25 | 101.25 | 101.25 | 200.0 |
| 2009-08-21 06:05:00 | SPY | ETF | 101.29 | 101.31 | 101.29 | 101.31 | 1600.0 |
| 2009-08-21 06:10:00 | SPY | ETF | 101.41 | 101.54 | 101.41 | 101.54 | 2150.0 |
| 2009-08-21 06:15:00 | SPY | ETF | 101.55 | 101.55 | 101.54 | 101.54 | 800.0 |
| 2009-08-21 06:20:00 | SPY | ETF | 101.5 | 101.5 | 101.5 | 101.5 | 300.0 |
| 2009-08-21 06:25:00 | SPY | ETF | 101.54 | 101.54 | 101.54 | 101.54 | 100.0 |
| 2009-08-21 06:30:00 | SPY | ETF | 101.41 | 101.41 | 101.41 | 101.41 | 500.0 |
| 2009-08-21 06:40:00 | SPY | ETF | 101.39 | 101.42 | 101.39 | 101.42 | 5500.0 |
| 2009-08-21 06:45:00 | SPY | ETF | 101.41 | 101.41 | 101.39 | 101.41 | 4300.0 |
| 2009-08-21 06:50:00 | SPY | ETF | 101.43 | 101.45 | 101.43 | 101.45 | 700.0 |
| 2009-08-21 06:55:00 | SPY | ETF | 101.5 | 101.5 | 101.46 | 101.46 | 4806.0 |
| 2009-08-21 07:00:00 | SPY | ETF | 101.46 | 101.58 | 101.46 | 101.58 | 49561.0 |
| 2009-08-21 07:05:00 | SPY | ETF | 101.55 | 101.55 | 101.5 | 101.52 | 12041.0 |
| 2009-08-21 07:10:00 | SPY | ETF | 101.53 | 101.57 | 101.51 | 101.57 | 5600.0 |
| 2009-08-21 07:15:00 | SPY | ETF | 101.48 | 101.52 | 101.46 | 101.5 | 33370.0 |
| 2009-08-21 07:20:00 | SPY | ETF | 101.48 | 101.59 | 101.48 | 101.56 | 14274.0 |
| 2009-08-21 07:25:00 | SPY | ETF | 101.54 | 101.6 | 101.5 | 101.6 | 147427.0 |
| 2009-08-21 07:30:00 | SPY | ETF | 101.54 | 101.57 | 101.54 | 101.57 | 9625.0 |
| 2009-08-21 07:35:00 | SPY | ETF | 101.55 | 101.56 | 101.46 | 101.51 | 134581.0 |
| 2009-08-21 07:40:00 | SPY | ETF | 101.51 | 101.54 | 101.48 | 101.5 | 17450.0 |
| 2009-08-21 07:45:00 | SPY | ETF | 101.48 | 101.5 | 101.45 | 101.45 | 43600.0 |
| 2009-08-21 07:50:00 | SPY | ETF | 101.44 | 101.45 | 101.39 | 101.4 | 85920.0 |
| 2009-08-21 07:55:00 | SPY | ETF | 101.41 | 101.45 | 101.41 | 101.45 | 13200.0 |
| 2009-08-21 08:00:00 | SPY | ETF | 101.46 | 101.46 | 101.35 | 101.4 | 185271.0 |
| 2009-08-21 08:05:00 | SPY | ETF | 101.39 | 101.46 | 101.39 | 101.46 | 30267.0 |
| 2009-08-21 08:10:00 | SPY | ETF | 101.46 | 101.5 | 101.2 | 101.44 | 179021.0 |
| 2009-08-21 08:15:00 | SPY | ETF | 101.47 | 101.51 | 100.19 | 101.49 | 77330.0 |
| 2009-08-21 08:20:00 | SPY | ETF | 101.5 | 101.56 | 101.5 | 101.56 | 65235.0 |
| 2009-08-21 08:25:00 | SPY | ETF | 101.55 | 101.6 | 101.49 | 101.59 | 289513.0 |
| 2009-08-21 08:30:00 | SPY | ETF | 101.59 | 101.61 | 101.55 | 101.61 | 67984.0 |
| 2009-08-21 08:35:00 | SPY | ETF | 101.61 | 101.62 | 101.55 | 101.58 | 309209.0 |
| 2009-08-21 08:40:00 | SPY | ETF | 101.59 | 101.6 | 101.55 | 101.56 | 93124.0 |
| 2009-08-21 08:45:00 | SPY | ETF | 101.58 | 101.58 | 101.5 | 101.5 | 63290.0 |
| 2009-08-21 08:50:00 | SPY | ETF | 101.5 | 101.58 | 101.5 | 101.58 | 321522.0 |
| 2009-08-21 08:55:00 | SPY | ETF | 101.55 | 101.63 | 101.55 | 101.63 | 198650.0 |
| 2009-08-21 09:00:00 | SPY | ETF | 101.63 | 101.75 | 101.63 | 101.68 | 616134.0 |
| 2009-08-21 09:05:00 | SPY | ETF | 101.68 | 101.74 | 101.67 | 101.68 | 172518.0 |
| 2009-08-21 09:10:00 | SPY | ETF | 101.694 | 101.73 | 101.68 | 101.73 | 170266.0 |
| 2009-08-21 09:15:00 | SPY | ETF | 101.73 | 101.76 | 101.61 | 101.7 | 496386.0 |
| 2009-08-21 09:20:00 | SPY | ETF | 101.71 | 101.81 | 101.69 | 101.79 | 788493.0 |
| 2009-08-21 09:25:00 | SPY | ETF | 101.79 | 101.87 | 101.77 | 101.82 | 682071.0 |
| 2009-08-21 09:30:00 | SPY | ETF | 101.82 | 101.95 | 101.69 | 101.77 | 8426283.0 |
| 2009-08-21 09:35:00 | SPY | ETF | 101.77 | 101.9 | 101.71 | 101.75 | 5667205.0 |
| 2009-08-21 09:40:00 | SPY | ETF | 101.75 | 101.92 | 101.75 | 101.83 | 3303458.0 |
> showing 50 of 30,513 rows — these rows as CSV