PREVIEW / etf_5min / 2007-04-26
file: by_date/etf_5min/2007/2007-04-26.parquet size: 302 KB rows: 14,575
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-26 04:30:00 | SPY | ETF | 149.59 | 149.59 | 149.59 | 149.59 | 100.0 |
| 2007-04-26 05:05:00 | SPY | ETF | 149.53 | 149.53 | 149.53 | 149.53 | 7000.0 |
| 2007-04-26 06:05:00 | SPY | ETF | 149.49 | 149.49 | 149.49 | 149.49 | 3000.0 |
| 2007-04-26 06:50:00 | SPY | ETF | 149.61 | 149.61 | 149.61 | 149.61 | 2000.0 |
| 2007-04-26 06:55:00 | SPY | ETF | 149.6 | 149.6 | 149.6 | 149.6 | 2000.0 |
| 2007-04-26 07:05:00 | SPY | ETF | 149.6 | 149.66 | 149.6 | 149.66 | 14300.0 |
| 2007-04-26 07:10:00 | SPY | ETF | 149.62 | 149.73 | 149.62 | 149.73 | 55500.0 |
| 2007-04-26 07:15:00 | SPY | ETF | 149.72 | 149.76 | 149.72 | 149.75 | 36400.0 |
| 2007-04-26 07:20:00 | SPY | ETF | 149.75 | 149.75 | 149.75 | 149.75 | 18000.0 |
| 2007-04-26 07:25:00 | SPY | ETF | 149.7 | 149.7 | 149.7 | 149.7 | 10500.0 |
| 2007-04-26 07:30:00 | SPY | ETF | 149.7 | 149.74 | 149.7 | 149.74 | 3500.0 |
| 2007-04-26 07:35:00 | SPY | ETF | 149.77 | 149.83 | 149.77 | 149.83 | 51000.0 |
| 2007-04-26 07:40:00 | SPY | ETF | 149.81 | 149.81 | 149.81 | 149.81 | 6000.0 |
| 2007-04-26 07:45:00 | SPY | ETF | 149.78 | 149.82 | 149.77 | 149.79 | 25300.0 |
| 2007-04-26 07:50:00 | SPY | ETF | 149.78 | 149.78 | 149.78 | 149.78 | 600.0 |
| 2007-04-26 07:55:00 | SPY | ETF | 149.78 | 149.78 | 149.76 | 149.76 | 1100.0 |
| 2007-04-26 08:00:00 | SPY | ETF | 149.81 | 149.81 | 149.67 | 149.73 | 347200.0 |
| 2007-04-26 08:05:00 | SPY | ETF | 149.74 | 149.79 | 149.74 | 149.79 | 8200.0 |
| 2007-04-26 08:10:00 | SPY | ETF | 149.77 | 149.78 | 149.77 | 149.78 | 70500.0 |
| 2007-04-26 08:15:00 | SPY | ETF | 149.81 | 149.81 | 149.74 | 149.75 | 163800.0 |
| 2007-04-26 08:20:00 | SPY | ETF | 149.76 | 149.78 | 149.75 | 149.75 | 25000.0 |
| 2007-04-26 08:25:00 | SPY | ETF | 149.76 | 149.79 | 149.74 | 149.79 | 42200.0 |
| 2007-04-26 08:30:00 | SPY | ETF | 149.79 | 149.82 | 149.76 | 149.8 | 88200.0 |
| 2007-04-26 08:35:00 | SPY | ETF | 149.8 | 149.8 | 149.77 | 149.78 | 27100.0 |
| 2007-04-26 08:40:00 | SPY | ETF | 149.78 | 149.79 | 149.5339 | 149.78 | 733700.0 |
| 2007-04-26 08:45:00 | SPY | ETF | 149.77 | 149.77 | 149.67 | 149.7 | 113500.0 |
| 2007-04-26 08:50:00 | SPY | ETF | 149.69 | 149.69 | 149.6 | 149.65 | 306600.0 |
| 2007-04-26 08:55:00 | SPY | ETF | 149.65 | 149.65 | 149.61 | 149.62 | 82800.0 |
| 2007-04-26 09:00:00 | SPY | ETF | 149.63 | 149.63 | 149.59 | 149.6 | 76300.0 |
| 2007-04-26 09:05:00 | SPY | ETF | 149.6 | 149.63 | 149.59 | 149.62 | 67200.0 |
| 2007-04-26 09:10:00 | SPY | ETF | 149.62 | 149.64 | 149.61 | 149.61 | 38800.0 |
| 2007-04-26 09:15:00 | SPY | ETF | 149.61 | 149.62 | 149.59 | 149.59 | 9900.0 |
| 2007-04-26 09:20:00 | SPY | ETF | 149.59 | 149.6 | 149.57 | 149.57 | 184750.0 |
| 2007-04-26 09:25:00 | SPY | ETF | 149.59 | 149.61 | 149.5 | 149.5 | 128000.0 |
| 2007-04-26 09:30:00 | SPY | ETF | 149.49 | 149.59 | 149.43 | 149.57 | 3047580.0 |
| 2007-04-26 09:35:00 | SPY | ETF | 149.57 | 149.64 | 149.48 | 149.6 | 2093416.0 |
| 2007-04-26 09:40:00 | SPY | ETF | 149.59 | 149.67 | 149.58 | 149.6 | 1556600.0 |
| 2007-04-26 09:45:00 | SPY | ETF | 149.6 | 149.6 | 149.36 | 149.43 | 2050463.0 |
| 2007-04-26 09:50:00 | SPY | ETF | 149.42 | 149.43 | 149.26 | 149.3 | 4407781.0 |
| 2007-04-26 09:55:00 | SPY | ETF | 149.3 | 149.33 | 149.18 | 149.18 | 2279820.0 |
| 2007-04-26 10:00:00 | SPY | ETF | 149.19 | 149.24 | 149.11 | 149.13 | 2458798.0 |
| 2007-04-26 10:05:00 | SPY | ETF | 149.13 | 149.33 | 149.11 | 149.32 | 3478695.0 |
| 2007-04-26 10:10:00 | SPY | ETF | 149.33 | 149.36 | 149.2 | 149.34 | 1584000.0 |
| 2007-04-26 10:15:00 | SPY | ETF | 149.32 | 149.36 | 149.2 | 149.26 | 1807698.0 |
| 2007-04-26 10:20:00 | SPY | ETF | 149.27 | 149.32 | 149.1 | 149.29 | 3654129.0 |
| 2007-04-26 10:25:00 | SPY | ETF | 149.29 | 149.33 | 149.25 | 149.26 | 1652000.0 |
| 2007-04-26 10:30:00 | SPY | ETF | 149.26 | 149.42 | 149.25 | 149.4 | 1793611.0 |
| 2007-04-26 10:35:00 | SPY | ETF | 149.39 | 149.51 | 149.37 | 149.44 | 2185500.0 |
| 2007-04-26 10:40:00 | SPY | ETF | 149.44 | 149.51 | 149.41 | 149.51 | 904740.0 |
| 2007-04-26 10:45:00 | SPY | ETF | 149.5 | 149.55 | 149.42 | 149.47 | 1370964.0 |
> showing 50 of 14,575 rows — these rows as CSV