PREVIEW / etf_5min / 2002-01-31
file: by_date/etf_5min/2002/2002-01-31.parquet size: 39 KB rows: 1,543
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-31 08:00:00 | SPY | ETF | 111.7943 | 112.1322 | 111.7943 | 112.1322 | 7760.0 |
| 2002-01-31 08:05:00 | SPY | ETF | 112.1322 | 112.15 | 112.1322 | 112.1322 | 180.0 |
| 2002-01-31 08:10:00 | SPY | ETF | 112.1322 | 112.1322 | 112.1322 | 112.1322 | 60.0 |
| 2002-01-31 08:15:00 | SPY | ETF | 112.1856 | 112.2211 | 112.1856 | 112.2211 | 3430.0 |
| 2002-01-31 08:20:00 | SPY | ETF | 112.2211 | 112.2389 | 112.2211 | 112.2389 | 2530.0 |
| 2002-01-31 08:25:00 | SPY | ETF | 112.2211 | 112.2211 | 112.1322 | 112.1322 | 7970.0 |
| 2002-01-31 08:30:00 | SPY | ETF | 112.1856 | 112.2389 | 112.1856 | 112.2211 | 1120.0 |
| 2002-01-31 08:35:00 | SPY | ETF | 112.2211 | 112.2389 | 112.2211 | 112.2389 | 2080.0 |
| 2002-01-31 08:40:00 | SPY | ETF | 112.1678 | 112.1678 | 112.1678 | 112.1678 | 280.0 |
| 2002-01-31 08:45:00 | SPY | ETF | 112.1322 | 112.1322 | 112.1322 | 112.1322 | 2700.0 |
| 2002-01-31 08:50:00 | SPY | ETF | 112.1678 | 112.1678 | 112.15 | 112.15 | 390.0 |
| 2002-01-31 09:00:00 | SPY | ETF | 112.1322 | 112.1322 | 112.1322 | 112.1322 | 560.0 |
| 2002-01-31 09:05:00 | SPY | ETF | 112.2567 | 112.3101 | 112.2567 | 112.3101 | 170.0 |
| 2002-01-31 09:10:00 | SPY | ETF | 112.2923 | 112.399 | 112.1322 | 112.3101 | 1060.0 |
| 2002-01-31 09:15:00 | SPY | ETF | 112.1322 | 112.1322 | 112.1322 | 112.1322 | 1910.0 |
| 2002-01-31 09:20:00 | SPY | ETF | 112.1322 | 112.2211 | 112.0611 | 112.0611 | 6130.0 |
| 2002-01-31 09:25:00 | SPY | ETF | 112.2211 | 112.2389 | 112.0611 | 112.1322 | 34980.0 |
| 2002-01-31 09:30:00 | SPY | ETF | 112.15 | 112.5663 | 112.1092 | 112.5202 | 524370.0 |
| 2002-01-31 09:35:00 | SPY | ETF | 112.515 | 113.0148 | 112.1897 | 112.7607 | 520000.0 |
| 2002-01-31 09:40:00 | SPY | ETF | 112.7554 | 112.9154 | 112.5212 | 112.5745 | 283820.0 |
| 2002-01-31 09:45:00 | SPY | ETF | 112.5515 | 112.7543 | 112.4219 | 112.4774 | 274670.0 |
| 2002-01-31 09:50:00 | SPY | ETF | 112.4899 | 112.6468 | 112.1472 | 112.5224 | 250240.0 |
| 2002-01-31 09:55:00 | SPY | ETF | 112.5172 | 112.905 | 112.441 | 112.7984 | 225250.0 |
| 2002-01-31 10:00:00 | SPY | ETF | 112.811 | 113.1454 | 112.6282 | 113.0921 | 575970.0 |
| 2002-01-31 10:05:00 | SPY | ETF | 113.0869 | 113.3 | 112.8028 | 113.1834 | 447610.0 |
| 2002-01-31 10:10:00 | SPY | ETF | 112.9499 | 113.0362 | 112.6376 | 112.7442 | 234240.0 |
| 2002-01-31 10:15:00 | SPY | ETF | 112.7772 | 113.3541 | 112.668 | 113.0695 | 306040.0 |
| 2002-01-31 10:20:00 | SPY | ETF | 113.0848 | 113.1916 | 112.5052 | 112.5408 | 199690.0 |
| 2002-01-31 10:25:00 | SPY | ETF | 112.5205 | 112.7672 | 112.3347 | 112.6706 | 284480.0 |
| 2002-01-31 10:30:00 | SPY | ETF | 112.7216 | 112.775 | 112.5078 | 112.7116 | 218010.0 |
| 2002-01-31 10:35:00 | SPY | ETF | 112.7269 | 112.7626 | 112.5565 | 112.5565 | 161230.0 |
| 2002-01-31 10:40:00 | SPY | ETF | 112.5718 | 112.8191 | 112.0621 | 112.0978 | 290710.0 |
| 2002-01-31 10:45:00 | SPY | ETF | 112.0953 | 112.3173 | 111.9881 | 112.1923 | 286450.0 |
| 2002-01-31 10:50:00 | SPY | ETF | 112.2255 | 112.2945 | 111.738 | 112.0189 | 275460.0 |
| 2002-01-31 10:55:00 | SPY | ETF | 112.0343 | 112.139 | 111.7764 | 111.9169 | 201320.0 |
| 2002-01-31 11:00:00 | SPY | ETF | 111.9323 | 112.1908 | 111.8761 | 112.0118 | 266290.0 |
| 2002-01-31 11:05:00 | SPY | ETF | 112.063 | 112.3136 | 111.8919 | 111.9457 | 298420.0 |
| 2002-01-31 11:10:00 | SPY | ETF | 111.9611 | 112.2022 | 111.7616 | 112.0588 | 266200.0 |
| 2002-01-31 11:15:00 | SPY | ETF | 112.0743 | 112.1101 | 111.8314 | 111.8314 | 198490.0 |
| 2002-01-31 11:20:00 | SPY | ETF | 111.8469 | 112.47 | 111.8469 | 112.2499 | 167470.0 |
| 2002-01-31 11:25:00 | SPY | ETF | 112.2655 | 112.2834 | 111.8657 | 111.8788 | 173980.0 |
| 2002-01-31 11:30:00 | SPY | ETF | 111.9123 | 112.0716 | 111.62 | 111.8439 | 209840.0 |
| 2002-01-31 11:35:00 | SPY | ETF | 111.821 | 112.1249 | 111.7492 | 112.107 | 131360.0 |
| 2002-01-31 11:40:00 | SPY | ETF | 112.1021 | 112.3977 | 112.0434 | 112.1904 | 679120.0 |
| 2002-01-31 11:45:00 | SPY | ETF | 112.1676 | 112.3243 | 111.9914 | 112.184 | 113550.0 |
| 2002-01-31 11:50:00 | SPY | ETF | 112.1971 | 112.3048 | 112.0797 | 112.2495 | 168650.0 |
| 2002-01-31 11:55:00 | SPY | ETF | 112.2446 | 112.3915 | 112.1679 | 112.3687 | 172820.0 |
| 2002-01-31 12:00:00 | SPY | ETF | 112.3818 | 112.5074 | 112.3265 | 112.3623 | 151570.0 |
| 2002-01-31 12:05:00 | SPY | ETF | 112.3754 | 112.5712 | 112.1422 | 112.4277 | 260300.0 |
| 2002-01-31 12:10:00 | SPY | ETF | 112.4587 | 112.7801 | 112.3332 | 112.7621 | 246640.0 |
> showing 50 of 1,543 rows — these rows as CSV