PREVIEW / etf_5min / 2013-10-18
file: by_date/etf_5min/2013/2013-10-18.parquet size: 1016 KB rows: 43,404
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-10-18 04:00:00 | SPY | ETF | 173.47 | 173.47 | 173.47 | 173.47 | 2250.0 |
| 2013-10-18 04:05:00 | SPY | ETF | 173.46 | 173.49 | 173.46 | 173.49 | 8100.0 |
| 2013-10-18 04:10:00 | SPY | ETF | 173.46 | 173.49 | 173.46 | 173.47 | 1793.0 |
| 2013-10-18 04:15:00 | SPY | ETF | 173.49 | 173.57 | 173.49 | 173.57 | 1600.0 |
| 2013-10-18 04:20:00 | SPY | ETF | 173.59 | 173.6 | 173.57 | 173.57 | 501.0 |
| 2013-10-18 04:25:00 | SPY | ETF | 173.57 | 173.57 | 173.49 | 173.49 | 1662.0 |
| 2013-10-18 04:30:00 | SPY | ETF | 173.47 | 173.47 | 173.47 | 173.47 | 200.0 |
| 2013-10-18 04:35:00 | SPY | ETF | 173.47 | 173.51 | 173.47 | 173.51 | 1050.0 |
| 2013-10-18 04:40:00 | SPY | ETF | 173.5 | 173.53 | 173.5 | 173.53 | 800.0 |
| 2013-10-18 04:45:00 | SPY | ETF | 173.5 | 173.5 | 173.49 | 173.49 | 500.0 |
| 2013-10-18 04:55:00 | SPY | ETF | 173.51 | 173.51 | 173.47 | 173.47 | 3950.0 |
| 2013-10-18 05:00:00 | SPY | ETF | 173.49 | 173.49 | 173.47 | 173.47 | 360.0 |
| 2013-10-18 05:05:00 | SPY | ETF | 173.47 | 173.49 | 173.47 | 173.47 | 600.0 |
| 2013-10-18 05:10:00 | SPY | ETF | 173.46 | 173.46 | 173.46 | 173.46 | 700.0 |
| 2013-10-18 05:15:00 | SPY | ETF | 173.45 | 173.53 | 173.45 | 173.53 | 892.0 |
| 2013-10-18 05:20:00 | SPY | ETF | 173.51 | 173.51 | 173.51 | 173.51 | 285.0 |
| 2013-10-18 05:25:00 | SPY | ETF | 173.51 | 173.53 | 173.51 | 173.53 | 4200.0 |
| 2013-10-18 05:30:00 | SPY | ETF | 173.51 | 173.51 | 173.5 | 173.5 | 793.0 |
| 2013-10-18 05:35:00 | SPY | ETF | 173.5 | 173.5 | 173.49 | 173.49 | 1000.0 |
| 2013-10-18 05:45:00 | SPY | ETF | 173.48 | 173.48 | 173.37 | 173.37 | 22804.0 |
| 2013-10-18 05:50:00 | SPY | ETF | 173.37 | 173.46 | 173.37 | 173.46 | 2870.0 |
| 2013-10-18 05:55:00 | SPY | ETF | 173.47 | 173.49 | 173.47 | 173.49 | 600.0 |
| 2013-10-18 06:00:00 | SPY | ETF | 173.49 | 173.49 | 173.49 | 173.49 | 100.0 |
| 2013-10-18 06:05:00 | SPY | ETF | 173.47 | 173.47 | 173.41 | 173.41 | 1400.0 |
| 2013-10-18 06:10:00 | SPY | ETF | 173.41 | 173.41 | 173.39 | 173.39 | 400.0 |
| 2013-10-18 06:15:00 | SPY | ETF | 173.41 | 173.45 | 173.41 | 173.45 | 1000.0 |
| 2013-10-18 06:20:00 | SPY | ETF | 173.42 | 173.45 | 173.41 | 173.45 | 1356.0 |
| 2013-10-18 06:25:00 | SPY | ETF | 173.47 | 173.49 | 173.46 | 173.49 | 1000.0 |
| 2013-10-18 06:30:00 | SPY | ETF | 173.51 | 173.51 | 173.51 | 173.51 | 429.0 |
| 2013-10-18 06:35:00 | SPY | ETF | 173.52 | 173.55 | 173.52 | 173.55 | 10950.0 |
| 2013-10-18 06:40:00 | SPY | ETF | 173.55 | 173.55 | 173.51 | 173.54 | 43300.0 |
| 2013-10-18 06:45:00 | SPY | ETF | 173.51 | 173.51 | 173.45 | 173.45 | 11000.0 |
| 2013-10-18 06:50:00 | SPY | ETF | 173.43 | 173.44 | 173.41 | 173.42 | 27142.0 |
| 2013-10-18 06:55:00 | SPY | ETF | 173.39 | 173.45 | 173.39 | 173.39 | 12800.0 |
| 2013-10-18 07:00:00 | SPY | ETF | 173.41 | 173.47 | 173.39 | 173.44 | 34099.0 |
| 2013-10-18 07:05:00 | SPY | ETF | 173.46 | 173.51 | 173.46 | 173.5 | 12000.0 |
| 2013-10-18 07:10:00 | SPY | ETF | 173.48 | 173.48 | 173.44 | 173.46 | 5150.0 |
| 2013-10-18 07:15:00 | SPY | ETF | 173.44 | 173.49 | 173.43 | 173.49 | 16923.0 |
| 2013-10-18 07:20:00 | SPY | ETF | 173.49 | 173.53 | 173.49 | 173.53 | 8246.0 |
| 2013-10-18 07:25:00 | SPY | ETF | 173.54 | 173.54 | 173.52 | 173.52 | 6100.0 |
| 2013-10-18 07:30:00 | SPY | ETF | 173.52 | 173.54 | 173.5 | 173.52 | 17400.0 |
| 2013-10-18 07:35:00 | SPY | ETF | 173.53 | 173.53 | 173.53 | 173.53 | 5200.0 |
| 2013-10-18 07:40:00 | SPY | ETF | 173.57 | 173.69 | 173.57 | 173.65 | 39299.0 |
| 2013-10-18 07:45:00 | SPY | ETF | 173.63 | 173.67 | 173.56 | 173.66 | 168550.0 |
| 2013-10-18 07:50:00 | SPY | ETF | 173.66 | 173.68 | 173.62 | 173.64 | 8202.0 |
| 2013-10-18 07:55:00 | SPY | ETF | 173.65 | 173.69 | 173.63 | 173.69 | 20500.0 |
| 2013-10-18 08:00:00 | SPY | ETF | 173.44 | 173.77 | 173.44 | 173.74 | 135995.0 |
| 2013-10-18 08:05:00 | SPY | ETF | 173.73 | 173.73 | 173.65 | 173.67 | 37102.0 |
| 2013-10-18 08:10:00 | SPY | ETF | 173.67 | 173.72 | 173.65 | 173.71 | 48215.0 |
| 2013-10-18 08:15:00 | SPY | ETF | 173.72 | 173.85 | 173.72 | 173.83 | 242549.0 |
> showing 50 of 43,404 rows — these rows as CSV