PREVIEW / etf_5min / 2019-03-18
file: by_date/etf_5min/2019/2019-03-18.parquet size: 1.4 MB rows: 62,547
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-18 04:00:00 | SPY | ETF | 281.71 | 281.72 | 281.58 | 281.72 | 2391.0 |
| 2019-03-18 04:05:00 | SPY | ETF | 281.65 | 281.65 | 281.6 | 281.6 | 2000.0 |
| 2019-03-18 04:10:00 | SPY | ETF | 281.66 | 281.66 | 281.66 | 281.66 | 100.0 |
| 2019-03-18 04:25:00 | SPY | ETF | 281.58 | 281.6 | 281.58 | 281.6 | 500.0 |
| 2019-03-18 04:30:00 | SPY | ETF | 281.64 | 281.72 | 281.64 | 281.72 | 3700.0 |
| 2019-03-18 04:35:00 | SPY | ETF | 281.74 | 281.79 | 281.74 | 281.79 | 3000.0 |
| 2019-03-18 04:40:00 | SPY | ETF | 281.78 | 281.81 | 281.74 | 281.74 | 1400.0 |
| 2019-03-18 04:45:00 | SPY | ETF | 281.72 | 281.79 | 281.71 | 281.71 | 2538.0 |
| 2019-03-18 04:50:00 | SPY | ETF | 281.64 | 281.71 | 281.64 | 281.71 | 1283.0 |
| 2019-03-18 04:55:00 | SPY | ETF | 281.68 | 281.72 | 281.68 | 281.72 | 776.0 |
| 2019-03-18 05:00:00 | SPY | ETF | 281.67 | 281.71 | 281.63 | 281.63 | 1145.0 |
| 2019-03-18 05:05:00 | SPY | ETF | 281.65 | 281.69 | 281.65 | 281.69 | 2300.0 |
| 2019-03-18 05:10:00 | SPY | ETF | 281.69 | 281.69 | 281.65 | 281.66 | 869.0 |
| 2019-03-18 05:15:00 | SPY | ETF | 281.58 | 281.6 | 281.49 | 281.49 | 5451.0 |
| 2019-03-18 05:20:00 | SPY | ETF | 281.47 | 281.49 | 281.47 | 281.49 | 1369.0 |
| 2019-03-18 05:25:00 | SPY | ETF | 281.49 | 281.49 | 281.48 | 281.49 | 2600.0 |
| 2019-03-18 05:30:00 | SPY | ETF | 281.46 | 281.49 | 281.46 | 281.49 | 1270.0 |
| 2019-03-18 05:35:00 | SPY | ETF | 281.43 | 281.43 | 281.43 | 281.43 | 500.0 |
| 2019-03-18 05:40:00 | SPY | ETF | 281.48 | 281.54 | 281.48 | 281.54 | 700.0 |
| 2019-03-18 05:45:00 | SPY | ETF | 281.51 | 281.51 | 281.51 | 281.51 | 600.0 |
| 2019-03-18 05:50:00 | SPY | ETF | 281.51 | 281.52 | 281.51 | 281.52 | 1800.0 |
| 2019-03-18 05:55:00 | SPY | ETF | 281.52 | 281.52 | 281.52 | 281.52 | 600.0 |
| 2019-03-18 06:00:00 | SPY | ETF | 281.54 | 281.54 | 281.53 | 281.53 | 600.0 |
| 2019-03-18 06:05:00 | SPY | ETF | 281.56 | 281.6 | 281.5 | 281.54 | 1404.0 |
| 2019-03-18 06:10:00 | SPY | ETF | 281.49 | 281.49 | 281.48 | 281.48 | 1200.0 |
| 2019-03-18 06:15:00 | SPY | ETF | 281.49 | 281.52 | 281.45 | 281.52 | 1000.0 |
| 2019-03-18 06:20:00 | SPY | ETF | 281.43 | 281.47 | 281.43 | 281.47 | 1526.0 |
| 2019-03-18 06:25:00 | SPY | ETF | 281.4 | 281.4 | 281.4 | 281.4 | 205.0 |
| 2019-03-18 06:35:00 | SPY | ETF | 281.5 | 281.5 | 281.5 | 281.5 | 300.0 |
| 2019-03-18 06:40:00 | SPY | ETF | 281.5 | 281.6 | 281.5 | 281.6 | 2638.0 |
| 2019-03-18 06:45:00 | SPY | ETF | 281.59 | 281.62 | 281.59 | 281.62 | 1845.0 |
| 2019-03-18 06:50:00 | SPY | ETF | 281.64 | 281.67 | 281.63 | 281.67 | 2476.0 |
| 2019-03-18 06:55:00 | SPY | ETF | 281.58 | 281.58 | 281.58 | 281.58 | 238.0 |
| 2019-03-18 07:00:00 | SPY | ETF | 281.56 | 281.7 | 281.56 | 281.7 | 5440.0 |
| 2019-03-18 07:05:00 | SPY | ETF | 281.7 | 281.77 | 281.7 | 281.74 | 13930.0 |
| 2019-03-18 07:10:00 | SPY | ETF | 281.8 | 281.82 | 281.75 | 281.8 | 5348.0 |
| 2019-03-18 07:15:00 | SPY | ETF | 281.8 | 281.89 | 281.8 | 281.87 | 6276.0 |
| 2019-03-18 07:20:00 | SPY | ETF | 281.87 | 281.91 | 281.87 | 281.9 | 29540.0 |
| 2019-03-18 07:25:00 | SPY | ETF | 281.88 | 281.88 | 281.81 | 281.81 | 1406.0 |
| 2019-03-18 07:30:00 | SPY | ETF | 281.78 | 281.87 | 281.78 | 281.87 | 8570.0 |
| 2019-03-18 07:35:00 | SPY | ETF | 281.84 | 281.84 | 281.81 | 281.82 | 5600.0 |
| 2019-03-18 07:40:00 | SPY | ETF | 281.85 | 281.98 | 281.85 | 281.87 | 4969.0 |
| 2019-03-18 07:45:00 | SPY | ETF | 281.89 | 281.92 | 281.82 | 281.85 | 3836.0 |
| 2019-03-18 07:50:00 | SPY | ETF | 281.83 | 281.85 | 281.82 | 281.85 | 2600.0 |
| 2019-03-18 07:55:00 | SPY | ETF | 281.84 | 281.9 | 281.84 | 281.9 | 2500.0 |
| 2019-03-18 08:00:00 | SPY | ETF | 281.74 | 281.92 | 281.56 | 281.86 | 28365.0 |
| 2019-03-18 08:05:00 | SPY | ETF | 281.81 | 281.81 | 281.72 | 281.72 | 10539.0 |
| 2019-03-18 08:10:00 | SPY | ETF | 281.74 | 281.8 | 281.7 | 281.73 | 15106.0 |
| 2019-03-18 08:15:00 | SPY | ETF | 281.75 | 281.81 | 281.75 | 281.81 | 8134.0 |
| 2019-03-18 08:20:00 | SPY | ETF | 281.76 | 281.8 | 281.76 | 281.77 | 73892.0 |
> showing 50 of 62,547 rows — these rows as CSV