PREVIEW / etf_5min / 2009-03-05
file: by_date/etf_5min/2009/2009-03-05.parquet size: 703 KB rows: 30,278
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.73 | 1544.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.68 | 70.65 | 70.65 | 1310.0 |
| 2009-03-05 04:30:00 | SPY | ETF | 70.6 | 70.6 | 70.6 | 70.6 | 900.0 |
| 2009-03-05 04:40:00 | SPY | ETF | 70.68 | 70.68 | 70.68 | 70.68 | 350.0 |
| 2009-03-05 04:50:00 | SPY | ETF | 70.82 | 70.82 | 70.82 | 70.82 | 100.0 |
| 2009-03-05 05:10:00 | SPY | ETF | 70.88 | 70.88 | 70.88 | 70.88 | 100.0 |
| 2009-03-05 05:30:00 | SPY | ETF | 70.69 | 70.73 | 70.64 | 70.64 | 6500.0 |
| 2009-03-05 05:35:00 | SPY | ETF | 70.63 | 70.63 | 70.51 | 70.51 | 1813.0 |
| 2009-03-05 05:45:00 | SPY | ETF | 70.6 | 70.68 | 70.6 | 70.68 | 1600.0 |
| 2009-03-05 05:50:00 | SPY | ETF | 70.71 | 70.71 | 70.68 | 70.68 | 700.0 |
| 2009-03-05 05:55:00 | SPY | ETF | 70.61 | 70.62 | 70.49 | 70.49 | 2800.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.24 | 70.24 | 11800.0 |
| 2009-03-05 06:10:00 | SPY | ETF | 70.25 | 70.33 | 70.25 | 70.33 | 9000.0 |
| 2009-03-05 06:15:00 | SPY | ETF | 70.37 | 70.37 | 70.15 | 70.15 | 5500.0 |
| 2009-03-05 06:20:00 | SPY | ETF | 70.29 | 70.29 | 70.0 | 70.0 | 11799.0 |
| 2009-03-05 06:25:00 | SPY | ETF | 70.0 | 70.06 | 69.91 | 70.06 | 8746.0 |
| 2009-03-05 06:30:00 | SPY | ETF | 70.09 | 70.23 | 70.07 | 70.23 | 4200.0 |
| 2009-03-05 06:40:00 | SPY | ETF | 70.14 | 70.21 | 70.13 | 70.21 | 3400.0 |
| 2009-03-05 06:45:00 | SPY | ETF | 70.16 | 70.16 | 70.04 | 70.1 | 10500.0 |
| 2009-03-05 06:50:00 | SPY | ETF | 70.2 | 70.26 | 70.2 | 70.2 | 8700.0 |
| 2009-03-05 06:55:00 | SPY | ETF | 70.21 | 70.27 | 70.16 | 70.27 | 50600.0 |
| 2009-03-05 07:00:00 | SPY | ETF | 70.27 | 70.29 | 70.15 | 70.24 | 263737.0 |
| 2009-03-05 07:05:00 | SPY | ETF | 70.21 | 70.29 | 70.17 | 70.2 | 47293.0 |
| 2009-03-05 07:10:00 | SPY | ETF | 70.19 | 70.26 | 70.15 | 70.22 | 48213.0 |
| 2009-03-05 07:15:00 | SPY | ETF | 70.23 | 70.36 | 70.23 | 70.32 | 35350.0 |
| 2009-03-05 07:20:00 | SPY | ETF | 70.29 | 70.32 | 70.0 | 70.07 | 220946.0 |
| 2009-03-05 07:25:00 | SPY | ETF | 70.02 | 70.06 | 69.85 | 69.91 | 131626.0 |
| 2009-03-05 07:30:00 | SPY | ETF | 69.91 | 70.07 | 69.88 | 70.07 | 230506.0 |
| 2009-03-05 07:35:00 | SPY | ETF | 70.06 | 70.19 | 70.03 | 70.19 | 224082.0 |
| 2009-03-05 07:40:00 | SPY | ETF | 70.19 | 70.22 | 70.11 | 70.18 | 213293.0 |
| 2009-03-05 07:45:00 | SPY | ETF | 70.18 | 70.26 | 70.1 | 70.11 | 194019.0 |
| 2009-03-05 07:50:00 | SPY | ETF | 70.15 | 70.23 | 70.15 | 70.21 | 10769.0 |
| 2009-03-05 07:55:00 | SPY | ETF | 70.21 | 70.24 | 70.1 | 70.1 | 159030.0 |
| 2009-03-05 08:00:00 | SPY | ETF | 70.1 | 70.8 | 70.02 | 70.19 | 1116194.0 |
| 2009-03-05 08:05:00 | SPY | ETF | 70.19 | 70.25 | 69.87 | 70.21 | 550316.0 |
| 2009-03-05 08:10:00 | SPY | ETF | 70.21 | 70.36 | 70.2 | 70.24 | 214714.0 |
| 2009-03-05 08:15:00 | SPY | ETF | 70.25 | 70.27 | 70.12 | 70.27 | 597787.0 |
| 2009-03-05 08:20:00 | SPY | ETF | 70.28 | 70.31 | 70.18 | 70.23 | 576852.0 |
| 2009-03-05 08:25:00 | SPY | ETF | 70.24 | 70.24 | 70.09 | 70.09 | 544756.0 |
| 2009-03-05 08:30:00 | SPY | ETF | 70.1 | 70.37 | 70.06 | 70.14 | 1552162.0 |
| 2009-03-05 08:35:00 | SPY | ETF | 70.16 | 70.17 | 69.85 | 69.94 | 1178106.0 |
| 2009-03-05 08:40:00 | SPY | ETF | 69.94 | 69.96 | 69.7 | 69.83 | 1401354.0 |
| 2009-03-05 08:45:00 | SPY | ETF | 69.83 | 69.87 | 69.76 | 69.81 | 215204.0 |
| 2009-03-05 08:50:00 | SPY | ETF | 69.83 | 69.83 | 69.7 | 69.71 | 430421.0 |
| 2009-03-05 08:55:00 | SPY | ETF | 69.71 | 69.87 | 69.68 | 69.79 | 400079.0 |
| 2009-03-05 09:00:00 | SPY | ETF | 69.77 | 69.91 | 69.76 | 69.87 | 326662.0 |
| 2009-03-05 09:05:00 | SPY | ETF | 69.87 | 70.05 | 69.85 | 70.02 | 232261.0 |
| 2009-03-05 09:10:00 | SPY | ETF | 70.02 | 70.05 | 69.91 | 69.97 | 313152.0 |
> showing 50 of 30,278 rows — these rows as CSV