PREVIEW / etf_5min / 2006-07-03
file: by_date/etf_5min/2006/2006-07-03.parquet size: 128 KB rows: 5,843
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-03 07:00:00 | SPY | ETF | 127.35 | 127.35 | 127.35 | 127.35 | 300.0 |
| 2006-07-03 07:05:00 | SPY | ETF | 127.35 | 127.4 | 127.33 | 127.4 | 1100.0 |
| 2006-07-03 07:25:00 | SPY | ETF | 127.36 | 127.36 | 127.36 | 127.36 | 300.0 |
| 2006-07-03 07:45:00 | SPY | ETF | 127.32 | 127.32 | 127.32 | 127.32 | 1500.0 |
| 2006-07-03 08:00:00 | SPY | ETF | 127.32 | 127.32 | 127.28 | 127.28 | 2800.0 |
| 2006-07-03 08:05:00 | SPY | ETF | 127.27 | 127.3 | 127.27 | 127.3 | 600.0 |
| 2006-07-03 08:10:00 | SPY | ETF | 127.31 | 127.32 | 127.3 | 127.3 | 7700.0 |
| 2006-07-03 08:15:00 | SPY | ETF | 127.35 | 127.35 | 127.35 | 127.35 | 100.0 |
| 2006-07-03 08:20:00 | SPY | ETF | 127.35 | 127.35 | 127.35 | 127.35 | 800.0 |
| 2006-07-03 08:25:00 | SPY | ETF | 127.37 | 127.37 | 127.36 | 127.36 | 500.0 |
| 2006-07-03 08:30:00 | SPY | ETF | 127.37 | 127.37 | 127.34 | 127.34 | 10200.0 |
| 2006-07-03 08:35:00 | SPY | ETF | 127.34 | 127.35 | 127.33 | 127.35 | 16500.0 |
| 2006-07-03 08:40:00 | SPY | ETF | 127.35 | 127.36 | 127.34 | 127.35 | 22700.0 |
| 2006-07-03 08:45:00 | SPY | ETF | 127.35 | 127.35 | 127.33 | 127.33 | 6100.0 |
| 2006-07-03 08:50:00 | SPY | ETF | 127.35 | 127.35 | 127.33 | 127.34 | 73000.0 |
| 2006-07-03 08:55:00 | SPY | ETF | 127.34 | 127.36 | 127.28 | 127.28 | 14900.0 |
| 2006-07-03 09:00:00 | SPY | ETF | 127.37 | 127.37 | 127.35 | 127.37 | 3700.0 |
| 2006-07-03 09:05:00 | SPY | ETF | 127.37 | 127.39 | 127.37 | 127.39 | 10100.0 |
| 2006-07-03 09:10:00 | SPY | ETF | 127.39 | 127.4 | 127.35 | 127.35 | 103100.0 |
| 2006-07-03 09:15:00 | SPY | ETF | 127.35 | 127.39 | 127.28 | 127.28 | 12300.0 |
| 2006-07-03 09:20:00 | SPY | ETF | 127.38 | 127.38 | 127.37 | 127.37 | 1900.0 |
| 2006-07-03 09:25:00 | SPY | ETF | 127.37 | 127.42 | 127.35 | 127.41 | 42300.0 |
| 2006-07-03 09:30:00 | SPY | ETF | 127.43 | 127.53 | 127.37 | 127.38 | 1889800.0 |
| 2006-07-03 09:35:00 | SPY | ETF | 127.38 | 127.42 | 127.31 | 127.4 | 856600.0 |
| 2006-07-03 09:40:00 | SPY | ETF | 127.4 | 127.52 | 127.38 | 127.5 | 752300.0 |
| 2006-07-03 09:45:00 | SPY | ETF | 127.5 | 127.54 | 127.48 | 127.5 | 338400.0 |
| 2006-07-03 09:50:00 | SPY | ETF | 127.5 | 127.55 | 127.44 | 127.45 | 406600.0 |
| 2006-07-03 09:55:00 | SPY | ETF | 127.46 | 127.49 | 127.37 | 127.38 | 407800.0 |
| 2006-07-03 10:00:00 | SPY | ETF | 127.38 | 127.49 | 127.33 | 127.39 | 551600.0 |
| 2006-07-03 10:05:00 | SPY | ETF | 127.4 | 127.46 | 127.39 | 127.4399 | 335200.0 |
| 2006-07-03 10:10:00 | SPY | ETF | 127.43 | 127.48 | 127.4 | 127.48 | 243500.0 |
| 2006-07-03 10:15:00 | SPY | ETF | 127.47 | 127.5 | 127.47 | 127.47 | 174400.0 |
| 2006-07-03 10:20:00 | SPY | ETF | 127.47 | 127.49 | 127.4 | 127.43 | 571300.0 |
| 2006-07-03 10:25:00 | SPY | ETF | 127.43 | 127.46 | 127.42 | 127.45 | 197300.0 |
| 2006-07-03 10:30:00 | SPY | ETF | 127.46 | 127.5 | 127.45 | 127.5 | 389900.0 |
| 2006-07-03 10:35:00 | SPY | ETF | 127.49 | 127.51 | 127.46 | 127.5 | 299000.0 |
| 2006-07-03 10:40:00 | SPY | ETF | 127.5 | 127.57 | 127.49 | 127.53 | 514500.0 |
| 2006-07-03 10:45:00 | SPY | ETF | 127.54 | 127.55 | 127.48 | 127.5 | 332400.0 |
| 2006-07-03 10:50:00 | SPY | ETF | 127.51 | 127.54 | 127.5 | 127.5381 | 254400.0 |
| 2006-07-03 10:55:00 | SPY | ETF | 127.54 | 127.55 | 127.51 | 127.51 | 196000.0 |
| 2006-07-03 11:00:00 | SPY | ETF | 127.52 | 127.58 | 127.52 | 127.54 | 269700.0 |
| 2006-07-03 11:05:00 | SPY | ETF | 127.54 | 127.55 | 127.52 | 127.53 | 243700.0 |
| 2006-07-03 11:10:00 | SPY | ETF | 127.54 | 127.62 | 127.52 | 127.62 | 557700.0 |
| 2006-07-03 11:15:00 | SPY | ETF | 127.62 | 127.74 | 127.62 | 127.7 | 1478000.0 |
| 2006-07-03 11:20:00 | SPY | ETF | 127.7 | 127.72 | 127.65 | 127.67 | 948300.0 |
| 2006-07-03 11:25:00 | SPY | ETF | 127.66 | 127.7 | 127.66 | 127.68 | 228700.0 |
| 2006-07-03 11:30:00 | SPY | ETF | 127.68 | 127.72 | 127.66 | 127.7 | 327300.0 |
| 2006-07-03 11:35:00 | SPY | ETF | 127.7 | 127.75 | 127.69 | 127.74 | 338300.0 |
| 2006-07-03 11:40:00 | SPY | ETF | 127.74 | 127.83 | 127.72 | 127.8 | 709800.0 |
| 2006-07-03 11:45:00 | SPY | ETF | 127.81 | 127.91 | 127.8 | 127.85 | 732500.0 |
> showing 50 of 5,843 rows — these rows as CSV