PREVIEW / etf_5min / 2015-01-30
file: by_date/etf_5min/2015/2015-01-30.parquet size: 1.2 MB rows: 50,585
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-30 04:00:00 | SPY | ETF | 201.81 | 201.81 | 201.45 | 201.45 | 1080.0 |
| 2015-01-30 04:05:00 | SPY | ETF | 201.3 | 201.3 | 201.13 | 201.15 | 924.0 |
| 2015-01-30 04:10:00 | SPY | ETF | 201.1 | 201.16 | 201.04 | 201.16 | 670.0 |
| 2015-01-30 04:15:00 | SPY | ETF | 201.16 | 201.16 | 200.97 | 200.97 | 11727.0 |
| 2015-01-30 04:20:00 | SPY | ETF | 200.9 | 200.9 | 200.74 | 200.83 | 1520.0 |
| 2015-01-30 04:35:00 | SPY | ETF | 200.92 | 200.92 | 200.76 | 200.79 | 11000.0 |
| 2015-01-30 04:40:00 | SPY | ETF | 200.73 | 200.85 | 200.73 | 200.85 | 30500.0 |
| 2015-01-30 04:45:00 | SPY | ETF | 200.93 | 201.1 | 200.93 | 201.1 | 350.0 |
| 2015-01-30 04:50:00 | SPY | ETF | 201.06 | 201.06 | 201.06 | 201.06 | 200.0 |
| 2015-01-30 04:55:00 | SPY | ETF | 200.8 | 200.8 | 200.8 | 200.8 | 250.0 |
| 2015-01-30 05:00:00 | SPY | ETF | 200.77 | 200.77 | 200.77 | 200.77 | 2000.0 |
| 2015-01-30 05:05:00 | SPY | ETF | 200.91 | 200.91 | 200.75 | 200.75 | 3600.0 |
| 2015-01-30 05:10:00 | SPY | ETF | 200.83 | 200.83 | 200.83 | 200.83 | 100.0 |
| 2015-01-30 05:15:00 | SPY | ETF | 200.98 | 200.98 | 200.98 | 200.98 | 100.0 |
| 2015-01-30 05:20:00 | SPY | ETF | 200.88 | 200.96 | 200.88 | 200.96 | 1135.0 |
| 2015-01-30 05:25:00 | SPY | ETF | 200.8 | 200.8 | 200.75 | 200.75 | 1100.0 |
| 2015-01-30 05:30:00 | SPY | ETF | 200.78 | 200.8 | 200.75 | 200.75 | 82705.0 |
| 2015-01-30 05:35:00 | SPY | ETF | 200.74 | 200.81 | 200.63 | 200.7 | 77688.0 |
| 2015-01-30 05:40:00 | SPY | ETF | 200.68 | 200.68 | 200.68 | 200.68 | 170.0 |
| 2015-01-30 05:45:00 | SPY | ETF | 200.65 | 200.7 | 200.63 | 200.7 | 255299.0 |
| 2015-01-30 05:50:00 | SPY | ETF | 200.61 | 200.78 | 200.58 | 200.78 | 3729.0 |
| 2015-01-30 05:55:00 | SPY | ETF | 200.77 | 200.84 | 200.75 | 200.84 | 1698.0 |
| 2015-01-30 06:00:00 | SPY | ETF | 200.86 | 200.95 | 200.83 | 200.86 | 5976.0 |
| 2015-01-30 06:05:00 | SPY | ETF | 200.86 | 200.86 | 200.84 | 200.84 | 960.0 |
| 2015-01-30 06:10:00 | SPY | ETF | 200.79 | 201.01 | 200.79 | 201.01 | 2660.0 |
| 2015-01-30 06:15:00 | SPY | ETF | 201.04 | 201.12 | 200.98 | 201.05 | 22200.0 |
| 2015-01-30 06:20:00 | SPY | ETF | 201.05 | 201.24 | 201.05 | 201.24 | 14735.0 |
| 2015-01-30 06:25:00 | SPY | ETF | 201.21 | 201.21 | 201.19 | 201.19 | 280.0 |
| 2015-01-30 06:30:00 | SPY | ETF | 201.11 | 201.23 | 201.02 | 201.17 | 5600.0 |
| 2015-01-30 06:35:00 | SPY | ETF | 201.16 | 201.25 | 201.16 | 201.19 | 2750.0 |
| 2015-01-30 06:40:00 | SPY | ETF | 201.19 | 201.39 | 201.07 | 201.07 | 23323.0 |
| 2015-01-30 06:45:00 | SPY | ETF | 201.1 | 201.15 | 201.1 | 201.14 | 21413.0 |
| 2015-01-30 06:50:00 | SPY | ETF | 201.07 | 201.07 | 201.05 | 201.05 | 2429.0 |
| 2015-01-30 06:55:00 | SPY | ETF | 201.1 | 201.14 | 201.09 | 201.14 | 4500.0 |
| 2015-01-30 07:00:00 | SPY | ETF | 201.11 | 201.11 | 200.99 | 201.01 | 17821.0 |
| 2015-01-30 07:05:00 | SPY | ETF | 201.02 | 201.04 | 200.96 | 200.96 | 19286.0 |
| 2015-01-30 07:10:00 | SPY | ETF | 200.95 | 200.97 | 200.78 | 200.96 | 43555.0 |
| 2015-01-30 07:15:00 | SPY | ETF | 200.94 | 200.99 | 200.89 | 200.94 | 30910.0 |
| 2015-01-30 07:20:00 | SPY | ETF | 200.89 | 201.02 | 200.89 | 200.94 | 5015.0 |
| 2015-01-30 07:25:00 | SPY | ETF | 200.9 | 200.96 | 200.86 | 200.96 | 25396.0 |
| 2015-01-30 07:30:00 | SPY | ETF | 200.98 | 201.06 | 200.98 | 201.04 | 48851.0 |
| 2015-01-30 07:35:00 | SPY | ETF | 201.01 | 201.06 | 201.01 | 201.04 | 27299.0 |
| 2015-01-30 07:40:00 | SPY | ETF | 201.0 | 201.0 | 200.9 | 201.0 | 33704.0 |
| 2015-01-30 07:45:00 | SPY | ETF | 201.01 | 201.01 | 200.88 | 200.93 | 45875.0 |
| 2015-01-30 07:50:00 | SPY | ETF | 200.96 | 200.98 | 200.76 | 200.76 | 42953.0 |
| 2015-01-30 07:55:00 | SPY | ETF | 200.77 | 200.83 | 200.71 | 200.76 | 26585.0 |
| 2015-01-30 08:00:00 | SPY | ETF | 200.78 | 201.06 | 200.47 | 200.48 | 115391.0 |
| 2015-01-30 08:05:00 | SPY | ETF | 200.48 | 200.7 | 200.48 | 200.67 | 189787.0 |
| 2015-01-30 08:10:00 | SPY | ETF | 200.65 | 200.72 | 200.6 | 200.72 | 269023.0 |
| 2015-01-30 08:15:00 | SPY | ETF | 200.73 | 200.73 | 200.58 | 200.6 | 142884.0 |
> showing 50 of 50,585 rows — these rows as CSV