PREVIEW / etf_1min / 2009-03-04
file: by_date/etf_1min/2009/2009-03-04.parquet size: 1.7 MB rows: 96,430
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-03-04 04:15:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 800.0 |
| 2009-03-04 04:17:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 100.0 |
| 2009-03-04 04:18:00 | SPY | ETF | 70.7 | 70.75 | 70.7 | 70.75 | 300.0 |
| 2009-03-04 04:25:00 | SPY | ETF | 70.75 | 70.75 | 70.75 | 70.75 | 3000.0 |
| 2009-03-04 04:28:00 | SPY | ETF | 70.78 | 70.78 | 70.78 | 70.78 | 2064.0 |
| 2009-03-04 04:32:00 | SPY | ETF | 70.73 | 70.73 | 70.73 | 70.73 | 1000.0 |
| 2009-03-04 04:35:00 | SPY | ETF | 70.75 | 70.8 | 70.75 | 70.8 | 312.0 |
| 2009-03-04 04:37:00 | SPY | ETF | 70.81 | 70.81 | 70.8 | 70.8 | 1010.0 |
| 2009-03-04 04:41:00 | SPY | ETF | 70.81 | 70.85 | 70.81 | 70.85 | 1200.0 |
| 2009-03-04 04:42:00 | SPY | ETF | 70.88 | 70.88 | 70.88 | 70.88 | 200.0 |
| 2009-03-04 04:47:00 | SPY | ETF | 70.9 | 70.9 | 70.9 | 70.9 | 100.0 |
| 2009-03-04 04:48:00 | SPY | ETF | 70.91 | 70.91 | 70.91 | 70.91 | 200.0 |
| 2009-03-04 04:49:00 | SPY | ETF | 70.93 | 70.97 | 70.93 | 70.97 | 500.0 |
| 2009-03-04 04:50:00 | SPY | ETF | 70.95 | 70.95 | 70.95 | 70.95 | 500.0 |
| 2009-03-04 04:51:00 | SPY | ETF | 70.99 | 71.0 | 70.99 | 71.0 | 5300.0 |
| 2009-03-04 04:52:00 | SPY | ETF | 70.99 | 70.99 | 70.99 | 70.99 | 100.0 |
| 2009-03-04 04:53:00 | SPY | ETF | 71.0 | 71.03 | 71.0 | 71.03 | 3500.0 |
| 2009-03-04 05:01:00 | SPY | ETF | 70.85 | 70.85 | 70.85 | 70.85 | 1000.0 |
| 2009-03-04 05:16:00 | SPY | ETF | 70.92 | 70.92 | 70.92 | 70.92 | 405.0 |
| 2009-03-04 05:20:00 | SPY | ETF | 70.94 | 70.94 | 70.94 | 70.94 | 181.0 |
| 2009-03-04 05:26:00 | SPY | ETF | 70.78 | 70.78 | 70.78 | 70.78 | 2000.0 |
| 2009-03-04 05:45:00 | SPY | ETF | 70.69 | 70.69 | 70.69 | 70.69 | 100.0 |
| 2009-03-04 05:56:00 | SPY | ETF | 70.78 | 70.78 | 70.78 | 70.78 | 100.0 |
| 2009-03-04 05:58:00 | SPY | ETF | 70.82 | 70.82 | 70.82 | 70.82 | 300.0 |
| 2009-03-04 06:01:00 | SPY | ETF | 70.81 | 70.81 | 70.77 | 70.77 | 1000.0 |
| 2009-03-04 06:04:00 | SPY | ETF | 70.8 | 70.8 | 70.8 | 70.8 | 800.0 |
| 2009-03-04 06:08:00 | SPY | ETF | 70.62 | 70.62 | 70.6 | 70.6 | 5000.0 |
| 2009-03-04 06:09:00 | SPY | ETF | 70.6 | 70.6 | 70.6 | 70.6 | 600.0 |
| 2009-03-04 06:10:00 | SPY | ETF | 70.65 | 70.67 | 70.65 | 70.67 | 200.0 |
| 2009-03-04 06:18:00 | SPY | ETF | 70.73 | 70.73 | 70.73 | 70.73 | 400.0 |
| 2009-03-04 06:19:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 1000.0 |
| 2009-03-04 06:21:00 | SPY | ETF | 70.72 | 70.72 | 70.72 | 70.72 | 1000.0 |
| 2009-03-04 06:28:00 | SPY | ETF | 70.65 | 70.65 | 70.65 | 70.65 | 197.0 |
| 2009-03-04 06:32:00 | SPY | ETF | 70.72 | 70.72 | 70.72 | 70.72 | 361.0 |
| 2009-03-04 06:34:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 2500.0 |
| 2009-03-04 06:39:00 | SPY | ETF | 70.75 | 70.75 | 70.75 | 70.75 | 400.0 |
| 2009-03-04 06:40:00 | SPY | ETF | 70.72 | 70.72 | 70.72 | 70.72 | 675.0 |
| 2009-03-04 06:41:00 | SPY | ETF | 70.72 | 70.72 | 70.72 | 70.72 | 495.0 |
| 2009-03-04 06:42:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 3000.0 |
| 2009-03-04 06:43:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 5000.0 |
| 2009-03-04 06:45:00 | SPY | ETF | 70.67 | 70.67 | 70.67 | 70.67 | 1200.0 |
| 2009-03-04 06:46:00 | SPY | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 100.0 |
| 2009-03-04 06:50:00 | SPY | ETF | 70.74 | 70.77 | 70.74 | 70.77 | 6435.0 |
| 2009-03-04 06:51:00 | SPY | ETF | 70.8 | 70.8 | 70.8 | 70.8 | 370.0 |
| 2009-03-04 06:52:00 | SPY | ETF | 70.82 | 70.82 | 70.75 | 70.75 | 2600.0 |
| 2009-03-04 06:53:00 | SPY | ETF | 70.75 | 70.75 | 70.72 | 70.72 | 10400.0 |
| 2009-03-04 06:54:00 | SPY | ETF | 70.73 | 70.73 | 70.73 | 70.73 | 200.0 |
| 2009-03-04 06:55:00 | SPY | ETF | 70.75 | 70.75 | 70.75 | 70.75 | 469.0 |
| 2009-03-04 06:56:00 | SPY | ETF | 70.75 | 70.75 | 70.75 | 70.75 | 200.0 |
| 2009-03-04 06:57:00 | SPY | ETF | 70.75 | 70.77 | 70.75 | 70.77 | 2200.0 |
> showing 50 of 96,430 rows — these rows as CSV