PREVIEW / etf_5min / 2008-06-24
file: by_date/etf_5min/2008/2008-06-24.parquet size: 504 KB rows: 22,886
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-24 04:30:00 | SPY | ETF | 131.58 | 131.58 | 131.58 | 131.58 | 2000.0 |
| 2008-06-24 04:45:00 | SPY | ETF | 131.53 | 131.53 | 131.53 | 131.53 | 1000.0 |
| 2008-06-24 05:25:00 | SPY | ETF | 131.1 | 131.1 | 131.05 | 131.05 | 1200.0 |
| 2008-06-24 05:30:00 | SPY | ETF | 131.0 | 131.0 | 131.0 | 131.0 | 200.0 |
| 2008-06-24 05:35:00 | SPY | ETF | 130.85 | 130.86 | 130.85 | 130.86 | 400.0 |
| 2008-06-24 05:40:00 | SPY | ETF | 130.93 | 130.93 | 130.71 | 130.71 | 1300.0 |
| 2008-06-24 05:45:00 | SPY | ETF | 130.65 | 130.65 | 130.45 | 130.45 | 900.0 |
| 2008-06-24 05:50:00 | SPY | ETF | 130.71 | 130.75 | 130.71 | 130.75 | 35000.0 |
| 2008-06-24 05:55:00 | SPY | ETF | 130.8 | 130.89 | 130.8 | 130.86 | 6000.0 |
| 2008-06-24 06:05:00 | SPY | ETF | 130.81 | 130.81 | 130.71 | 130.71 | 4000.0 |
| 2008-06-24 06:10:00 | SPY | ETF | 130.69 | 130.69 | 130.69 | 130.69 | 4000.0 |
| 2008-06-24 06:20:00 | SPY | ETF | 130.74 | 130.74 | 130.74 | 130.74 | 500.0 |
| 2008-06-24 06:25:00 | SPY | ETF | 130.81 | 130.81 | 130.81 | 130.81 | 1000.0 |
| 2008-06-24 06:30:00 | SPY | ETF | 130.81 | 130.81 | 130.81 | 130.81 | 500.0 |
| 2008-06-24 06:35:00 | SPY | ETF | 130.89 | 130.89 | 130.89 | 130.89 | 25000.0 |
| 2008-06-24 06:40:00 | SPY | ETF | 130.77 | 130.77 | 130.77 | 130.77 | 200.0 |
| 2008-06-24 06:45:00 | SPY | ETF | 130.82 | 130.82 | 130.8 | 130.8 | 3000.0 |
| 2008-06-24 06:50:00 | SPY | ETF | 130.79 | 130.79 | 130.78 | 130.78 | 2000.0 |
| 2008-06-24 06:55:00 | SPY | ETF | 130.82 | 130.82 | 130.82 | 130.82 | 500.0 |
| 2008-06-24 07:00:00 | SPY | ETF | 130.8 | 130.82 | 130.7 | 130.72 | 208060.0 |
| 2008-06-24 07:05:00 | SPY | ETF | 130.74 | 130.78 | 130.72 | 130.72 | 100700.0 |
| 2008-06-24 07:10:00 | SPY | ETF | 130.72 | 130.72 | 130.71 | 130.71 | 51990.0 |
| 2008-06-24 07:15:00 | SPY | ETF | 130.7 | 130.75 | 130.65 | 130.75 | 67796.0 |
| 2008-06-24 07:20:00 | SPY | ETF | 130.7 | 130.73 | 130.69 | 130.72 | 124220.0 |
| 2008-06-24 07:25:00 | SPY | ETF | 130.72 | 130.72 | 130.52 | 130.52 | 525982.0 |
| 2008-06-24 07:30:00 | SPY | ETF | 130.54 | 130.57 | 130.54 | 130.57 | 35300.0 |
| 2008-06-24 07:35:00 | SPY | ETF | 130.58 | 130.62 | 130.57 | 130.57 | 32600.0 |
| 2008-06-24 07:40:00 | SPY | ETF | 130.57 | 130.62 | 130.57 | 130.6 | 8900.0 |
| 2008-06-24 07:45:00 | SPY | ETF | 130.6 | 130.74 | 130.59 | 130.71 | 96590.0 |
| 2008-06-24 07:50:00 | SPY | ETF | 130.74 | 130.81 | 130.68 | 130.78 | 149300.0 |
| 2008-06-24 07:55:00 | SPY | ETF | 130.77 | 130.79 | 130.72 | 130.74 | 114300.0 |
| 2008-06-24 08:00:00 | SPY | ETF | 130.72 | 130.75 | 130.62 | 130.66 | 1750534.0 |
| 2008-06-24 08:05:00 | SPY | ETF | 130.66 | 131.48 | 130.61 | 130.72 | 180133.0 |
| 2008-06-24 08:10:00 | SPY | ETF | 130.73 | 130.79 | 130.73 | 130.79 | 41900.0 |
| 2008-06-24 08:15:00 | SPY | ETF | 130.75 | 130.82 | 130.74 | 130.82 | 86950.0 |
| 2008-06-24 08:20:00 | SPY | ETF | 130.82 | 130.84 | 130.76 | 130.77 | 206420.0 |
| 2008-06-24 08:25:00 | SPY | ETF | 130.78 | 130.78 | 130.7 | 130.7 | 450862.0 |
| 2008-06-24 08:30:00 | SPY | ETF | 130.69 | 130.78 | 130.68 | 130.77 | 135300.0 |
| 2008-06-24 08:35:00 | SPY | ETF | 130.81 | 130.81 | 130.74 | 130.75 | 433300.0 |
| 2008-06-24 08:40:00 | SPY | ETF | 130.75 | 130.8 | 130.73 | 130.79 | 92467.0 |
| 2008-06-24 08:45:00 | SPY | ETF | 130.79 | 130.88 | 130.77 | 130.83 | 328228.0 |
| 2008-06-24 08:50:00 | SPY | ETF | 130.81 | 130.9 | 130.8 | 130.83 | 69321.0 |
| 2008-06-24 08:55:00 | SPY | ETF | 130.81 | 130.89 | 130.79 | 130.82 | 257136.0 |
| 2008-06-24 09:00:00 | SPY | ETF | 130.87 | 131.05 | 130.87 | 130.92 | 1572513.0 |
| 2008-06-24 09:05:00 | SPY | ETF | 130.94 | 130.98 | 130.89 | 130.92 | 335059.0 |
| 2008-06-24 09:10:00 | SPY | ETF | 130.93 | 130.98 | 130.89 | 130.97 | 333425.0 |
| 2008-06-24 09:15:00 | SPY | ETF | 130.96 | 131.04 | 130.94 | 131.0 | 125368.0 |
| 2008-06-24 09:20:00 | SPY | ETF | 130.98 | 131.03 | 130.95 | 131.01 | 150614.0 |
| 2008-06-24 09:25:00 | SPY | ETF | 131.02 | 131.1 | 130.99 | 131.03 | 428848.0 |
| 2008-06-24 09:30:00 | SPY | ETF | 131.05 | 131.25 | 130.97 | 131.19 | 4710897.0 |
> showing 50 of 22,886 rows — these rows as CSV