PREVIEW / etf_5min / 2011-12-15
file: by_date/etf_5min/2011/2011-12-15.parquet size: 869 KB rows: 37,171
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-12-15 04:00:00 | SPY | ETF | 122.02 | 122.53 | 122.02 | 122.53 | 1448.0 |
| 2011-12-15 04:05:00 | SPY | ETF | 122.12 | 122.12 | 122.12 | 122.12 | 270.0 |
| 2011-12-15 04:10:00 | SPY | ETF | 122.09 | 122.19 | 122.09 | 122.17 | 9420.0 |
| 2011-12-15 04:20:00 | SPY | ETF | 122.17 | 122.17 | 122.17 | 122.17 | 100.0 |
| 2011-12-15 04:25:00 | SPY | ETF | 122.19 | 122.2 | 122.19 | 122.2 | 300.0 |
| 2011-12-15 04:30:00 | SPY | ETF | 122.06 | 122.06 | 122.06 | 122.06 | 100.0 |
| 2011-12-15 04:35:00 | SPY | ETF | 122.0 | 122.0 | 122.0 | 122.0 | 100.0 |
| 2011-12-15 04:45:00 | SPY | ETF | 121.81 | 121.96 | 121.81 | 121.96 | 5259.0 |
| 2011-12-15 04:50:00 | SPY | ETF | 121.96 | 121.96 | 121.96 | 121.96 | 213.0 |
| 2011-12-15 04:55:00 | SPY | ETF | 122.0 | 122.0 | 122.0 | 122.0 | 200.0 |
| 2011-12-15 05:20:00 | SPY | ETF | 122.06 | 122.06 | 122.06 | 122.06 | 100.0 |
| 2011-12-15 05:25:00 | SPY | ETF | 122.08 | 122.14 | 122.08 | 122.14 | 5800.0 |
| 2011-12-15 05:30:00 | SPY | ETF | 122.16 | 122.16 | 122.16 | 122.16 | 1100.0 |
| 2011-12-15 05:35:00 | SPY | ETF | 122.34 | 122.34 | 122.29 | 122.29 | 300.0 |
| 2011-12-15 05:45:00 | SPY | ETF | 122.41 | 122.41 | 122.41 | 122.41 | 4000.0 |
| 2011-12-15 05:50:00 | SPY | ETF | 122.34 | 122.34 | 122.34 | 122.34 | 100.0 |
| 2011-12-15 06:00:00 | SPY | ETF | 122.47 | 122.49 | 122.47 | 122.49 | 650.0 |
| 2011-12-15 06:05:00 | SPY | ETF | 122.44 | 122.44 | 122.44 | 122.44 | 100.0 |
| 2011-12-15 06:10:00 | SPY | ETF | 122.47 | 122.47 | 122.41 | 122.41 | 350.0 |
| 2011-12-15 06:15:00 | SPY | ETF | 122.37 | 122.37 | 122.37 | 122.37 | 600.0 |
| 2011-12-15 06:20:00 | SPY | ETF | 122.36 | 122.43 | 122.36 | 122.43 | 7500.0 |
| 2011-12-15 06:25:00 | SPY | ETF | 122.29 | 122.29 | 122.29 | 122.29 | 100.0 |
| 2011-12-15 06:30:00 | SPY | ETF | 122.34 | 122.34 | 122.3 | 122.34 | 10200.0 |
| 2011-12-15 06:35:00 | SPY | ETF | 122.3 | 122.3 | 122.27 | 122.27 | 29900.0 |
| 2011-12-15 06:40:00 | SPY | ETF | 122.23 | 122.26 | 122.23 | 122.25 | 400.0 |
| 2011-12-15 06:45:00 | SPY | ETF | 122.33 | 122.35 | 122.33 | 122.33 | 9200.0 |
| 2011-12-15 06:50:00 | SPY | ETF | 122.29 | 122.29 | 122.21 | 122.23 | 3600.0 |
| 2011-12-15 06:55:00 | SPY | ETF | 122.31 | 122.31 | 122.23 | 122.23 | 36300.0 |
| 2011-12-15 07:00:00 | SPY | ETF | 122.23 | 122.4 | 122.21 | 122.37 | 51816.0 |
| 2011-12-15 07:05:00 | SPY | ETF | 122.36 | 122.42 | 122.34 | 122.42 | 5450.0 |
| 2011-12-15 07:10:00 | SPY | ETF | 122.43 | 122.55 | 122.35 | 122.55 | 51950.0 |
| 2011-12-15 07:15:00 | SPY | ETF | 122.55 | 122.55 | 122.49 | 122.49 | 39400.0 |
| 2011-12-15 07:20:00 | SPY | ETF | 122.53 | 122.67 | 122.53 | 122.65 | 56157.0 |
| 2011-12-15 07:25:00 | SPY | ETF | 122.58 | 122.65 | 122.56 | 122.59 | 31904.0 |
| 2011-12-15 07:30:00 | SPY | ETF | 122.62 | 122.7 | 122.62 | 122.7 | 27217.0 |
| 2011-12-15 07:35:00 | SPY | ETF | 122.68 | 122.7 | 122.52 | 122.61 | 104150.0 |
| 2011-12-15 07:40:00 | SPY | ETF | 122.55 | 122.55 | 122.45 | 122.46 | 58150.0 |
| 2011-12-15 07:45:00 | SPY | ETF | 122.48 | 122.51 | 122.4 | 122.44 | 144850.0 |
| 2011-12-15 07:50:00 | SPY | ETF | 122.48 | 122.55 | 122.48 | 122.55 | 13000.0 |
| 2011-12-15 07:55:00 | SPY | ETF | 122.55 | 122.66 | 122.55 | 122.62 | 60800.0 |
| 2011-12-15 08:00:00 | SPY | ETF | 122.62 | 122.76 | 122.58 | 122.68 | 184354.0 |
| 2011-12-15 08:05:00 | SPY | ETF | 122.24 | 122.7 | 122.24 | 122.69 | 1283587.0 |
| 2011-12-15 08:10:00 | SPY | ETF | 122.69 | 122.8 | 122.66 | 122.66 | 126814.0 |
| 2011-12-15 08:15:00 | SPY | ETF | 122.67 | 122.76 | 122.62 | 122.76 | 70293.0 |
| 2011-12-15 08:20:00 | SPY | ETF | 122.75 | 122.81 | 122.74 | 122.77 | 84990.0 |
| 2011-12-15 08:25:00 | SPY | ETF | 122.77 | 122.8 | 122.72 | 122.75 | 126823.0 |
| 2011-12-15 08:30:00 | SPY | ETF | 122.78 | 123.2 | 122.73 | 123.16 | 1522205.0 |
| 2011-12-15 08:35:00 | SPY | ETF | 123.15 | 123.19 | 123.11 | 123.17 | 401660.0 |
| 2011-12-15 08:40:00 | SPY | ETF | 123.17 | 123.23 | 123.13 | 123.18 | 329180.0 |
| 2011-12-15 08:45:00 | SPY | ETF | 123.18 | 123.21 | 123.1 | 123.15 | 243031.0 |
> showing 50 of 37,171 rows — these rows as CSV