PREVIEW / etf_5min / 2011-01-07
file: by_date/etf_5min/2011/2011-01-07.parquet size: 892 KB rows: 36,403
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-07 04:00:00 | SPY | ETF | 127.15 | 127.15 | 127.11 | 127.11 | 600.0 |
| 2011-01-07 04:20:00 | SPY | ETF | 127.22 | 127.22 | 127.22 | 127.22 | 100.0 |
| 2011-01-07 04:30:00 | SPY | ETF | 127.2 | 127.2 | 127.2 | 127.2 | 100.0 |
| 2011-01-07 05:15:00 | SPY | ETF | 127.18 | 127.18 | 127.18 | 127.18 | 100.0 |
| 2011-01-07 05:25:00 | SPY | ETF | 127.11 | 127.11 | 127.01 | 127.01 | 2060.0 |
| 2011-01-07 05:45:00 | SPY | ETF | 127.2 | 127.2 | 127.2 | 127.2 | 500.0 |
| 2011-01-07 06:00:00 | SPY | ETF | 127.19 | 127.19 | 127.17 | 127.17 | 2200.0 |
| 2011-01-07 06:05:00 | SPY | ETF | 127.15 | 127.15 | 127.15 | 127.15 | 100.0 |
| 2011-01-07 06:25:00 | SPY | ETF | 127.17 | 127.17 | 127.17 | 127.17 | 100.0 |
| 2011-01-07 06:40:00 | SPY | ETF | 127.27 | 127.27 | 127.27 | 127.27 | 500.0 |
| 2011-01-07 06:50:00 | SPY | ETF | 127.38 | 127.38 | 127.38 | 127.38 | 150.0 |
| 2011-01-07 06:55:00 | SPY | ETF | 127.42 | 127.44 | 127.42 | 127.44 | 9000.0 |
| 2011-01-07 07:00:00 | SPY | ETF | 127.45 | 127.45 | 127.41 | 127.43 | 5900.0 |
| 2011-01-07 07:05:00 | SPY | ETF | 127.42 | 127.42 | 127.42 | 127.42 | 300.0 |
| 2011-01-07 07:10:00 | SPY | ETF | 127.37 | 127.38 | 127.37 | 127.38 | 3450.0 |
| 2011-01-07 07:15:00 | SPY | ETF | 127.41 | 127.41 | 127.35 | 127.35 | 800.0 |
| 2011-01-07 07:20:00 | SPY | ETF | 127.36 | 127.4 | 127.35 | 127.4 | 32100.0 |
| 2011-01-07 07:25:00 | SPY | ETF | 127.41 | 127.43 | 127.41 | 127.43 | 1170.0 |
| 2011-01-07 07:30:00 | SPY | ETF | 127.41 | 127.41 | 127.36 | 127.36 | 4685.0 |
| 2011-01-07 07:35:00 | SPY | ETF | 127.36 | 127.36 | 127.3 | 127.31 | 22100.0 |
| 2011-01-07 07:40:00 | SPY | ETF | 127.32 | 127.36 | 127.32 | 127.33 | 19500.0 |
| 2011-01-07 07:45:00 | SPY | ETF | 127.36 | 127.38 | 127.36 | 127.38 | 1470.0 |
| 2011-01-07 07:50:00 | SPY | ETF | 127.36 | 127.38 | 127.36 | 127.37 | 62051.0 |
| 2011-01-07 07:55:00 | SPY | ETF | 127.4 | 127.4 | 127.35 | 127.35 | 65116.0 |
| 2011-01-07 08:00:00 | SPY | ETF | 127.38 | 127.46 | 127.35 | 127.42 | 73660.0 |
| 2011-01-07 08:05:00 | SPY | ETF | 127.42 | 127.55 | 127.42 | 127.48 | 121926.0 |
| 2011-01-07 08:10:00 | SPY | ETF | 127.48 | 127.48 | 127.43 | 127.48 | 48580.0 |
| 2011-01-07 08:15:00 | SPY | ETF | 127.45 | 127.52 | 127.43 | 127.5 | 34067.0 |
| 2011-01-07 08:20:00 | SPY | ETF | 127.49 | 127.61 | 127.48 | 127.57 | 152027.0 |
| 2011-01-07 08:25:00 | SPY | ETF | 127.58 | 127.65 | 127.47 | 127.59 | 406079.0 |
| 2011-01-07 08:30:00 | SPY | ETF | 127.6 | 127.9 | 126.67 | 127.27 | 5235747.0 |
| 2011-01-07 08:35:00 | SPY | ETF | 127.27 | 127.31 | 127.17 | 127.26 | 2678874.0 |
| 2011-01-07 08:40:00 | SPY | ETF | 127.26 | 127.28 | 127.1 | 127.2 | 902376.0 |
| 2011-01-07 08:45:00 | SPY | ETF | 127.21 | 127.27 | 127.11 | 127.25 | 493240.0 |
| 2011-01-07 08:50:00 | SPY | ETF | 127.24 | 127.29 | 127.18 | 127.19 | 361587.0 |
| 2011-01-07 08:55:00 | SPY | ETF | 127.19 | 127.4 | 127.19 | 127.4 | 1128266.0 |
| 2011-01-07 09:00:00 | SPY | ETF | 127.4 | 127.53 | 127.39 | 127.5 | 528985.0 |
| 2011-01-07 09:05:00 | SPY | ETF | 127.49 | 127.52 | 127.43 | 127.46 | 251650.0 |
| 2011-01-07 09:10:00 | SPY | ETF | 127.46 | 127.62 | 127.46 | 127.54 | 510566.0 |
| 2011-01-07 09:15:00 | SPY | ETF | 127.54 | 127.55 | 127.48 | 127.51 | 143980.0 |
| 2011-01-07 09:20:00 | SPY | ETF | 127.51 | 127.59 | 127.51 | 127.55 | 190236.0 |
| 2011-01-07 09:25:00 | SPY | ETF | 127.55 | 127.56 | 127.5 | 127.56 | 304479.0 |
| 2011-01-07 09:30:00 | SPY | ETF | 127.56 | 127.61 | 127.43 | 127.6 | 2807002.0 |
| 2011-01-07 09:35:00 | SPY | ETF | 127.59 | 127.77 | 127.52 | 127.57 | 3718646.0 |
| 2011-01-07 09:40:00 | SPY | ETF | 127.57 | 127.59 | 127.4 | 127.52 | 2505201.0 |
| 2011-01-07 09:45:00 | SPY | ETF | 127.5162 | 127.52 | 127.27 | 127.28 | 2547349.0 |
| 2011-01-07 09:50:00 | SPY | ETF | 127.28 | 127.29 | 127.16 | 127.235 | 2019629.0 |
| 2011-01-07 09:55:00 | SPY | ETF | 127.22 | 127.39 | 127.2175 | 127.25 | 2016572.0 |
| 2011-01-07 10:00:00 | SPY | ETF | 127.255 | 127.3638 | 127.21 | 127.3199 | 1757766.0 |
| 2011-01-07 10:05:00 | SPY | ETF | 127.3199 | 127.41 | 127.27 | 127.35 | 1983289.0 |
> showing 50 of 36,403 rows — these rows as CSV