PREVIEW / etf_5min / 2008-11-03
file: by_date/etf_5min/2008/2008-11-03.parquet size: 497 KB rows: 24,551
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-11-03 04:15:00 | SPY | ETF | 97.3 | 97.3 | 97.3 | 97.3 | 100.0 |
| 2008-11-03 04:35:00 | SPY | ETF | 97.39 | 97.41 | 97.39 | 97.41 | 2000.0 |
| 2008-11-03 04:40:00 | SPY | ETF | 97.28 | 97.28 | 97.28 | 97.28 | 100.0 |
| 2008-11-03 04:45:00 | SPY | ETF | 97.24 | 97.24 | 97.21 | 97.21 | 618.0 |
| 2008-11-03 04:50:00 | SPY | ETF | 97.21 | 97.21 | 97.18 | 97.18 | 320.0 |
| 2008-11-03 05:00:00 | SPY | ETF | 97.14 | 97.14 | 97.14 | 97.14 | 100.0 |
| 2008-11-03 05:05:00 | SPY | ETF | 97.14 | 97.14 | 97.14 | 97.14 | 100.0 |
| 2008-11-03 05:15:00 | SPY | ETF | 97.21 | 97.21 | 97.17 | 97.17 | 200.0 |
| 2008-11-03 05:20:00 | SPY | ETF | 97.08 | 97.08 | 97.08 | 97.08 | 100.0 |
| 2008-11-03 05:25:00 | SPY | ETF | 97.0 | 97.0 | 97.0 | 97.0 | 100.0 |
| 2008-11-03 05:30:00 | SPY | ETF | 96.96 | 96.96 | 96.79 | 96.86 | 1400.0 |
| 2008-11-03 06:05:00 | SPY | ETF | 96.83 | 96.83 | 96.83 | 96.83 | 100.0 |
| 2008-11-03 06:10:00 | SPY | ETF | 96.79 | 96.79 | 96.79 | 96.79 | 200.0 |
| 2008-11-03 06:20:00 | SPY | ETF | 96.92 | 96.92 | 96.92 | 96.92 | 100.0 |
| 2008-11-03 06:35:00 | SPY | ETF | 96.89 | 96.89 | 96.89 | 96.89 | 100.0 |
| 2008-11-03 06:45:00 | SPY | ETF | 97.16 | 97.16 | 97.14 | 97.14 | 10000.0 |
| 2008-11-03 06:50:00 | SPY | ETF | 97.0 | 97.0 | 97.0 | 97.0 | 15000.0 |
| 2008-11-03 06:55:00 | SPY | ETF | 97.21 | 97.41 | 97.21 | 97.32 | 3600.0 |
| 2008-11-03 07:00:00 | SPY | ETF | 97.41 | 97.61 | 97.41 | 97.55 | 25400.0 |
| 2008-11-03 07:05:00 | SPY | ETF | 97.55 | 97.63 | 97.54 | 97.55 | 5500.0 |
| 2008-11-03 07:10:00 | SPY | ETF | 97.53 | 97.63 | 97.49 | 97.54 | 46200.0 |
| 2008-11-03 07:15:00 | SPY | ETF | 97.54 | 97.54 | 97.34 | 97.37 | 46010.0 |
| 2008-11-03 07:20:00 | SPY | ETF | 97.32 | 97.43 | 97.3 | 97.4 | 26525.0 |
| 2008-11-03 07:25:00 | SPY | ETF | 97.48 | 97.49 | 97.34 | 97.35 | 94578.0 |
| 2008-11-03 07:30:00 | SPY | ETF | 97.35 | 97.42 | 97.3 | 97.35 | 164150.0 |
| 2008-11-03 07:35:00 | SPY | ETF | 97.36 | 97.4 | 97.22 | 97.22 | 49333.0 |
| 2008-11-03 07:40:00 | SPY | ETF | 97.24 | 97.37 | 97.24 | 97.28 | 76785.0 |
| 2008-11-03 07:45:00 | SPY | ETF | 97.27 | 97.42 | 97.26 | 97.36 | 89200.0 |
| 2008-11-03 07:50:00 | SPY | ETF | 97.36 | 97.44 | 97.18 | 97.24 | 158779.0 |
| 2008-11-03 07:55:00 | SPY | ETF | 97.24 | 97.24 | 97.16 | 97.19 | 50100.0 |
| 2008-11-03 08:00:00 | SPY | ETF | 97.55 | 98.15 | 97.11 | 97.17 | 464148.0 |
| 2008-11-03 08:05:00 | SPY | ETF | 97.16 | 97.3 | 97.04 | 97.09 | 200936.0 |
| 2008-11-03 08:10:00 | SPY | ETF | 97.09 | 97.17 | 97.05 | 97.09 | 116452.0 |
| 2008-11-03 08:15:00 | SPY | ETF | 97.09 | 97.09 | 96.75 | 96.75 | 303570.0 |
| 2008-11-03 08:20:00 | SPY | ETF | 96.75 | 96.79 | 96.51 | 96.69 | 352724.0 |
| 2008-11-03 08:25:00 | SPY | ETF | 96.7 | 96.84 | 96.67 | 96.75 | 303807.0 |
| 2008-11-03 08:30:00 | SPY | ETF | 96.75 | 96.79 | 96.6 | 96.65 | 510770.0 |
| 2008-11-03 08:35:00 | SPY | ETF | 96.67 | 96.83 | 96.62 | 96.72 | 268696.0 |
| 2008-11-03 08:40:00 | SPY | ETF | 96.72 | 96.73 | 96.61 | 96.65 | 150045.0 |
| 2008-11-03 08:45:00 | SPY | ETF | 96.64 | 96.73 | 96.61 | 96.68 | 77014.0 |
| 2008-11-03 08:50:00 | SPY | ETF | 96.68 | 96.76 | 96.66 | 96.75 | 66933.0 |
| 2008-11-03 08:55:00 | SPY | ETF | 96.76 | 96.79 | 96.65 | 96.68 | 100991.0 |
| 2008-11-03 09:00:00 | SPY | ETF | 96.69 | 96.71 | 96.6 | 96.64 | 102440.0 |
| 2008-11-03 09:05:00 | SPY | ETF | 96.63 | 96.72 | 96.6 | 96.69 | 55786.0 |
| 2008-11-03 09:10:00 | SPY | ETF | 96.69 | 96.73 | 96.64 | 96.68 | 49477.0 |
| 2008-11-03 09:15:00 | SPY | ETF | 96.66 | 96.69 | 96.51 | 96.61 | 239683.0 |
| 2008-11-03 09:20:00 | SPY | ETF | 96.63 | 96.69 | 96.53 | 96.61 | 75883.0 |
| 2008-11-03 09:25:00 | SPY | ETF | 96.61 | 96.77 | 96.51 | 96.75 | 303872.0 |
| 2008-11-03 09:30:00 | SPY | ETF | 96.78 | 96.94 | 96.42 | 96.65 | 5047315.0 |
| 2008-11-03 09:35:00 | SPY | ETF | 96.66 | 97.33 | 96.62 | 97.16 | 4649692.0 |
> showing 50 of 24,551 rows — these rows as CSV