PREVIEW / etf_5min / 2013-01-10
file: by_date/etf_5min/2013/2013-01-10.parquet size: 940 KB rows: 40,630
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-01-10 04:05:00 | SPY | ETF | 146.19 | 146.19 | 146.19 | 146.19 | 19980.0 |
| 2013-01-10 04:15:00 | SPY | ETF | 146.27 | 146.34 | 146.27 | 146.34 | 2510.0 |
| 2013-01-10 04:35:00 | SPY | ETF | 146.32 | 146.32 | 146.28 | 146.28 | 10000.0 |
| 2013-01-10 04:40:00 | SPY | ETF | 146.35 | 146.35 | 146.35 | 146.35 | 300.0 |
| 2013-01-10 04:45:00 | SPY | ETF | 146.36 | 146.36 | 146.36 | 146.36 | 100.0 |
| 2013-01-10 04:55:00 | SPY | ETF | 146.42 | 146.42 | 146.41 | 146.41 | 400.0 |
| 2013-01-10 05:00:00 | SPY | ETF | 146.45 | 146.45 | 146.45 | 146.45 | 500.0 |
| 2013-01-10 05:05:00 | SPY | ETF | 146.45 | 146.45 | 146.45 | 146.45 | 3000.0 |
| 2013-01-10 05:20:00 | SPY | ETF | 146.35 | 146.37 | 146.35 | 146.37 | 5100.0 |
| 2013-01-10 05:55:00 | SPY | ETF | 146.38 | 146.38 | 146.38 | 146.38 | 10000.0 |
| 2013-01-10 06:00:00 | SPY | ETF | 146.35 | 146.35 | 146.35 | 146.35 | 100.0 |
| 2013-01-10 06:10:00 | SPY | ETF | 146.34 | 146.34 | 146.31 | 146.32 | 1200.0 |
| 2013-01-10 06:15:00 | SPY | ETF | 146.32 | 146.33 | 146.32 | 146.33 | 5100.0 |
| 2013-01-10 06:20:00 | SPY | ETF | 146.3 | 146.3 | 146.29 | 146.29 | 15000.0 |
| 2013-01-10 06:25:00 | SPY | ETF | 146.3 | 146.3 | 146.3 | 146.3 | 2100.0 |
| 2013-01-10 06:30:00 | SPY | ETF | 146.32 | 146.35 | 146.32 | 146.35 | 300.0 |
| 2013-01-10 06:35:00 | SPY | ETF | 146.34 | 146.34 | 146.34 | 146.34 | 200.0 |
| 2013-01-10 06:40:00 | SPY | ETF | 146.36 | 146.36 | 146.32 | 146.32 | 300.0 |
| 2013-01-10 06:45:00 | SPY | ETF | 146.36 | 146.36 | 146.33 | 146.33 | 2928.0 |
| 2013-01-10 06:50:00 | SPY | ETF | 146.34 | 146.34 | 146.34 | 146.34 | 5000.0 |
| 2013-01-10 06:55:00 | SPY | ETF | 146.33 | 146.35 | 146.33 | 146.35 | 17460.0 |
| 2013-01-10 07:00:00 | SPY | ETF | 146.33 | 146.33 | 146.31 | 146.32 | 12200.0 |
| 2013-01-10 07:05:00 | SPY | ETF | 146.31 | 146.33 | 146.3 | 146.3 | 5100.0 |
| 2013-01-10 07:10:00 | SPY | ETF | 146.31 | 146.32 | 146.28 | 146.29 | 59053.0 |
| 2013-01-10 07:15:00 | SPY | ETF | 146.3 | 146.32 | 146.3 | 146.32 | 5200.0 |
| 2013-01-10 07:20:00 | SPY | ETF | 146.32 | 146.33 | 146.32 | 146.33 | 900.0 |
| 2013-01-10 07:25:00 | SPY | ETF | 146.33 | 146.33 | 146.31 | 146.31 | 1782.0 |
| 2013-01-10 07:30:00 | SPY | ETF | 146.32 | 146.42 | 146.32 | 146.42 | 110905.0 |
| 2013-01-10 07:35:00 | SPY | ETF | 146.4 | 146.44 | 146.4 | 146.41 | 24455.0 |
| 2013-01-10 07:40:00 | SPY | ETF | 146.41 | 146.41 | 146.41 | 146.41 | 1000.0 |
| 2013-01-10 07:45:00 | SPY | ETF | 146.37 | 146.37 | 146.35 | 146.35 | 3000.0 |
| 2013-01-10 07:50:00 | SPY | ETF | 146.35 | 146.43 | 146.35 | 146.43 | 9255.0 |
| 2013-01-10 07:55:00 | SPY | ETF | 146.4 | 146.48 | 146.4 | 146.48 | 32424.0 |
| 2013-01-10 08:00:00 | SPY | ETF | 146.48 | 146.53 | 146.29 | 146.52 | 50816.0 |
| 2013-01-10 08:05:00 | SPY | ETF | 146.53 | 146.54 | 146.5 | 146.5 | 43975.0 |
| 2013-01-10 08:10:00 | SPY | ETF | 146.5 | 146.5 | 146.47 | 146.5 | 7821.0 |
| 2013-01-10 08:15:00 | SPY | ETF | 146.49 | 146.58 | 146.49 | 146.56 | 250184.0 |
| 2013-01-10 08:20:00 | SPY | ETF | 146.56 | 146.6 | 146.56 | 146.57 | 159762.0 |
| 2013-01-10 08:25:00 | SPY | ETF | 146.59 | 146.6 | 146.54 | 146.59 | 263835.0 |
| 2013-01-10 08:30:00 | SPY | ETF | 146.55 | 146.58 | 146.35 | 146.55 | 117094.0 |
| 2013-01-10 08:35:00 | SPY | ETF | 146.55 | 146.58 | 146.52 | 146.58 | 172257.0 |
| 2013-01-10 08:40:00 | SPY | ETF | 146.58 | 146.75 | 146.55 | 146.71 | 285199.0 |
| 2013-01-10 08:45:00 | SPY | ETF | 146.72 | 146.86 | 146.69 | 146.81 | 308969.0 |
| 2013-01-10 08:50:00 | SPY | ETF | 146.81 | 146.85 | 146.71 | 146.73 | 122500.0 |
| 2013-01-10 08:55:00 | SPY | ETF | 146.72 | 146.74 | 146.69 | 146.72 | 42660.0 |
| 2013-01-10 09:00:00 | SPY | ETF | 146.71 | 146.76 | 146.66 | 146.68 | 141085.0 |
| 2013-01-10 09:05:00 | SPY | ETF | 146.66 | 146.7 | 146.655 | 146.67 | 181675.0 |
| 2013-01-10 09:10:00 | SPY | ETF | 146.68 | 146.72 | 146.68 | 146.69 | 34331.0 |
| 2013-01-10 09:15:00 | SPY | ETF | 146.7 | 146.78 | 146.69 | 146.74 | 140384.0 |
| 2013-01-10 09:20:00 | SPY | ETF | 146.74 | 146.76 | 146.7 | 146.71 | 112100.0 |
> showing 50 of 40,630 rows — these rows as CSV