PREVIEW / etf_5min / 2009-06-30
file: by_date/etf_5min/2009/2009-06-30.parquet size: 638 KB rows: 27,994
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-06-30 04:05:00 | SPY | ETF | 92.75 | 92.75 | 92.75 | 92.75 | 100.0 |
| 2009-06-30 04:30:00 | SPY | ETF | 92.75 | 92.75 | 92.73 | 92.73 | 3000.0 |
| 2009-06-30 05:25:00 | SPY | ETF | 92.83 | 92.84 | 92.83 | 92.84 | 5000.0 |
| 2009-06-30 05:45:00 | SPY | ETF | 92.91 | 92.93 | 92.91 | 92.93 | 2000.0 |
| 2009-06-30 06:20:00 | SPY | ETF | 92.92 | 92.92 | 92.83 | 92.83 | 700.0 |
| 2009-06-30 06:30:00 | SPY | ETF | 92.88 | 92.88 | 92.88 | 92.88 | 500.0 |
| 2009-06-30 06:50:00 | SPY | ETF | 92.87 | 92.87 | 92.87 | 92.87 | 600.0 |
| 2009-06-30 06:55:00 | SPY | ETF | 92.87 | 92.87 | 92.87 | 92.87 | 100.0 |
| 2009-06-30 07:00:00 | SPY | ETF | 92.87 | 92.87 | 92.87 | 92.87 | 300.0 |
| 2009-06-30 07:05:00 | SPY | ETF | 92.87 | 92.87 | 92.81 | 92.87 | 6700.0 |
| 2009-06-30 07:10:00 | SPY | ETF | 92.87 | 92.88 | 92.86 | 92.86 | 3000.0 |
| 2009-06-30 07:15:00 | SPY | ETF | 92.84 | 92.84 | 92.81 | 92.81 | 1000.0 |
| 2009-06-30 07:20:00 | SPY | ETF | 92.78 | 92.78 | 92.68 | 92.72 | 25300.0 |
| 2009-06-30 07:25:00 | SPY | ETF | 92.7 | 92.71 | 92.7 | 92.71 | 3000.0 |
| 2009-06-30 07:30:00 | SPY | ETF | 92.72 | 92.73 | 92.72 | 92.73 | 24654.0 |
| 2009-06-30 07:35:00 | SPY | ETF | 92.74 | 92.74 | 92.7 | 92.7 | 9989.0 |
| 2009-06-30 07:40:00 | SPY | ETF | 92.7 | 92.72 | 92.7 | 92.71 | 18403.0 |
| 2009-06-30 07:45:00 | SPY | ETF | 92.72 | 92.76 | 92.72 | 92.72 | 40429.0 |
| 2009-06-30 07:50:00 | SPY | ETF | 92.72 | 92.75 | 92.72 | 92.75 | 11000.0 |
| 2009-06-30 07:55:00 | SPY | ETF | 92.76 | 92.76 | 92.71 | 92.71 | 19000.0 |
| 2009-06-30 08:00:00 | SPY | ETF | 92.71 | 92.73 | 92.7 | 92.73 | 27214.0 |
| 2009-06-30 08:05:00 | SPY | ETF | 92.73 | 92.75 | 92.7 | 92.74 | 31521.0 |
| 2009-06-30 08:10:00 | SPY | ETF | 92.73 | 92.74 | 92.71 | 92.71 | 12500.0 |
| 2009-06-30 08:15:00 | SPY | ETF | 92.71 | 92.71 | 92.66 | 92.66 | 47860.0 |
| 2009-06-30 08:20:00 | SPY | ETF | 92.67 | 92.69 | 92.66 | 92.66 | 125660.0 |
| 2009-06-30 08:25:00 | SPY | ETF | 92.66 | 92.69 | 92.64 | 92.66 | 54461.0 |
| 2009-06-30 08:30:00 | SPY | ETF | 92.67 | 92.74 | 92.67 | 92.74 | 47719.0 |
| 2009-06-30 08:35:00 | SPY | ETF | 92.72 | 92.74 | 92.7 | 92.71 | 19278.0 |
| 2009-06-30 08:40:00 | SPY | ETF | 92.72 | 92.75 | 92.72 | 92.72 | 46903.0 |
| 2009-06-30 08:45:00 | SPY | ETF | 92.74 | 92.75 | 92.68 | 92.75 | 36372.0 |
| 2009-06-30 08:50:00 | SPY | ETF | 92.75 | 92.76 | 92.75 | 92.76 | 120378.0 |
| 2009-06-30 08:55:00 | SPY | ETF | 92.76 | 92.84 | 92.76 | 92.83 | 59222.0 |
| 2009-06-30 09:00:00 | SPY | ETF | 92.84 | 92.95 | 92.79 | 92.83 | 467441.0 |
| 2009-06-30 09:05:00 | SPY | ETF | 92.82 | 92.82 | 92.79 | 92.81 | 57500.0 |
| 2009-06-30 09:10:00 | SPY | ETF | 92.8 | 92.85 | 92.76 | 92.77 | 64691.0 |
| 2009-06-30 09:15:00 | SPY | ETF | 92.78 | 92.78 | 92.68 | 92.7 | 97902.0 |
| 2009-06-30 09:20:00 | SPY | ETF | 92.7 | 92.75 | 92.7 | 92.74 | 204908.0 |
| 2009-06-30 09:25:00 | SPY | ETF | 92.75 | 92.75 | 92.72 | 92.73 | 188191.0 |
| 2009-06-30 09:30:00 | SPY | ETF | 92.72 | 92.83 | 92.65 | 92.82 | 3076890.0 |
| 2009-06-30 09:35:00 | SPY | ETF | 92.82 | 92.93 | 92.79 | 92.86 | 3896836.0 |
| 2009-06-30 09:40:00 | SPY | ETF | 92.85 | 92.99 | 92.85 | 92.94 | 3657939.0 |
| 2009-06-30 09:45:00 | SPY | ETF | 92.94 | 93.06 | 92.81 | 92.8701 | 3123971.0 |
| 2009-06-30 09:50:00 | SPY | ETF | 92.87 | 92.94 | 92.74 | 92.94 | 3901031.0 |
| 2009-06-30 09:55:00 | SPY | ETF | 92.93 | 92.96 | 92.86 | 92.87 | 1289003.0 |
| 2009-06-30 10:00:00 | SPY | ETF | 92.9 | 92.91 | 92.4 | 92.5383 | 10390132.0 |
| 2009-06-30 10:05:00 | SPY | ETF | 92.53 | 92.54 | 92.26 | 92.44 | 6117938.0 |
| 2009-06-30 10:10:00 | SPY | ETF | 92.45 | 92.46 | 92.33 | 92.35 | 3672614.0 |
| 2009-06-30 10:15:00 | SPY | ETF | 92.355 | 92.36 | 92.05 | 92.05 | 5726305.0 |
| 2009-06-30 10:20:00 | SPY | ETF | 92.06 | 92.1 | 91.83 | 91.97 | 7113964.0 |
| 2009-06-30 10:25:00 | SPY | ETF | 91.972 | 91.98 | 91.8 | 91.91 | 3274421.0 |
> showing 50 of 27,994 rows — these rows as CSV