PREVIEW / etf_5min / 2007-04-30
file: by_date/etf_5min/2007/2007-04-30.parquet size: 316 KB rows: 14,831
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-30 04:35:00 | SPY | ETF | 149.4 | 149.4 | 149.4 | 149.4 | 100.0 |
| 2007-04-30 06:05:00 | SPY | ETF | 149.58 | 149.58 | 149.58 | 149.58 | 5000.0 |
| 2007-04-30 06:15:00 | SPY | ETF | 149.58 | 149.58 | 149.58 | 149.58 | 2000.0 |
| 2007-04-30 06:20:00 | SPY | ETF | 149.59 | 149.6 | 149.59 | 149.6 | 2000.0 |
| 2007-04-30 06:50:00 | SPY | ETF | 149.47 | 149.47 | 149.47 | 149.47 | 2500.0 |
| 2007-04-30 07:05:00 | SPY | ETF | 149.53 | 149.58 | 149.53 | 149.58 | 8500.0 |
| 2007-04-30 07:10:00 | SPY | ETF | 149.57 | 149.6 | 149.54 | 149.54 | 60100.0 |
| 2007-04-30 07:15:00 | SPY | ETF | 149.61 | 149.61 | 149.61 | 149.61 | 500.0 |
| 2007-04-30 07:20:00 | SPY | ETF | 149.58 | 149.58 | 149.58 | 149.58 | 300.0 |
| 2007-04-30 07:25:00 | SPY | ETF | 149.61 | 149.61 | 149.61 | 149.61 | 25000.0 |
| 2007-04-30 07:30:00 | SPY | ETF | 149.63 | 149.68 | 149.63 | 149.68 | 44300.0 |
| 2007-04-30 07:35:00 | SPY | ETF | 149.68 | 149.69 | 149.64 | 149.69 | 62400.0 |
| 2007-04-30 07:40:00 | SPY | ETF | 149.65 | 149.65 | 149.65 | 149.65 | 300.0 |
| 2007-04-30 07:45:00 | SPY | ETF | 149.63 | 149.63 | 149.63 | 149.63 | 700.0 |
| 2007-04-30 07:50:00 | SPY | ETF | 149.61 | 149.65 | 149.61 | 149.65 | 200.0 |
| 2007-04-30 07:55:00 | SPY | ETF | 149.62 | 149.63 | 149.62 | 149.62 | 130000.0 |
| 2007-04-30 08:00:00 | SPY | ETF | 149.62 | 149.63 | 149.58 | 149.58 | 73900.0 |
| 2007-04-30 08:05:00 | SPY | ETF | 149.6 | 149.64 | 149.6 | 149.63 | 41200.0 |
| 2007-04-30 08:10:00 | SPY | ETF | 149.62 | 149.66 | 149.62 | 149.66 | 134200.0 |
| 2007-04-30 08:15:00 | SPY | ETF | 149.62 | 149.69 | 149.62 | 149.66 | 268200.0 |
| 2007-04-30 08:20:00 | SPY | ETF | 149.67 | 149.71 | 149.66 | 149.7 | 113200.0 |
| 2007-04-30 08:25:00 | SPY | ETF | 149.7 | 149.75 | 149.69 | 149.74 | 107400.0 |
| 2007-04-30 08:30:00 | SPY | ETF | 149.78 | 149.9 | 149.74 | 149.77 | 1001900.0 |
| 2007-04-30 08:35:00 | SPY | ETF | 149.75 | 149.77 | 149.69 | 149.72 | 79700.0 |
| 2007-04-30 08:40:00 | SPY | ETF | 149.71 | 149.72 | 149.65 | 149.69 | 179600.0 |
| 2007-04-30 08:45:00 | SPY | ETF | 149.69 | 149.7 | 149.63 | 149.63 | 98800.0 |
| 2007-04-30 08:50:00 | SPY | ETF | 149.65 | 149.65 | 149.61 | 149.63 | 38900.0 |
| 2007-04-30 08:55:00 | SPY | ETF | 149.64 | 149.67 | 149.64 | 149.67 | 27700.0 |
| 2007-04-30 09:00:00 | SPY | ETF | 149.68 | 149.68 | 149.66 | 149.67 | 65700.0 |
| 2007-04-30 09:05:00 | SPY | ETF | 149.66 | 149.66 | 149.64 | 149.64 | 15700.0 |
| 2007-04-30 09:10:00 | SPY | ETF | 149.65 | 149.68 | 149.64 | 149.64 | 15100.0 |
| 2007-04-30 09:15:00 | SPY | ETF | 149.64 | 149.65 | 149.62 | 149.65 | 37000.0 |
| 2007-04-30 09:20:00 | SPY | ETF | 149.66 | 149.68 | 149.58 | 149.59 | 206500.0 |
| 2007-04-30 09:25:00 | SPY | ETF | 149.59 | 149.62 | 149.56 | 149.62 | 157800.0 |
| 2007-04-30 09:30:00 | SPY | ETF | 149.64 | 149.67 | 149.45 | 149.5 | 2455350.0 |
| 2007-04-30 09:35:00 | SPY | ETF | 149.5 | 149.591 | 149.3 | 149.3 | 1186154.0 |
| 2007-04-30 09:40:00 | SPY | ETF | 149.3 | 149.33 | 149.14 | 149.22 | 1969298.0 |
| 2007-04-30 09:45:00 | SPY | ETF | 149.24 | 149.59 | 149.19 | 149.23 | 3399475.0 |
| 2007-04-30 09:50:00 | SPY | ETF | 149.23 | 149.37 | 149.22 | 149.33 | 1361884.0 |
| 2007-04-30 09:55:00 | SPY | ETF | 149.34 | 149.38 | 149.28 | 149.34 | 712250.0 |
| 2007-04-30 10:00:00 | SPY | ETF | 149.34 | 149.44 | 149.32 | 149.38 | 1176165.0 |
| 2007-04-30 10:05:00 | SPY | ETF | 149.38 | 149.38 | 149.19 | 149.19 | 1947008.0 |
| 2007-04-30 10:10:00 | SPY | ETF | 149.2 | 149.35 | 149.2 | 149.31 | 951913.0 |
| 2007-04-30 10:15:00 | SPY | ETF | 149.32 | 149.61 | 149.32 | 149.55 | 1846238.0 |
| 2007-04-30 10:20:00 | SPY | ETF | 149.56 | 149.6 | 149.51 | 149.56 | 1420339.0 |
| 2007-04-30 10:25:00 | SPY | ETF | 149.56 | 149.58 | 149.48 | 149.52 | 1126432.0 |
| 2007-04-30 10:30:00 | SPY | ETF | 149.52 | 149.54 | 149.46 | 149.47 | 567757.0 |
| 2007-04-30 10:35:00 | SPY | ETF | 149.48 | 149.68 | 149.47 | 149.65 | 1013213.0 |
| 2007-04-30 10:40:00 | SPY | ETF | 149.65 | 149.68 | 149.61 | 149.66 | 639771.0 |
| 2007-04-30 10:45:00 | SPY | ETF | 149.66 | 149.68 | 149.51 | 149.58 | 1234633.0 |
> showing 50 of 14,831 rows — these rows as CSV