PREVIEW / etf_5min / 2009-05-08
file: by_date/etf_5min/2009/2009-05-08.parquet size: 753 KB rows: 31,498
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-05-08 04:30:00 | SPY | ETF | 91.83 | 91.83 | 91.83 | 91.83 | 680.0 |
| 2009-05-08 04:35:00 | SPY | ETF | 91.92 | 91.92 | 91.91 | 91.91 | 870.0 |
| 2009-05-08 04:55:00 | SPY | ETF | 91.95 | 91.95 | 91.95 | 91.95 | 200.0 |
| 2009-05-08 05:00:00 | SPY | ETF | 91.94 | 91.94 | 91.94 | 91.94 | 5300.0 |
| 2009-05-08 05:05:00 | SPY | ETF | 91.99 | 91.99 | 91.99 | 91.99 | 200.0 |
| 2009-05-08 05:10:00 | SPY | ETF | 92.03 | 92.03 | 92.03 | 92.03 | 1000.0 |
| 2009-05-08 05:20:00 | SPY | ETF | 92.01 | 92.01 | 92.01 | 92.01 | 2000.0 |
| 2009-05-08 05:25:00 | SPY | ETF | 92.05 | 92.11 | 92.05 | 92.11 | 2655.0 |
| 2009-05-08 05:30:00 | SPY | ETF | 92.16 | 92.16 | 92.07 | 92.07 | 800.0 |
| 2009-05-08 05:35:00 | SPY | ETF | 92.12 | 92.16 | 92.12 | 92.16 | 800.0 |
| 2009-05-08 05:40:00 | SPY | ETF | 92.13 | 92.13 | 92.09 | 92.09 | 6000.0 |
| 2009-05-08 05:45:00 | SPY | ETF | 92.15 | 92.15 | 92.15 | 92.15 | 2500.0 |
| 2009-05-08 05:50:00 | SPY | ETF | 92.15 | 92.15 | 92.09 | 92.09 | 5200.0 |
| 2009-05-08 06:05:00 | SPY | ETF | 92.05 | 92.05 | 92.0 | 92.01 | 11600.0 |
| 2009-05-08 06:10:00 | SPY | ETF | 92.11 | 92.11 | 92.11 | 92.11 | 100.0 |
| 2009-05-08 06:15:00 | SPY | ETF | 92.12 | 92.15 | 92.12 | 92.15 | 1000.0 |
| 2009-05-08 06:20:00 | SPY | ETF | 92.15 | 92.15 | 92.12 | 92.12 | 6712.0 |
| 2009-05-08 06:25:00 | SPY | ETF | 92.16 | 92.22 | 92.16 | 92.22 | 6600.0 |
| 2009-05-08 06:30:00 | SPY | ETF | 92.1 | 92.2 | 92.1 | 92.18 | 8400.0 |
| 2009-05-08 06:35:00 | SPY | ETF | 92.17 | 92.18 | 92.17 | 92.17 | 1487.0 |
| 2009-05-08 06:40:00 | SPY | ETF | 92.22 | 92.33 | 92.22 | 92.32 | 10950.0 |
| 2009-05-08 06:45:00 | SPY | ETF | 92.34 | 92.34 | 92.34 | 92.34 | 100.0 |
| 2009-05-08 06:50:00 | SPY | ETF | 92.26 | 92.26 | 92.2 | 92.2 | 800.0 |
| 2009-05-08 06:55:00 | SPY | ETF | 92.2 | 92.24 | 92.2 | 92.24 | 8000.0 |
| 2009-05-08 07:00:00 | SPY | ETF | 92.27 | 92.32 | 92.26 | 92.3 | 113045.0 |
| 2009-05-08 07:05:00 | SPY | ETF | 92.28 | 92.28 | 92.24 | 92.25 | 66400.0 |
| 2009-05-08 07:10:00 | SPY | ETF | 92.24 | 92.36 | 92.2 | 92.36 | 58982.0 |
| 2009-05-08 07:15:00 | SPY | ETF | 92.36 | 92.4 | 92.3 | 92.4 | 40236.0 |
| 2009-05-08 07:20:00 | SPY | ETF | 92.42 | 92.42 | 92.33 | 92.35 | 59775.0 |
| 2009-05-08 07:25:00 | SPY | ETF | 92.38 | 92.48 | 92.35 | 92.47 | 30421.0 |
| 2009-05-08 07:30:00 | SPY | ETF | 92.5 | 92.6 | 92.46 | 92.51 | 236568.0 |
| 2009-05-08 07:35:00 | SPY | ETF | 92.51 | 92.51 | 92.38 | 92.41 | 179826.0 |
| 2009-05-08 07:40:00 | SPY | ETF | 92.43 | 92.45 | 92.33 | 92.33 | 81547.0 |
| 2009-05-08 07:45:00 | SPY | ETF | 92.35 | 92.41 | 92.35 | 92.41 | 33451.0 |
| 2009-05-08 07:50:00 | SPY | ETF | 92.41 | 92.45 | 92.38 | 92.43 | 61569.0 |
| 2009-05-08 07:55:00 | SPY | ETF | 92.47 | 92.5 | 92.38 | 92.38 | 128578.0 |
| 2009-05-08 08:00:00 | SPY | ETF | 92.38 | 92.43 | 91.9 | 92.36 | 389269.0 |
| 2009-05-08 08:05:00 | SPY | ETF | 92.36 | 92.39 | 92.34 | 92.37 | 106474.0 |
| 2009-05-08 08:10:00 | SPY | ETF | 92.37 | 92.43 | 92.23 | 92.42 | 461313.0 |
| 2009-05-08 08:15:00 | SPY | ETF | 92.42 | 92.42 | 92.36 | 92.36 | 377957.0 |
| 2009-05-08 08:20:00 | SPY | ETF | 92.36 | 92.44 | 92.35 | 92.38 | 697542.0 |
| 2009-05-08 08:25:00 | SPY | ETF | 92.38 | 92.57 | 92.35 | 92.41 | 1037716.0 |
| 2009-05-08 08:30:00 | SPY | ETF | 92.43 | 92.75 | 92.0 | 92.21 | 3990325.0 |
| 2009-05-08 08:35:00 | SPY | ETF | 92.21 | 92.42 | 90.9 | 92.0 | 1036415.0 |
| 2009-05-08 08:40:00 | SPY | ETF | 92.0 | 92.39 | 91.84 | 91.96 | 855747.0 |
| 2009-05-08 08:45:00 | SPY | ETF | 91.96 | 92.38 | 91.9 | 92.17 | 804062.0 |
| 2009-05-08 08:50:00 | SPY | ETF | 92.17 | 92.31 | 92.12 | 92.22 | 319176.0 |
| 2009-05-08 08:55:00 | SPY | ETF | 92.23 | 92.23 | 92.09 | 92.16 | 327534.0 |
| 2009-05-08 09:00:00 | SPY | ETF | 92.15 | 92.4 | 92.11 | 92.4 | 447576.0 |
| 2009-05-08 09:05:00 | SPY | ETF | 92.39 | 92.4 | 92.24 | 92.25 | 368774.0 |
> showing 50 of 31,498 rows — these rows as CSV