PREVIEW / etf_1min / 2010-10-01
file: by_date/etf_1min/2010/2010-10-01.parquet size: 1.8 MB rows: 101,579
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-01 04:00:00 | SPY | ETF | 114.52 | 114.61 | 114.52 | 114.61 | 200.0 |
| 2010-10-01 04:01:00 | SPY | ETF | 114.56 | 114.56 | 114.56 | 114.56 | 110.0 |
| 2010-10-01 04:03:00 | SPY | ETF | 114.61 | 114.61 | 114.61 | 114.61 | 100.0 |
| 2010-10-01 04:07:00 | SPY | ETF | 114.62 | 114.62 | 114.62 | 114.62 | 1000.0 |
| 2010-10-01 04:26:00 | SPY | ETF | 114.7 | 114.71 | 114.7 | 114.71 | 800.0 |
| 2010-10-01 04:29:00 | SPY | ETF | 114.66 | 114.66 | 114.66 | 114.66 | 300.0 |
| 2010-10-01 04:38:00 | SPY | ETF | 114.68 | 114.68 | 114.68 | 114.68 | 200.0 |
| 2010-10-01 04:48:00 | SPY | ETF | 114.66 | 114.66 | 114.66 | 114.66 | 150.0 |
| 2010-10-01 04:54:00 | SPY | ETF | 114.63 | 114.66 | 114.63 | 114.66 | 474.0 |
| 2010-10-01 05:02:00 | SPY | ETF | 114.7 | 114.7 | 114.7 | 114.7 | 400.0 |
| 2010-10-01 05:04:00 | SPY | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 100.0 |
| 2010-10-01 05:11:00 | SPY | ETF | 114.72 | 114.72 | 114.72 | 114.72 | 100.0 |
| 2010-10-01 05:13:00 | SPY | ETF | 114.75 | 114.76 | 114.75 | 114.76 | 700.0 |
| 2010-10-01 05:17:00 | SPY | ETF | 114.8 | 114.8 | 114.8 | 114.8 | 200.0 |
| 2010-10-01 05:24:00 | SPY | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 100.0 |
| 2010-10-01 05:31:00 | SPY | ETF | 114.77 | 114.77 | 114.77 | 114.77 | 200.0 |
| 2010-10-01 05:57:00 | SPY | ETF | 114.75 | 114.75 | 114.73 | 114.73 | 400.0 |
| 2010-10-01 06:14:00 | SPY | ETF | 114.83 | 114.83 | 114.83 | 114.83 | 100.0 |
| 2010-10-01 06:21:00 | SPY | ETF | 114.8 | 114.8 | 114.8 | 114.8 | 2500.0 |
| 2010-10-01 06:26:00 | SPY | ETF | 114.76 | 114.8 | 114.76 | 114.8 | 1700.0 |
| 2010-10-01 06:30:00 | SPY | ETF | 114.81 | 114.82 | 114.81 | 114.82 | 550.0 |
| 2010-10-01 06:31:00 | SPY | ETF | 114.84 | 114.85 | 114.84 | 114.85 | 200.0 |
| 2010-10-01 06:32:00 | SPY | ETF | 114.85 | 114.85 | 114.84 | 114.84 | 463.0 |
| 2010-10-01 06:34:00 | SPY | ETF | 114.8 | 114.8 | 114.8 | 114.8 | 200.0 |
| 2010-10-01 06:35:00 | SPY | ETF | 114.79 | 114.79 | 114.79 | 114.79 | 200.0 |
| 2010-10-01 06:40:00 | SPY | ETF | 114.77 | 114.77 | 114.77 | 114.77 | 100.0 |
| 2010-10-01 06:42:00 | SPY | ETF | 114.74 | 114.74 | 114.74 | 114.74 | 400.0 |
| 2010-10-01 06:43:00 | SPY | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 300.0 |
| 2010-10-01 06:45:00 | SPY | ETF | 114.73 | 114.73 | 114.73 | 114.73 | 500.0 |
| 2010-10-01 06:46:00 | SPY | ETF | 114.7 | 114.7 | 114.7 | 114.7 | 200.0 |
| 2010-10-01 06:47:00 | SPY | ETF | 114.69 | 114.69 | 114.69 | 114.69 | 500.0 |
| 2010-10-01 06:50:00 | SPY | ETF | 114.69 | 114.71 | 114.69 | 114.71 | 2950.0 |
| 2010-10-01 06:52:00 | SPY | ETF | 114.69 | 114.69 | 114.69 | 114.69 | 100.0 |
| 2010-10-01 06:53:00 | SPY | ETF | 114.69 | 114.69 | 114.69 | 114.69 | 2700.0 |
| 2010-10-01 06:55:00 | SPY | ETF | 114.65 | 114.65 | 114.61 | 114.62 | 11750.0 |
| 2010-10-01 06:56:00 | SPY | ETF | 114.6 | 114.6 | 114.55 | 114.59 | 17850.0 |
| 2010-10-01 06:57:00 | SPY | ETF | 114.6 | 114.6 | 114.6 | 114.6 | 100.0 |
| 2010-10-01 06:58:00 | SPY | ETF | 114.6 | 114.6 | 114.44 | 114.44 | 4400.0 |
| 2010-10-01 06:59:00 | SPY | ETF | 114.44 | 114.47 | 114.44 | 114.44 | 38500.0 |
| 2010-10-01 07:00:00 | SPY | ETF | 114.43 | 114.43 | 114.28 | 114.28 | 3600.0 |
| 2010-10-01 07:01:00 | SPY | ETF | 114.27 | 114.34 | 114.27 | 114.34 | 8100.0 |
| 2010-10-01 07:02:00 | SPY | ETF | 114.39 | 114.49 | 114.39 | 114.49 | 3291.0 |
| 2010-10-01 07:03:00 | SPY | ETF | 114.47 | 114.47 | 114.44 | 114.44 | 3000.0 |
| 2010-10-01 07:04:00 | SPY | ETF | 114.42 | 114.45 | 114.42 | 114.45 | 900.0 |
| 2010-10-01 07:05:00 | SPY | ETF | 114.42 | 114.42 | 114.28 | 114.28 | 29491.0 |
| 2010-10-01 07:06:00 | SPY | ETF | 114.27 | 114.47 | 114.27 | 114.44 | 10800.0 |
| 2010-10-01 07:07:00 | SPY | ETF | 114.44 | 114.49 | 114.44 | 114.46 | 512050.0 |
| 2010-10-01 07:10:00 | SPY | ETF | 114.44 | 114.44 | 114.36 | 114.38 | 2950.0 |
| 2010-10-01 07:11:00 | SPY | ETF | 114.38 | 114.41 | 114.38 | 114.41 | 200.0 |
| 2010-10-01 07:12:00 | SPY | ETF | 114.46 | 114.48 | 114.46 | 114.48 | 5100.0 |
> showing 50 of 101,579 rows — these rows as CSV