PREVIEW / etf_5min / 2001-09-20
file: by_date/etf_5min/2001/2001-09-20.parquet size: 38 KB rows: 1,560
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-20 09:30:00 | SPY | ETF | 100.4 | 100.62 | 100.05 | 100.15 | 827300.0 |
| 2001-09-20 09:35:00 | SPY | ETF | 100.08 | 100.55 | 99.95 | 100.55 | 674100.0 |
| 2001-09-20 09:40:00 | SPY | ETF | 100.55 | 100.95 | 100.4 | 100.81 | 909300.0 |
| 2001-09-20 09:45:00 | SPY | ETF | 100.75 | 100.9 | 100.4 | 100.49 | 958200.0 |
| 2001-09-20 09:50:00 | SPY | ETF | 100.4 | 100.65 | 100.2 | 100.6 | 513100.0 |
| 2001-09-20 09:55:00 | SPY | ETF | 100.6 | 100.85 | 100.35 | 100.85 | 606700.0 |
| 2001-09-20 10:00:00 | SPY | ETF | 100.68 | 101.17 | 100.58 | 100.99 | 909300.0 |
| 2001-09-20 10:05:00 | SPY | ETF | 101.15 | 101.15 | 100.5 | 100.55 | 906000.0 |
| 2001-09-20 10:10:00 | SPY | ETF | 100.5 | 100.6 | 100.15 | 100.15 | 765600.0 |
| 2001-09-20 10:15:00 | SPY | ETF | 100.18 | 100.31 | 100.05 | 100.2 | 840300.0 |
| 2001-09-20 10:20:00 | SPY | ETF | 100.15 | 100.4 | 100.1 | 100.15 | 811500.0 |
| 2001-09-20 10:25:00 | SPY | ETF | 100.19 | 100.25 | 99.75 | 99.76 | 701600.0 |
| 2001-09-20 10:30:00 | SPY | ETF | 99.86 | 100.1 | 99.79 | 99.91 | 615900.0 |
| 2001-09-20 10:35:00 | SPY | ETF | 99.91 | 100.05 | 99.61 | 99.66 | 685300.0 |
| 2001-09-20 10:40:00 | SPY | ETF | 99.71 | 99.75 | 99.3 | 99.5 | 426200.0 |
| 2001-09-20 10:45:00 | SPY | ETF | 99.54 | 99.69 | 99.4 | 99.45 | 569100.0 |
| 2001-09-20 10:50:00 | SPY | ETF | 99.35 | 99.94 | 99.34 | 99.71 | 811700.0 |
| 2001-09-20 10:55:00 | SPY | ETF | 99.8 | 100.15 | 99.56 | 100.12 | 457800.0 |
| 2001-09-20 11:00:00 | SPY | ETF | 100.1 | 100.16 | 99.93 | 100.0 | 373100.0 |
| 2001-09-20 11:05:00 | SPY | ETF | 99.94 | 100.08 | 99.9 | 100.03 | 356700.0 |
| 2001-09-20 11:10:00 | SPY | ETF | 100.05 | 100.2 | 99.83 | 100.1 | 983600.0 |
| 2001-09-20 11:15:00 | SPY | ETF | 100.14 | 100.5 | 100.1 | 100.4 | 1067800.0 |
| 2001-09-20 11:20:00 | SPY | ETF | 100.38 | 100.4 | 100.13 | 100.3 | 370300.0 |
| 2001-09-20 11:25:00 | SPY | ETF | 100.35 | 100.38 | 100.01 | 100.05 | 224300.0 |
| 2001-09-20 11:30:00 | SPY | ETF | 100.12 | 100.12 | 99.9 | 100.01 | 506500.0 |
| 2001-09-20 11:35:00 | SPY | ETF | 99.99 | 100.24 | 99.97 | 100.03 | 308500.0 |
| 2001-09-20 11:40:00 | SPY | ETF | 100.04 | 100.15 | 99.66 | 99.7 | 184300.0 |
| 2001-09-20 11:45:00 | SPY | ETF | 99.66 | 99.95 | 99.66 | 99.85 | 203700.0 |
| 2001-09-20 11:50:00 | SPY | ETF | 99.9 | 99.95 | 99.6 | 99.6 | 119100.0 |
| 2001-09-20 11:55:00 | SPY | ETF | 99.68 | 99.77 | 99.5 | 99.7 | 222500.0 |
| 2001-09-20 12:00:00 | SPY | ETF | 99.75 | 99.94 | 99.62 | 99.82 | 116400.0 |
| 2001-09-20 12:05:00 | SPY | ETF | 99.82 | 100.06 | 99.72 | 100.02 | 140700.0 |
| 2001-09-20 12:10:00 | SPY | ETF | 100.0 | 100.06 | 99.9 | 99.92 | 658700.0 |
| 2001-09-20 12:15:00 | SPY | ETF | 99.91 | 99.95 | 99.55 | 99.6 | 606400.0 |
| 2001-09-20 12:20:00 | SPY | ETF | 99.55 | 99.67 | 98.85 | 98.9 | 698500.0 |
| 2001-09-20 12:25:00 | SPY | ETF | 98.85 | 99.45 | 98.8 | 99.45 | 680400.0 |
| 2001-09-20 12:30:00 | SPY | ETF | 99.37 | 99.68 | 99.3 | 99.68 | 437700.0 |
| 2001-09-20 12:35:00 | SPY | ETF | 99.68 | 99.9 | 99.6 | 99.75 | 234200.0 |
| 2001-09-20 12:40:00 | SPY | ETF | 99.75 | 99.95 | 99.55 | 99.6 | 116300.0 |
| 2001-09-20 12:45:00 | SPY | ETF | 99.6 | 99.75 | 99.4 | 99.5 | 78800.0 |
| 2001-09-20 12:50:00 | SPY | ETF | 99.4 | 99.5 | 99.25 | 99.35 | 197500.0 |
| 2001-09-20 12:55:00 | SPY | ETF | 99.35 | 99.5 | 99.09 | 99.18 | 79400.0 |
| 2001-09-20 13:00:00 | SPY | ETF | 99.06 | 99.57 | 99.06 | 99.42 | 122500.0 |
| 2001-09-20 13:05:00 | SPY | ETF | 99.33 | 99.5 | 99.3 | 99.41 | 75700.0 |
| 2001-09-20 13:10:00 | SPY | ETF | 99.41 | 99.65 | 99.25 | 99.41 | 110800.0 |
| 2001-09-20 13:15:00 | SPY | ETF | 99.38 | 99.45 | 99.15 | 99.39 | 108100.0 |
| 2001-09-20 13:20:00 | SPY | ETF | 99.4 | 99.56 | 99.21 | 99.5 | 190800.0 |
| 2001-09-20 13:25:00 | SPY | ETF | 99.55 | 99.55 | 99.4 | 99.54 | 129700.0 |
| 2001-09-20 13:30:00 | SPY | ETF | 99.55 | 99.73 | 99.35 | 99.7 | 295200.0 |
| 2001-09-20 13:35:00 | SPY | ETF | 99.64 | 99.8 | 99.5 | 99.7 | 336300.0 |
> showing 50 of 1,560 rows — these rows as CSV