PREVIEW / etf_5min / 2010-09-22
file: by_date/etf_5min/2010/2010-09-22.parquet size: 821 KB rows: 34,524
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-09-22 04:00:00 | SPY | ETF | 113.67 | 113.67 | 113.67 | 113.67 | 100.0 |
| 2010-09-22 04:05:00 | SPY | ETF | 113.53 | 113.53 | 113.49 | 113.49 | 2900.0 |
| 2010-09-22 04:15:00 | SPY | ETF | 113.53 | 113.53 | 113.53 | 113.53 | 2600.0 |
| 2010-09-22 04:20:00 | SPY | ETF | 113.58 | 113.58 | 113.58 | 113.58 | 1700.0 |
| 2010-09-22 04:40:00 | SPY | ETF | 113.48 | 113.48 | 113.48 | 113.48 | 500.0 |
| 2010-09-22 04:45:00 | SPY | ETF | 113.5 | 113.5 | 113.5 | 113.5 | 700.0 |
| 2010-09-22 05:05:00 | SPY | ETF | 113.6 | 113.6 | 113.55 | 113.55 | 800.0 |
| 2010-09-22 05:20:00 | SPY | ETF | 113.6 | 113.6 | 113.6 | 113.6 | 200.0 |
| 2010-09-22 05:30:00 | SPY | ETF | 113.68 | 113.75 | 113.68 | 113.75 | 2000.0 |
| 2010-09-22 05:50:00 | SPY | ETF | 113.63 | 113.63 | 113.63 | 113.63 | 200.0 |
| 2010-09-22 06:00:00 | SPY | ETF | 113.72 | 113.72 | 113.72 | 113.72 | 200.0 |
| 2010-09-22 06:10:00 | SPY | ETF | 113.9 | 113.92 | 113.9 | 113.92 | 500.0 |
| 2010-09-22 06:15:00 | SPY | ETF | 113.87 | 113.87 | 113.85 | 113.85 | 900.0 |
| 2010-09-22 06:30:00 | SPY | ETF | 113.75 | 113.82 | 113.75 | 113.82 | 9100.0 |
| 2010-09-22 06:35:00 | SPY | ETF | 113.8 | 113.8 | 113.8 | 113.8 | 11500.0 |
| 2010-09-22 06:40:00 | SPY | ETF | 113.8 | 113.8 | 113.79 | 113.79 | 200.0 |
| 2010-09-22 06:45:00 | SPY | ETF | 113.8 | 113.8 | 113.78 | 113.78 | 31600.0 |
| 2010-09-22 06:50:00 | SPY | ETF | 113.76 | 113.76 | 113.7 | 113.7 | 900.0 |
| 2010-09-22 06:55:00 | SPY | ETF | 113.69 | 113.69 | 113.65 | 113.67 | 20600.0 |
| 2010-09-22 07:00:00 | SPY | ETF | 113.71 | 113.71 | 113.56 | 113.56 | 40700.0 |
| 2010-09-22 07:05:00 | SPY | ETF | 113.58 | 113.58 | 113.54 | 113.56 | 22850.0 |
| 2010-09-22 07:10:00 | SPY | ETF | 113.58 | 113.63 | 113.56 | 113.56 | 22095.0 |
| 2010-09-22 07:15:00 | SPY | ETF | 113.58 | 113.58 | 113.48 | 113.51 | 33355.0 |
| 2010-09-22 07:20:00 | SPY | ETF | 113.51 | 113.56 | 113.47 | 113.55 | 20875.0 |
| 2010-09-22 07:25:00 | SPY | ETF | 113.58 | 113.58 | 113.51 | 113.51 | 28800.0 |
| 2010-09-22 07:30:00 | SPY | ETF | 113.58 | 113.63 | 113.58 | 113.61 | 25700.0 |
| 2010-09-22 07:35:00 | SPY | ETF | 113.63 | 113.68 | 113.6 | 113.67 | 63973.0 |
| 2010-09-22 07:40:00 | SPY | ETF | 113.68 | 113.71 | 113.68 | 113.69 | 46527.0 |
| 2010-09-22 07:45:00 | SPY | ETF | 113.68 | 113.7 | 113.63 | 113.66 | 36520.0 |
| 2010-09-22 07:50:00 | SPY | ETF | 113.68 | 113.69 | 113.66 | 113.68 | 47675.0 |
| 2010-09-22 07:55:00 | SPY | ETF | 113.68 | 113.7 | 113.65 | 113.65 | 132100.0 |
| 2010-09-22 08:00:00 | SPY | ETF | 113.66 | 113.69 | 113.51 | 113.69 | 996397.0 |
| 2010-09-22 08:05:00 | SPY | ETF | 113.69 | 113.7 | 113.66 | 113.66 | 34610.0 |
| 2010-09-22 08:10:00 | SPY | ETF | 113.63 | 113.75 | 113.63 | 113.72 | 32700.0 |
| 2010-09-22 08:15:00 | SPY | ETF | 113.72 | 113.84 | 113.7 | 113.79 | 94620.0 |
| 2010-09-22 08:20:00 | SPY | ETF | 113.8 | 113.89 | 113.78 | 113.83 | 64820.0 |
| 2010-09-22 08:25:00 | SPY | ETF | 113.84 | 113.88 | 113.79 | 113.82 | 829258.0 |
| 2010-09-22 08:30:00 | SPY | ETF | 113.79 | 113.82 | 113.68 | 113.71 | 407618.0 |
| 2010-09-22 08:35:00 | SPY | ETF | 113.71 | 113.74 | 113.68 | 113.68 | 221501.0 |
| 2010-09-22 08:40:00 | SPY | ETF | 113.68 | 113.69 | 113.6 | 113.65 | 1036056.0 |
| 2010-09-22 08:45:00 | SPY | ETF | 113.67 | 113.69 | 113.63 | 113.66 | 60218.0 |
| 2010-09-22 08:50:00 | SPY | ETF | 113.67 | 113.74 | 113.64 | 113.73 | 233026.0 |
| 2010-09-22 08:55:00 | SPY | ETF | 113.73 | 113.74 | 113.62 | 113.66 | 224658.0 |
| 2010-09-22 09:00:00 | SPY | ETF | 113.65 | 113.73 | 113.65 | 113.73 | 78564.0 |
| 2010-09-22 09:05:00 | SPY | ETF | 113.71 | 113.82 | 113.71 | 113.81 | 209594.0 |
| 2010-09-22 09:10:00 | SPY | ETF | 113.81 | 113.86 | 113.8 | 113.84 | 230865.0 |
| 2010-09-22 09:15:00 | SPY | ETF | 113.85 | 113.88 | 113.82 | 113.86 | 121598.0 |
| 2010-09-22 09:20:00 | SPY | ETF | 113.86 | 113.86 | 113.76 | 113.8 | 89330.0 |
| 2010-09-22 09:25:00 | SPY | ETF | 113.8 | 113.81 | 113.7 | 113.8 | 215238.0 |
| 2010-09-22 09:30:00 | SPY | ETF | 113.8 | 114.07 | 113.76 | 114.05 | 4819405.0 |
> showing 50 of 34,524 rows — these rows as CSV