PREVIEW / etf_5min / 2007-11-13
file: by_date/etf_5min/2007/2007-11-13.parquet size: 422 KB rows: 20,346
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-11-13 05:35:00 | SPY | ETF | 144.53 | 144.53 | 144.53 | 144.53 | 4700.0 |
| 2007-11-13 05:40:00 | SPY | ETF | 144.53 | 144.53 | 144.53 | 144.53 | 1100.0 |
| 2007-11-13 05:45:00 | SPY | ETF | 144.55 | 144.55 | 144.55 | 144.55 | 3000.0 |
| 2007-11-13 05:50:00 | SPY | ETF | 144.65 | 144.65 | 144.65 | 144.65 | 3000.0 |
| 2007-11-13 05:55:00 | SPY | ETF | 144.65 | 144.65 | 144.65 | 144.65 | 2500.0 |
| 2007-11-13 06:00:00 | SPY | ETF | 144.65 | 144.68 | 144.65 | 144.68 | 5000.0 |
| 2007-11-13 06:05:00 | SPY | ETF | 144.75 | 144.85 | 144.75 | 144.85 | 14100.0 |
| 2007-11-13 06:10:00 | SPY | ETF | 144.85 | 144.97 | 144.85 | 144.97 | 8000.0 |
| 2007-11-13 06:25:00 | SPY | ETF | 144.95 | 144.99 | 144.95 | 144.99 | 6000.0 |
| 2007-11-13 06:30:00 | SPY | ETF | 145.04 | 145.07 | 145.04 | 145.07 | 165500.0 |
| 2007-11-13 06:35:00 | SPY | ETF | 144.96 | 144.96 | 144.92 | 144.92 | 51000.0 |
| 2007-11-13 06:40:00 | SPY | ETF | 145.0 | 145.02 | 145.0 | 145.02 | 39800.0 |
| 2007-11-13 06:45:00 | SPY | ETF | 144.98 | 145.0 | 144.98 | 144.99 | 14000.0 |
| 2007-11-13 06:50:00 | SPY | ETF | 144.88 | 144.88 | 144.75 | 144.75 | 23500.0 |
| 2007-11-13 06:55:00 | SPY | ETF | 144.74 | 144.74 | 144.74 | 144.74 | 1000.0 |
| 2007-11-13 07:00:00 | SPY | ETF | 144.73 | 144.8 | 144.72 | 144.8 | 47900.0 |
| 2007-11-13 07:05:00 | SPY | ETF | 144.81 | 144.93 | 144.81 | 144.85 | 38100.0 |
| 2007-11-13 07:10:00 | SPY | ETF | 144.85 | 144.89 | 144.83 | 144.86 | 6800.0 |
| 2007-11-13 07:15:00 | SPY | ETF | 144.88 | 144.88 | 144.8 | 144.85 | 55600.0 |
| 2007-11-13 07:20:00 | SPY | ETF | 144.8 | 144.83 | 144.78 | 144.79 | 57400.0 |
| 2007-11-13 07:25:00 | SPY | ETF | 144.75 | 144.81 | 144.69 | 144.81 | 214900.0 |
| 2007-11-13 07:30:00 | SPY | ETF | 144.8 | 144.85 | 144.76 | 144.84 | 33400.0 |
| 2007-11-13 07:35:00 | SPY | ETF | 144.8 | 144.9 | 144.8 | 144.86 | 50900.0 |
| 2007-11-13 07:40:00 | SPY | ETF | 144.86 | 144.9 | 144.83 | 144.9 | 156500.0 |
| 2007-11-13 07:45:00 | SPY | ETF | 144.9 | 144.95 | 144.86 | 144.89 | 94900.0 |
| 2007-11-13 07:50:00 | SPY | ETF | 144.92 | 145.02 | 144.91 | 144.99 | 145400.0 |
| 2007-11-13 07:55:00 | SPY | ETF | 145.0 | 145.13 | 145.0 | 145.06 | 457900.0 |
| 2007-11-13 08:00:00 | SPY | ETF | 145.06 | 145.17 | 144.66 | 145.11 | 1902100.0 |
| 2007-11-13 08:05:00 | SPY | ETF | 145.15 | 145.17 | 145.07 | 145.08 | 258300.0 |
| 2007-11-13 08:10:00 | SPY | ETF | 145.09 | 145.09 | 144.93 | 145.08 | 530700.0 |
| 2007-11-13 08:15:00 | SPY | ETF | 145.07 | 145.08 | 145.0 | 145.01 | 166200.0 |
| 2007-11-13 08:20:00 | SPY | ETF | 145.0 | 145.0 | 144.84 | 144.92 | 112100.0 |
| 2007-11-13 08:25:00 | SPY | ETF | 144.94 | 144.97 | 144.91 | 144.96 | 277700.0 |
| 2007-11-13 08:30:00 | SPY | ETF | 144.96 | 145.04 | 144.96 | 144.99 | 173700.0 |
| 2007-11-13 08:35:00 | SPY | ETF | 145.02 | 145.02 | 144.88 | 145.0 | 266300.0 |
| 2007-11-13 08:40:00 | SPY | ETF | 145.0 | 145.05 | 145.0 | 145.03 | 110400.0 |
| 2007-11-13 08:45:00 | SPY | ETF | 145.03 | 145.11 | 145.0 | 145.1 | 512200.0 |
| 2007-11-13 08:50:00 | SPY | ETF | 145.1 | 145.15 | 145.08 | 145.15 | 173100.0 |
| 2007-11-13 08:55:00 | SPY | ETF | 145.15 | 145.18 | 145.08 | 145.08 | 202900.0 |
| 2007-11-13 09:00:00 | SPY | ETF | 145.08 | 145.28 | 145.08 | 145.19 | 159300.0 |
| 2007-11-13 09:05:00 | SPY | ETF | 145.2 | 145.24 | 145.18 | 145.22 | 722699.0 |
| 2007-11-13 09:10:00 | SPY | ETF | 145.22 | 145.44 | 145.2 | 145.38 | 594985.0 |
| 2007-11-13 09:15:00 | SPY | ETF | 145.38 | 145.39 | 145.33 | 145.35 | 196100.0 |
| 2007-11-13 09:20:00 | SPY | ETF | 145.35 | 145.41 | 145.33 | 145.33 | 610700.0 |
| 2007-11-13 09:25:00 | SPY | ETF | 145.33 | 145.35 | 145.25 | 145.25 | 883440.0 |
| 2007-11-13 09:30:00 | SPY | ETF | 145.26 | 145.35 | 145.22 | 145.33 | 4217541.0 |
| 2007-11-13 09:35:00 | SPY | ETF | 145.33 | 145.88 | 145.32 | 145.87 | 7163144.0 |
| 2007-11-13 09:40:00 | SPY | ETF | 145.86 | 146.03 | 145.69 | 145.74 | 6241621.0 |
| 2007-11-13 09:45:00 | SPY | ETF | 145.74 | 145.76 | 145.61 | 145.71 | 3362262.0 |
| 2007-11-13 09:50:00 | SPY | ETF | 145.71 | 145.71 | 145.32 | 145.5 | 4261841.0 |
> showing 50 of 20,346 rows — these rows as CSV