PREVIEW / etf_5min / 2010-06-25
file: by_date/etf_5min/2010/2010-06-25.parquet size: 778 KB rows: 32,254
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-06-25 04:15:00 | SPY | ETF | 107.72 | 107.72 | 107.68 | 107.68 | 909.0 |
| 2010-06-25 04:25:00 | SPY | ETF | 107.64 | 107.64 | 107.53 | 107.53 | 400.0 |
| 2010-06-25 04:30:00 | SPY | ETF | 107.48 | 107.48 | 107.48 | 107.48 | 100.0 |
| 2010-06-25 04:40:00 | SPY | ETF | 107.39 | 107.39 | 107.39 | 107.39 | 100.0 |
| 2010-06-25 04:50:00 | SPY | ETF | 107.39 | 107.39 | 107.39 | 107.39 | 100.0 |
| 2010-06-25 05:30:00 | SPY | ETF | 107.37 | 107.37 | 107.37 | 107.37 | 100.0 |
| 2010-06-25 05:35:00 | SPY | ETF | 107.22 | 107.22 | 107.22 | 107.22 | 100.0 |
| 2010-06-25 05:40:00 | SPY | ETF | 107.24 | 107.24 | 107.12 | 107.15 | 2200.0 |
| 2010-06-25 05:45:00 | SPY | ETF | 107.11 | 107.14 | 107.11 | 107.14 | 300.0 |
| 2010-06-25 05:50:00 | SPY | ETF | 107.09 | 107.09 | 107.07 | 107.07 | 2100.0 |
| 2010-06-25 06:00:00 | SPY | ETF | 107.24 | 107.29 | 107.24 | 107.26 | 300.0 |
| 2010-06-25 06:05:00 | SPY | ETF | 107.23 | 107.23 | 107.22 | 107.22 | 500.0 |
| 2010-06-25 06:10:00 | SPY | ETF | 107.22 | 107.22 | 107.22 | 107.22 | 1860.0 |
| 2010-06-25 06:15:00 | SPY | ETF | 107.31 | 107.34 | 107.29 | 107.34 | 600.0 |
| 2010-06-25 06:20:00 | SPY | ETF | 107.29 | 107.29 | 107.29 | 107.29 | 100.0 |
| 2010-06-25 06:25:00 | SPY | ETF | 107.29 | 107.29 | 107.29 | 107.29 | 100.0 |
| 2010-06-25 06:30:00 | SPY | ETF | 107.36 | 107.39 | 107.36 | 107.39 | 1200.0 |
| 2010-06-25 06:35:00 | SPY | ETF | 107.43 | 107.43 | 107.4 | 107.4 | 10100.0 |
| 2010-06-25 06:40:00 | SPY | ETF | 107.42 | 107.47 | 107.42 | 107.47 | 500.0 |
| 2010-06-25 06:45:00 | SPY | ETF | 107.49 | 107.5 | 107.49 | 107.5 | 200.0 |
| 2010-06-25 06:50:00 | SPY | ETF | 107.49 | 107.49 | 107.49 | 107.49 | 100.0 |
| 2010-06-25 06:55:00 | SPY | ETF | 107.55 | 107.59 | 107.55 | 107.59 | 6000.0 |
| 2010-06-25 07:00:00 | SPY | ETF | 107.57 | 107.57 | 107.49 | 107.52 | 32000.0 |
| 2010-06-25 07:05:00 | SPY | ETF | 107.52 | 107.66 | 107.52 | 107.66 | 44400.0 |
| 2010-06-25 07:10:00 | SPY | ETF | 107.64 | 107.75 | 107.64 | 107.75 | 21200.0 |
| 2010-06-25 07:15:00 | SPY | ETF | 107.74 | 107.75 | 107.65 | 107.67 | 53157.0 |
| 2010-06-25 07:20:00 | SPY | ETF | 107.65 | 107.67 | 107.65 | 107.67 | 107200.0 |
| 2010-06-25 07:25:00 | SPY | ETF | 107.67 | 107.75 | 107.67 | 107.74 | 21005.0 |
| 2010-06-25 07:30:00 | SPY | ETF | 107.75 | 107.85 | 107.74 | 107.84 | 106250.0 |
| 2010-06-25 07:35:00 | SPY | ETF | 107.84 | 107.9 | 107.81 | 107.9 | 58700.0 |
| 2010-06-25 07:40:00 | SPY | ETF | 107.87 | 107.93 | 107.86 | 107.9 | 96400.0 |
| 2010-06-25 07:45:00 | SPY | ETF | 107.89 | 107.95 | 107.89 | 107.94 | 93409.0 |
| 2010-06-25 07:50:00 | SPY | ETF | 107.94 | 107.99 | 107.89 | 107.9 | 124288.0 |
| 2010-06-25 07:55:00 | SPY | ETF | 107.9 | 107.97 | 107.9 | 107.92 | 32023.0 |
| 2010-06-25 08:00:00 | SPY | ETF | 107.9 | 107.93 | 107.65 | 107.85 | 408772.0 |
| 2010-06-25 08:05:00 | SPY | ETF | 107.87 | 107.87 | 107.81 | 107.83 | 18800.0 |
| 2010-06-25 08:10:00 | SPY | ETF | 107.86 | 107.87 | 107.8 | 107.81 | 78100.0 |
| 2010-06-25 08:15:00 | SPY | ETF | 107.8 | 107.83 | 107.79 | 107.83 | 97705.0 |
| 2010-06-25 08:20:00 | SPY | ETF | 107.82 | 107.82 | 107.75 | 107.77 | 120527.0 |
| 2010-06-25 08:25:00 | SPY | ETF | 107.79 | 107.79 | 107.62 | 107.67 | 74178.0 |
| 2010-06-25 08:30:00 | SPY | ETF | 107.68 | 107.7 | 107.22 | 107.37 | 843274.0 |
| 2010-06-25 08:35:00 | SPY | ETF | 107.38 | 107.57 | 107.36 | 107.57 | 400370.0 |
| 2010-06-25 08:40:00 | SPY | ETF | 107.56 | 107.66 | 107.56 | 107.65 | 318964.0 |
| 2010-06-25 08:45:00 | SPY | ETF | 107.66 | 107.7 | 107.62 | 107.69 | 198025.0 |
| 2010-06-25 08:50:00 | SPY | ETF | 107.69 | 107.7 | 107.59 | 107.63 | 228235.0 |
| 2010-06-25 08:55:00 | SPY | ETF | 107.63 | 107.7 | 107.42 | 107.47 | 302926.0 |
| 2010-06-25 09:00:00 | SPY | ETF | 107.47 | 107.6 | 107.43 | 107.6 | 143747.0 |
| 2010-06-25 09:05:00 | SPY | ETF | 107.6 | 107.66 | 107.55 | 107.65 | 176999.0 |
| 2010-06-25 09:10:00 | SPY | ETF | 107.66 | 107.73 | 107.6 | 107.73 | 272076.0 |
| 2010-06-25 09:15:00 | SPY | ETF | 107.72 | 107.73 | 107.67 | 107.71 | 771980.0 |
> showing 50 of 32,254 rows — these rows as CSV