PREVIEW / etf_5min / 2012-01-25
file: by_date/etf_5min/2012/2012-01-25.parquet size: 970 KB rows: 38,765
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-25 04:00:00 | SPY | ETF | 131.89 | 131.89 | 131.81 | 131.81 | 1213.0 |
| 2012-01-25 04:05:00 | SPY | ETF | 131.8 | 131.8 | 131.78 | 131.78 | 867.0 |
| 2012-01-25 04:10:00 | SPY | ETF | 131.71 | 131.71 | 131.71 | 131.71 | 500.0 |
| 2012-01-25 04:20:00 | SPY | ETF | 131.66 | 131.66 | 131.6 | 131.6 | 3700.0 |
| 2012-01-25 04:25:00 | SPY | ETF | 131.57 | 131.57 | 131.5 | 131.51 | 5575.0 |
| 2012-01-25 04:30:00 | SPY | ETF | 131.55 | 131.55 | 131.51 | 131.51 | 299.0 |
| 2012-01-25 04:35:00 | SPY | ETF | 131.5 | 131.5 | 131.4 | 131.4 | 1779.0 |
| 2012-01-25 04:40:00 | SPY | ETF | 131.39 | 131.39 | 131.36 | 131.36 | 2000.0 |
| 2012-01-25 04:45:00 | SPY | ETF | 131.32 | 131.41 | 131.32 | 131.41 | 600.0 |
| 2012-01-25 04:55:00 | SPY | ETF | 131.39 | 131.39 | 131.36 | 131.37 | 8500.0 |
| 2012-01-25 05:00:00 | SPY | ETF | 131.33 | 131.34 | 131.29 | 131.29 | 3600.0 |
| 2012-01-25 05:10:00 | SPY | ETF | 131.31 | 131.34 | 131.31 | 131.34 | 1000.0 |
| 2012-01-25 05:20:00 | SPY | ETF | 131.34 | 131.34 | 131.34 | 131.34 | 1200.0 |
| 2012-01-25 05:30:00 | SPY | ETF | 131.37 | 131.37 | 131.29 | 131.29 | 600.0 |
| 2012-01-25 05:35:00 | SPY | ETF | 131.27 | 131.34 | 131.21 | 131.34 | 6184.0 |
| 2012-01-25 05:40:00 | SPY | ETF | 131.29 | 131.29 | 131.29 | 131.29 | 500.0 |
| 2012-01-25 05:50:00 | SPY | ETF | 131.22 | 131.22 | 131.16 | 131.16 | 3000.0 |
| 2012-01-25 05:55:00 | SPY | ETF | 131.17 | 131.17 | 131.17 | 131.17 | 100.0 |
| 2012-01-25 06:00:00 | SPY | ETF | 131.09 | 131.09 | 131.09 | 131.09 | 200.0 |
| 2012-01-25 06:05:00 | SPY | ETF | 131.09 | 131.09 | 131.09 | 131.09 | 2600.0 |
| 2012-01-25 06:10:00 | SPY | ETF | 131.16 | 131.16 | 131.16 | 131.16 | 4000.0 |
| 2012-01-25 06:15:00 | SPY | ETF | 131.14 | 131.16 | 131.14 | 131.16 | 1150.0 |
| 2012-01-25 06:20:00 | SPY | ETF | 131.18 | 131.18 | 131.11 | 131.11 | 700.0 |
| 2012-01-25 06:25:00 | SPY | ETF | 131.13 | 131.13 | 131.13 | 131.13 | 135.0 |
| 2012-01-25 06:30:00 | SPY | ETF | 131.18 | 131.18 | 131.14 | 131.16 | 5654.0 |
| 2012-01-25 06:35:00 | SPY | ETF | 131.24 | 131.24 | 131.24 | 131.24 | 250.0 |
| 2012-01-25 06:40:00 | SPY | ETF | 131.16 | 131.16 | 131.12 | 131.12 | 5100.0 |
| 2012-01-25 06:45:00 | SPY | ETF | 131.15 | 131.15 | 131.11 | 131.14 | 15000.0 |
| 2012-01-25 06:50:00 | SPY | ETF | 131.19 | 131.23 | 131.19 | 131.23 | 500.0 |
| 2012-01-25 06:55:00 | SPY | ETF | 131.24 | 131.24 | 131.19 | 131.19 | 14400.0 |
| 2012-01-25 07:00:00 | SPY | ETF | 131.2 | 131.27 | 131.2 | 131.22 | 50943.0 |
| 2012-01-25 07:05:00 | SPY | ETF | 131.21 | 131.23 | 131.16 | 131.23 | 34450.0 |
| 2012-01-25 07:10:00 | SPY | ETF | 131.2 | 131.24 | 131.2 | 131.22 | 13900.0 |
| 2012-01-25 07:15:00 | SPY | ETF | 131.23 | 131.23 | 131.14 | 131.17 | 44500.0 |
| 2012-01-25 07:20:00 | SPY | ETF | 131.14 | 131.15 | 131.1 | 131.13 | 35080.0 |
| 2012-01-25 07:25:00 | SPY | ETF | 131.13 | 131.16 | 131.1 | 131.15 | 17100.0 |
| 2012-01-25 07:30:00 | SPY | ETF | 131.14 | 131.15 | 131.06 | 131.06 | 79762.0 |
| 2012-01-25 07:35:00 | SPY | ETF | 131.08 | 131.1 | 130.99 | 131.02 | 34765.0 |
| 2012-01-25 07:40:00 | SPY | ETF | 131.07 | 131.12 | 131.04 | 131.09 | 5450.0 |
| 2012-01-25 07:45:00 | SPY | ETF | 131.07 | 131.18 | 131.07 | 131.18 | 50688.0 |
| 2012-01-25 07:50:00 | SPY | ETF | 131.18 | 131.25 | 131.18 | 131.21 | 25300.0 |
| 2012-01-25 07:55:00 | SPY | ETF | 131.2 | 131.2 | 131.16 | 131.17 | 10400.0 |
| 2012-01-25 08:00:00 | SPY | ETF | 131.17 | 131.79 | 131.17 | 131.17 | 123843.0 |
| 2012-01-25 08:05:00 | SPY | ETF | 131.18 | 131.18 | 131.13 | 131.15 | 45713.0 |
| 2012-01-25 08:10:00 | SPY | ETF | 131.16 | 131.2 | 131.15 | 131.18 | 52272.0 |
| 2012-01-25 08:15:00 | SPY | ETF | 131.18 | 131.3 | 131.18 | 131.2 | 56098.0 |
| 2012-01-25 08:20:00 | SPY | ETF | 131.19 | 131.29 | 131.18 | 131.24 | 73973.0 |
| 2012-01-25 08:25:00 | SPY | ETF | 131.25 | 131.35 | 131.24 | 131.28 | 66499.0 |
| 2012-01-25 08:30:00 | SPY | ETF | 131.28 | 131.32 | 131.27 | 131.31 | 32135.0 |
| 2012-01-25 08:35:00 | SPY | ETF | 131.3 | 131.33 | 131.26 | 131.32 | 28501.0 |
> showing 50 of 38,765 rows — these rows as CSV