PREVIEW / etf_5min / 2008-06-13
file: by_date/etf_5min/2008/2008-06-13.parquet size: 473 KB rows: 21,111
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-13 04:15:00 | SPY | ETF | 134.21 | 134.21 | 134.21 | 134.21 | 500.0 |
| 2008-06-13 05:10:00 | SPY | ETF | 134.33 | 134.33 | 134.33 | 134.33 | 100.0 |
| 2008-06-13 06:00:00 | SPY | ETF | 134.55 | 134.55 | 134.55 | 134.55 | 100.0 |
| 2008-06-13 06:05:00 | SPY | ETF | 134.46 | 134.46 | 134.46 | 134.46 | 8100.0 |
| 2008-06-13 06:20:00 | SPY | ETF | 134.66 | 134.66 | 134.66 | 134.66 | 100.0 |
| 2008-06-13 06:35:00 | SPY | ETF | 134.71 | 134.76 | 134.66 | 134.66 | 3100.0 |
| 2008-06-13 06:40:00 | SPY | ETF | 134.62 | 134.62 | 134.61 | 134.61 | 2200.0 |
| 2008-06-13 06:45:00 | SPY | ETF | 134.61 | 134.61 | 134.61 | 134.61 | 300.0 |
| 2008-06-13 06:50:00 | SPY | ETF | 134.62 | 134.67 | 134.62 | 134.67 | 7500.0 |
| 2008-06-13 06:55:00 | SPY | ETF | 134.67 | 134.7 | 134.67 | 134.7 | 1100.0 |
| 2008-06-13 07:00:00 | SPY | ETF | 134.75 | 134.76 | 134.69 | 134.69 | 19200.0 |
| 2008-06-13 07:05:00 | SPY | ETF | 134.64 | 134.64 | 134.55 | 134.55 | 1500.0 |
| 2008-06-13 07:10:00 | SPY | ETF | 134.54 | 134.57 | 134.54 | 134.57 | 2900.0 |
| 2008-06-13 07:15:00 | SPY | ETF | 134.61 | 134.64 | 134.6 | 134.61 | 144400.0 |
| 2008-06-13 07:20:00 | SPY | ETF | 134.61 | 134.62 | 134.5 | 134.53 | 14400.0 |
| 2008-06-13 07:25:00 | SPY | ETF | 134.59 | 134.61 | 134.51 | 134.57 | 21900.0 |
| 2008-06-13 07:30:00 | SPY | ETF | 134.51 | 134.56 | 134.42 | 134.45 | 102400.0 |
| 2008-06-13 07:35:00 | SPY | ETF | 134.49 | 134.49 | 134.45 | 134.48 | 14500.0 |
| 2008-06-13 07:40:00 | SPY | ETF | 134.47 | 134.5 | 134.46 | 134.5 | 10700.0 |
| 2008-06-13 07:45:00 | SPY | ETF | 134.49 | 134.49 | 134.42 | 134.46 | 82200.0 |
| 2008-06-13 07:50:00 | SPY | ETF | 134.42 | 134.51 | 134.37 | 134.47 | 124600.0 |
| 2008-06-13 07:55:00 | SPY | ETF | 134.53 | 134.67 | 134.53 | 134.66 | 36709.0 |
| 2008-06-13 08:00:00 | SPY | ETF | 134.46 | 134.82 | 134.1 | 134.7 | 424225.0 |
| 2008-06-13 08:05:00 | SPY | ETF | 134.71 | 134.82 | 134.69 | 134.76 | 437804.0 |
| 2008-06-13 08:10:00 | SPY | ETF | 134.8 | 134.87 | 134.79 | 134.82 | 1107798.0 |
| 2008-06-13 08:15:00 | SPY | ETF | 134.82 | 134.87 | 134.79 | 134.87 | 538000.0 |
| 2008-06-13 08:20:00 | SPY | ETF | 134.87 | 134.95 | 134.83 | 134.86 | 1160077.0 |
| 2008-06-13 08:25:00 | SPY | ETF | 134.85 | 134.96 | 134.51 | 134.51 | 653851.0 |
| 2008-06-13 08:30:00 | SPY | ETF | 134.7 | 135.24 | 134.35 | 135.19 | 5978535.0 |
| 2008-06-13 08:35:00 | SPY | ETF | 135.18 | 135.37 | 134.97 | 135.35 | 2439350.0 |
| 2008-06-13 08:40:00 | SPY | ETF | 135.35 | 135.47 | 135.26 | 135.31 | 1174948.0 |
| 2008-06-13 08:45:00 | SPY | ETF | 135.32 | 135.37 | 135.13 | 135.37 | 657857.0 |
| 2008-06-13 08:50:00 | SPY | ETF | 135.36 | 135.37 | 135.28 | 135.37 | 526207.0 |
| 2008-06-13 08:55:00 | SPY | ETF | 135.37 | 135.39 | 135.21 | 135.21 | 166986.0 |
| 2008-06-13 09:00:00 | SPY | ETF | 135.22 | 135.34 | 135.21 | 135.3 | 522866.0 |
| 2008-06-13 09:05:00 | SPY | ETF | 135.29 | 135.38 | 135.29 | 135.33 | 480183.0 |
| 2008-06-13 09:10:00 | SPY | ETF | 135.34 | 135.39 | 135.3 | 135.34 | 363662.0 |
| 2008-06-13 09:15:00 | SPY | ETF | 135.34 | 135.38 | 135.28 | 135.32 | 189427.0 |
| 2008-06-13 09:20:00 | SPY | ETF | 135.35 | 135.36 | 135.27 | 135.27 | 241897.0 |
| 2008-06-13 09:25:00 | SPY | ETF | 135.26 | 135.34 | 135.15 | 135.17 | 1067871.0 |
| 2008-06-13 09:30:00 | SPY | ETF | 135.17 | 135.37 | 135.04 | 135.04 | 5020510.0 |
| 2008-06-13 09:35:00 | SPY | ETF | 135.05 | 135.25 | 134.97 | 135.16 | 4377752.0 |
| 2008-06-13 09:40:00 | SPY | ETF | 135.16 | 135.16 | 134.76 | 134.82 | 4503468.0 |
| 2008-06-13 09:45:00 | SPY | ETF | 134.82 | 134.83 | 134.61 | 134.715 | 4922441.0 |
| 2008-06-13 09:50:00 | SPY | ETF | 134.72 | 134.94 | 134.695 | 134.8 | 4493291.0 |
| 2008-06-13 09:55:00 | SPY | ETF | 134.85 | 135.36 | 134.71 | 135.25 | 11611041.0 |
| 2008-06-13 10:00:00 | SPY | ETF | 135.25 | 136.1 | 135.15 | 136.06 | 9145054.0 |
| 2008-06-13 10:05:00 | SPY | ETF | 136.0601 | 136.07 | 135.6 | 135.8601 | 7547995.0 |
| 2008-06-13 10:10:00 | SPY | ETF | 135.86 | 136.2 | 135.73 | 135.92 | 4560413.0 |
| 2008-06-13 10:15:00 | SPY | ETF | 135.93 | 136.35 | 135.93 | 136.23 | 6557734.0 |
> showing 50 of 21,111 rows — these rows as CSV