PREVIEW / etf_1min / 2009-10-13
file: by_date/etf_1min/2009/2009-10-13.parquet size: 1.6 MB rows: 88,226
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-13 04:06:00 | SPY | ETF | 107.44 | 107.44 | 107.43 | 107.43 | 5000.0 |
| 2009-10-13 04:15:00 | SPY | ETF | 107.42 | 107.42 | 107.42 | 107.42 | 800.0 |
| 2009-10-13 04:17:00 | SPY | ETF | 107.42 | 107.42 | 107.42 | 107.42 | 500.0 |
| 2009-10-13 04:58:00 | SPY | ETF | 107.54 | 107.54 | 107.54 | 107.54 | 100.0 |
| 2009-10-13 05:00:00 | SPY | ETF | 107.44 | 107.44 | 107.44 | 107.44 | 2222.0 |
| 2009-10-13 05:05:00 | SPY | ETF | 107.48 | 107.48 | 107.48 | 107.48 | 2000.0 |
| 2009-10-13 05:11:00 | SPY | ETF | 107.41 | 107.41 | 107.41 | 107.41 | 500.0 |
| 2009-10-13 05:17:00 | SPY | ETF | 107.36 | 107.36 | 107.36 | 107.36 | 2222.0 |
| 2009-10-13 05:18:00 | SPY | ETF | 107.3 | 107.3 | 107.3 | 107.3 | 100.0 |
| 2009-10-13 05:25:00 | SPY | ETF | 107.36 | 107.36 | 107.36 | 107.36 | 2000.0 |
| 2009-10-13 05:31:00 | SPY | ETF | 107.34 | 107.34 | 107.34 | 107.34 | 200.0 |
| 2009-10-13 05:45:00 | SPY | ETF | 107.43 | 107.45 | 107.43 | 107.45 | 2500.0 |
| 2009-10-13 05:48:00 | SPY | ETF | 107.45 | 107.45 | 107.45 | 107.45 | 4000.0 |
| 2009-10-13 06:06:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 500.0 |
| 2009-10-13 06:10:00 | SPY | ETF | 107.54 | 107.54 | 107.54 | 107.54 | 500.0 |
| 2009-10-13 06:18:00 | SPY | ETF | 107.56 | 107.56 | 107.56 | 107.56 | 500.0 |
| 2009-10-13 06:42:00 | SPY | ETF | 107.57 | 107.57 | 107.57 | 107.57 | 200.0 |
| 2009-10-13 06:43:00 | SPY | ETF | 107.57 | 107.57 | 107.57 | 107.57 | 100.0 |
| 2009-10-13 06:46:00 | SPY | ETF | 107.62 | 107.62 | 107.61 | 107.61 | 600.0 |
| 2009-10-13 06:47:00 | SPY | ETF | 107.61 | 107.61 | 107.61 | 107.61 | 20400.0 |
| 2009-10-13 06:48:00 | SPY | ETF | 107.61 | 107.61 | 107.61 | 107.61 | 29000.0 |
| 2009-10-13 06:51:00 | SPY | ETF | 107.6 | 107.6 | 107.6 | 107.6 | 100.0 |
| 2009-10-13 06:55:00 | SPY | ETF | 107.61 | 107.61 | 107.61 | 107.61 | 100.0 |
| 2009-10-13 07:01:00 | SPY | ETF | 107.62 | 107.65 | 107.61 | 107.65 | 10600.0 |
| 2009-10-13 07:02:00 | SPY | ETF | 107.65 | 107.65 | 107.65 | 107.65 | 2686.0 |
| 2009-10-13 07:03:00 | SPY | ETF | 107.65 | 107.65 | 107.62 | 107.62 | 7503.0 |
| 2009-10-13 07:04:00 | SPY | ETF | 107.64 | 107.64 | 107.64 | 107.64 | 2503.0 |
| 2009-10-13 07:05:00 | SPY | ETF | 107.63 | 107.63 | 107.63 | 107.63 | 1900.0 |
| 2009-10-13 07:06:00 | SPY | ETF | 107.64 | 107.69 | 107.64 | 107.69 | 13495.0 |
| 2009-10-13 07:07:00 | SPY | ETF | 107.66 | 107.67 | 107.66 | 107.67 | 7603.0 |
| 2009-10-13 07:08:00 | SPY | ETF | 107.69 | 107.69 | 107.69 | 107.69 | 1500.0 |
| 2009-10-13 07:09:00 | SPY | ETF | 107.68 | 107.68 | 107.68 | 107.68 | 5100.0 |
| 2009-10-13 07:10:00 | SPY | ETF | 107.7 | 107.75 | 107.7 | 107.75 | 21500.0 |
| 2009-10-13 07:11:00 | SPY | ETF | 107.74 | 107.77 | 107.74 | 107.76 | 16200.0 |
| 2009-10-13 07:12:00 | SPY | ETF | 107.78 | 107.78 | 107.78 | 107.78 | 1800.0 |
| 2009-10-13 07:13:00 | SPY | ETF | 107.76 | 107.76 | 107.76 | 107.76 | 10000.0 |
| 2009-10-13 07:14:00 | SPY | ETF | 107.78 | 107.8 | 107.78 | 107.8 | 800.0 |
| 2009-10-13 07:15:00 | SPY | ETF | 107.78 | 107.82 | 107.78 | 107.82 | 32600.0 |
| 2009-10-13 07:16:00 | SPY | ETF | 107.78 | 107.82 | 107.78 | 107.81 | 9066.0 |
| 2009-10-13 07:17:00 | SPY | ETF | 107.84 | 107.84 | 107.81 | 107.81 | 11000.0 |
| 2009-10-13 07:19:00 | SPY | ETF | 107.81 | 107.81 | 107.78 | 107.78 | 7500.0 |
| 2009-10-13 07:20:00 | SPY | ETF | 107.79 | 107.79 | 107.76 | 107.76 | 6000.0 |
| 2009-10-13 07:22:00 | SPY | ETF | 107.77 | 107.77 | 107.77 | 107.77 | 5000.0 |
| 2009-10-13 07:23:00 | SPY | ETF | 107.75 | 107.75 | 107.75 | 107.75 | 1000.0 |
| 2009-10-13 07:24:00 | SPY | ETF | 107.76 | 107.79 | 107.76 | 107.79 | 2605.0 |
| 2009-10-13 07:26:00 | SPY | ETF | 107.76 | 107.76 | 107.76 | 107.76 | 400.0 |
| 2009-10-13 07:27:00 | SPY | ETF | 107.79 | 107.79 | 107.76 | 107.76 | 10200.0 |
| 2009-10-13 07:28:00 | SPY | ETF | 107.8 | 107.8 | 107.8 | 107.8 | 7000.0 |
| 2009-10-13 07:29:00 | SPY | ETF | 107.8 | 107.8 | 107.76 | 107.76 | 600.0 |
| 2009-10-13 07:30:00 | SPY | ETF | 107.77 | 107.77 | 107.75 | 107.77 | 10300.0 |
> showing 50 of 88,226 rows — these rows as CSV