PREVIEW / etf_5min / 2013-12-10
file: by_date/etf_5min/2013/2013-12-10.parquet size: 951 KB rows: 40,878
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-10 04:05:00 | SPY | ETF | 181.56 | 181.57 | 181.56 | 181.57 | 900.0 |
| 2013-12-10 04:10:00 | SPY | ETF | 181.54 | 181.54 | 181.51 | 181.51 | 200.0 |
| 2013-12-10 04:15:00 | SPY | ETF | 181.52 | 181.52 | 181.52 | 181.52 | 100.0 |
| 2013-12-10 04:25:00 | SPY | ETF | 181.5 | 181.5 | 181.5 | 181.5 | 250.0 |
| 2013-12-10 04:30:00 | SPY | ETF | 181.54 | 181.54 | 181.54 | 181.54 | 100.0 |
| 2013-12-10 04:35:00 | SPY | ETF | 181.57 | 181.57 | 181.57 | 181.57 | 100.0 |
| 2013-12-10 04:45:00 | SPY | ETF | 181.6 | 181.62 | 181.6 | 181.62 | 600.0 |
| 2013-12-10 04:50:00 | SPY | ETF | 181.6 | 181.6 | 181.6 | 181.6 | 400.0 |
| 2013-12-10 04:55:00 | SPY | ETF | 181.63 | 181.63 | 181.63 | 181.63 | 224.0 |
| 2013-12-10 05:00:00 | SPY | ETF | 181.61 | 181.61 | 181.6 | 181.6 | 200.0 |
| 2013-12-10 05:10:00 | SPY | ETF | 181.62 | 181.62 | 181.62 | 181.62 | 4200.0 |
| 2013-12-10 05:30:00 | SPY | ETF | 181.59 | 181.59 | 181.55 | 181.55 | 1044.0 |
| 2013-12-10 05:40:00 | SPY | ETF | 181.55 | 181.57 | 181.55 | 181.55 | 1533.0 |
| 2013-12-10 05:45:00 | SPY | ETF | 181.55 | 181.6 | 181.55 | 181.6 | 557.0 |
| 2013-12-10 05:55:00 | SPY | ETF | 181.57 | 181.57 | 181.53 | 181.55 | 774.0 |
| 2013-12-10 06:05:00 | SPY | ETF | 181.57 | 181.57 | 181.57 | 181.57 | 300.0 |
| 2013-12-10 06:10:00 | SPY | ETF | 181.57 | 181.57 | 181.57 | 181.57 | 200.0 |
| 2013-12-10 06:15:00 | SPY | ETF | 181.57 | 181.57 | 181.57 | 181.57 | 131.0 |
| 2013-12-10 06:20:00 | SPY | ETF | 181.6 | 181.6 | 181.6 | 181.6 | 141.0 |
| 2013-12-10 06:30:00 | SPY | ETF | 181.63 | 181.63 | 181.63 | 181.63 | 100.0 |
| 2013-12-10 06:50:00 | SPY | ETF | 181.62 | 181.62 | 181.62 | 181.62 | 100.0 |
| 2013-12-10 06:55:00 | SPY | ETF | 181.62 | 181.62 | 181.62 | 181.62 | 100.0 |
| 2013-12-10 07:00:00 | SPY | ETF | 181.62 | 181.62 | 181.59 | 181.61 | 16868.0 |
| 2013-12-10 07:05:00 | SPY | ETF | 181.59 | 181.59 | 181.55 | 181.55 | 3600.0 |
| 2013-12-10 07:10:00 | SPY | ETF | 181.59 | 181.61 | 181.55 | 181.55 | 33650.0 |
| 2013-12-10 07:15:00 | SPY | ETF | 181.54 | 181.54 | 181.44 | 181.44 | 2475.0 |
| 2013-12-10 07:20:00 | SPY | ETF | 181.44 | 181.44 | 181.4 | 181.42 | 1600.0 |
| 2013-12-10 07:25:00 | SPY | ETF | 181.41 | 181.43 | 181.4 | 181.4 | 3700.0 |
| 2013-12-10 07:30:00 | SPY | ETF | 181.41 | 181.42 | 181.41 | 181.41 | 1300.0 |
| 2013-12-10 07:35:00 | SPY | ETF | 181.41 | 181.41 | 181.4 | 181.41 | 29600.0 |
| 2013-12-10 07:40:00 | SPY | ETF | 181.41 | 181.41 | 181.41 | 181.41 | 1045.0 |
| 2013-12-10 07:45:00 | SPY | ETF | 181.41 | 181.42 | 181.39 | 181.41 | 6705.0 |
| 2013-12-10 07:50:00 | SPY | ETF | 181.39 | 181.39 | 181.3 | 181.31 | 44406.0 |
| 2013-12-10 07:55:00 | SPY | ETF | 181.34 | 181.34 | 181.27 | 181.29 | 80257.0 |
| 2013-12-10 08:00:00 | SPY | ETF | 181.3 | 181.34 | 181.18 | 181.24 | 37841.0 |
| 2013-12-10 08:05:00 | SPY | ETF | 181.24 | 181.24 | 181.2 | 181.2 | 31000.0 |
| 2013-12-10 08:10:00 | SPY | ETF | 181.21 | 181.23 | 181.2 | 181.21 | 18178.0 |
| 2013-12-10 08:15:00 | SPY | ETF | 181.19 | 181.21 | 181.17 | 181.17 | 20942.0 |
| 2013-12-10 08:20:00 | SPY | ETF | 181.17 | 181.17 | 181.02 | 181.08 | 127142.0 |
| 2013-12-10 08:25:00 | SPY | ETF | 181.08 | 181.11 | 181.03 | 181.04 | 24850.0 |
| 2013-12-10 08:30:00 | SPY | ETF | 181.04 | 181.04 | 180.935 | 180.94 | 176324.0 |
| 2013-12-10 08:35:00 | SPY | ETF | 180.94 | 181.01 | 180.93 | 180.99 | 79085.0 |
| 2013-12-10 08:40:00 | SPY | ETF | 180.99 | 181.01 | 180.98 | 181.0 | 27544.0 |
| 2013-12-10 08:45:00 | SPY | ETF | 181.01 | 181.01 | 180.97 | 180.98 | 29079.0 |
| 2013-12-10 08:50:00 | SPY | ETF | 181.0 | 181.0 | 180.89 | 180.91 | 52991.0 |
| 2013-12-10 08:55:00 | SPY | ETF | 180.91 | 180.92 | 180.8 | 180.88 | 196702.0 |
| 2013-12-10 09:00:00 | SPY | ETF | 180.87 | 180.89 | 180.82 | 180.87 | 191636.0 |
| 2013-12-10 09:05:00 | SPY | ETF | 180.86 | 180.88 | 180.82 | 180.87 | 51019.0 |
| 2013-12-10 09:10:00 | SPY | ETF | 180.87 | 180.96 | 180.87 | 180.94 | 67182.0 |
| 2013-12-10 09:15:00 | SPY | ETF | 180.93 | 180.97 | 180.93 | 180.95 | 25412.0 |
> showing 50 of 40,878 rows — these rows as CSV