PREVIEW / etf_1min / 2009-03-05
file: by_date/etf_1min/2009/2009-03-05.parquet size: 1.8 MB rows: 97,693
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-05 04:15:00 | SPY | ETF | 70.73 | 70.73 | 70.69 | 70.69 | 1400.0 |
| 2009-03-05 04:16:00 | SPY | ETF | 70.73 | 70.73 | 70.73 | 70.73 | 144.0 |
| 2009-03-05 04:20:00 | SPY | ETF | 70.72 | 70.72 | 70.72 | 70.72 | 720.0 |
| 2009-03-05 04:25:00 | SPY | ETF | 70.67 | 70.67 | 70.67 | 70.67 | 180.0 |
| 2009-03-05 04:26:00 | SPY | ETF | 70.67 | 70.67 | 70.67 | 70.67 | 930.0 |
| 2009-03-05 04:28:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 100.0 |
| 2009-03-05 04:29:00 | SPY | ETF | 70.65 | 70.65 | 70.65 | 70.65 | 100.0 |
| 2009-03-05 04:34:00 | SPY | ETF | 70.6 | 70.6 | 70.6 | 70.6 | 900.0 |
| 2009-03-05 04:41:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 350.0 |
| 2009-03-05 04:53:00 | SPY | ETF | 70.82 | 70.82 | 70.82 | 70.82 | 100.0 |
| 2009-03-05 05:13:00 | SPY | ETF | 70.88 | 70.88 | 70.88 | 70.88 | 100.0 |
| 2009-03-05 05:30:00 | SPY | ETF | 70.69 | 70.69 | 70.69 | 70.69 | 5000.0 |
| 2009-03-05 05:32:00 | SPY | ETF | 70.73 | 70.73 | 70.73 | 70.73 | 100.0 |
| 2009-03-05 05:33:00 | SPY | ETF | 70.71 | 70.71 | 70.71 | 70.71 | 400.0 |
| 2009-03-05 05:34:00 | SPY | ETF | 70.64 | 70.64 | 70.64 | 70.64 | 1000.0 |
| 2009-03-05 05:35:00 | SPY | ETF | 70.63 | 70.63 | 70.63 | 70.63 | 100.0 |
| 2009-03-05 05:38:00 | SPY | ETF | 70.63 | 70.63 | 70.51 | 70.51 | 1713.0 |
| 2009-03-05 05:46:00 | SPY | ETF | 70.6 | 70.6 | 70.6 | 70.6 | 100.0 |
| 2009-03-05 05:49:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 1500.0 |
| 2009-03-05 05:51:00 | SPY | ETF | 70.71 | 70.71 | 70.71 | 70.71 | 200.0 |
| 2009-03-05 05:54:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 500.0 |
| 2009-03-05 05:56:00 | SPY | ETF | 70.61 | 70.61 | 70.61 | 70.61 | 2000.0 |
| 2009-03-05 05:57:00 | SPY | ETF | 70.62 | 70.62 | 70.53 | 70.53 | 600.0 |
| 2009-03-05 05:58:00 | SPY | ETF | 70.5 | 70.5 | 70.49 | 70.49 | 200.0 |
| 2009-03-05 06:00:00 | SPY | ETF | 70.43 | 70.45 | 70.43 | 70.45 | 200.0 |
| 2009-03-05 06:05:00 | SPY | ETF | 70.48 | 70.5 | 70.48 | 70.5 | 6000.0 |
| 2009-03-05 06:07:00 | SPY | ETF | 70.43 | 70.48 | 70.43 | 70.48 | 200.0 |
| 2009-03-05 06:08:00 | SPY | ETF | 70.4 | 70.4 | 70.38 | 70.38 | 2000.0 |
| 2009-03-05 06:09:00 | SPY | ETF | 70.38 | 70.38 | 70.24 | 70.24 | 3600.0 |
| 2009-03-05 06:10:00 | SPY | ETF | 70.25 | 70.3 | 70.25 | 70.3 | 8000.0 |
| 2009-03-05 06:11:00 | SPY | ETF | 70.33 | 70.33 | 70.33 | 70.33 | 1000.0 |
| 2009-03-05 06:15:00 | SPY | ETF | 70.37 | 70.37 | 70.37 | 70.37 | 5000.0 |
| 2009-03-05 06:16:00 | SPY | ETF | 70.32 | 70.32 | 70.32 | 70.32 | 100.0 |
| 2009-03-05 06:17:00 | SPY | ETF | 70.24 | 70.24 | 70.2 | 70.24 | 300.0 |
| 2009-03-05 06:18:00 | SPY | ETF | 70.15 | 70.15 | 70.15 | 70.15 | 100.0 |
| 2009-03-05 06:21:00 | SPY | ETF | 70.29 | 70.29 | 70.24 | 70.24 | 10200.0 |
| 2009-03-05 06:24:00 | SPY | ETF | 70.11 | 70.11 | 70.0 | 70.0 | 1599.0 |
| 2009-03-05 06:25:00 | SPY | ETF | 70.0 | 70.01 | 70.0 | 70.0 | 5200.0 |
| 2009-03-05 06:26:00 | SPY | ETF | 70.01 | 70.01 | 69.94 | 69.94 | 746.0 |
| 2009-03-05 06:27:00 | SPY | ETF | 69.91 | 69.91 | 69.91 | 69.91 | 300.0 |
| 2009-03-05 06:29:00 | SPY | ETF | 70.06 | 70.06 | 70.06 | 70.06 | 2500.0 |
| 2009-03-05 06:30:00 | SPY | ETF | 70.09 | 70.09 | 70.07 | 70.07 | 3000.0 |
| 2009-03-05 06:33:00 | SPY | ETF | 70.21 | 70.23 | 70.21 | 70.23 | 1200.0 |
| 2009-03-05 06:42:00 | SPY | ETF | 70.14 | 70.14 | 70.13 | 70.13 | 600.0 |
| 2009-03-05 06:44:00 | SPY | ETF | 70.15 | 70.21 | 70.15 | 70.21 | 2800.0 |
| 2009-03-05 06:45:00 | SPY | ETF | 70.16 | 70.16 | 70.16 | 70.16 | 200.0 |
| 2009-03-05 06:46:00 | SPY | ETF | 70.04 | 70.09 | 70.04 | 70.09 | 10100.0 |
| 2009-03-05 06:47:00 | SPY | ETF | 70.16 | 70.16 | 70.16 | 70.16 | 100.0 |
| 2009-03-05 06:48:00 | SPY | ETF | 70.1 | 70.1 | 70.1 | 70.1 | 100.0 |
| 2009-03-05 06:50:00 | SPY | ETF | 70.2 | 70.26 | 70.2 | 70.26 | 1100.0 |
> showing 50 of 97,693 rows — these rows as CSV