PREVIEW / etf_5min / 2008-03-28
file: by_date/etf_5min/2008/2008-03-28.parquet size: 428 KB rows: 20,054
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-28 04:05:00 | SPY | ETF | 133.3 | 133.3 | 133.3 | 133.3 | 1000.0 |
| 2008-03-28 04:15:00 | SPY | ETF | 133.3 | 133.3 | 133.3 | 133.3 | 200.0 |
| 2008-03-28 04:25:00 | SPY | ETF | 133.22 | 133.22 | 133.21 | 133.21 | 6200.0 |
| 2008-03-28 04:55:00 | SPY | ETF | 133.47 | 133.47 | 133.47 | 133.47 | 2500.0 |
| 2008-03-28 05:00:00 | SPY | ETF | 133.49 | 133.6 | 133.49 | 133.6 | 800.0 |
| 2008-03-28 05:25:00 | SPY | ETF | 133.7 | 133.7 | 133.7 | 133.7 | 1000.0 |
| 2008-03-28 05:40:00 | SPY | ETF | 133.7 | 133.7 | 133.7 | 133.7 | 600.0 |
| 2008-03-28 05:45:00 | SPY | ETF | 133.7 | 133.7 | 133.7 | 133.7 | 100.0 |
| 2008-03-28 06:10:00 | SPY | ETF | 133.54 | 133.54 | 133.54 | 133.54 | 100.0 |
| 2008-03-28 06:30:00 | SPY | ETF | 133.4 | 133.4 | 133.4 | 133.4 | 10000.0 |
| 2008-03-28 06:35:00 | SPY | ETF | 133.4 | 133.45 | 133.4 | 133.45 | 12000.0 |
| 2008-03-28 06:40:00 | SPY | ETF | 133.4 | 133.4 | 133.4 | 133.4 | 300.0 |
| 2008-03-28 06:45:00 | SPY | ETF | 133.36 | 133.36 | 133.36 | 133.36 | 700.0 |
| 2008-03-28 06:50:00 | SPY | ETF | 133.4 | 133.4 | 133.4 | 133.4 | 10000.0 |
| 2008-03-28 06:55:00 | SPY | ETF | 133.4 | 133.4 | 133.4 | 133.4 | 5000.0 |
| 2008-03-28 07:00:00 | SPY | ETF | 133.4 | 133.43 | 133.37 | 133.37 | 52200.0 |
| 2008-03-28 07:05:00 | SPY | ETF | 133.37 | 133.43 | 133.37 | 133.4 | 57800.0 |
| 2008-03-28 07:10:00 | SPY | ETF | 133.4 | 133.42 | 133.4 | 133.4 | 4200.0 |
| 2008-03-28 07:15:00 | SPY | ETF | 133.4 | 133.5 | 133.4 | 133.5 | 36200.0 |
| 2008-03-28 07:20:00 | SPY | ETF | 133.47 | 133.48 | 133.42 | 133.45 | 106200.0 |
| 2008-03-28 07:25:00 | SPY | ETF | 133.45 | 133.48 | 133.42 | 133.42 | 11500.0 |
| 2008-03-28 07:30:00 | SPY | ETF | 133.42 | 133.44 | 133.38 | 133.41 | 92100.0 |
| 2008-03-28 07:35:00 | SPY | ETF | 133.4 | 133.4 | 133.31 | 133.31 | 126400.0 |
| 2008-03-28 07:40:00 | SPY | ETF | 133.36 | 133.42 | 133.36 | 133.4 | 144200.0 |
| 2008-03-28 07:45:00 | SPY | ETF | 133.4 | 133.42 | 133.35 | 133.35 | 140500.0 |
| 2008-03-28 07:50:00 | SPY | ETF | 133.35 | 133.35 | 133.32 | 133.32 | 10700.0 |
| 2008-03-28 07:55:00 | SPY | ETF | 133.3 | 133.33 | 133.24 | 133.24 | 16400.0 |
| 2008-03-28 08:00:00 | SPY | ETF | 133.27 | 133.68 | 133.2 | 133.23 | 178400.0 |
| 2008-03-28 08:05:00 | SPY | ETF | 133.24 | 133.35 | 133.23 | 133.34 | 125300.0 |
| 2008-03-28 08:10:00 | SPY | ETF | 133.33 | 133.39 | 133.28 | 133.31 | 150200.0 |
| 2008-03-28 08:15:00 | SPY | ETF | 133.32 | 133.39 | 133.32 | 133.36 | 123000.0 |
| 2008-03-28 08:20:00 | SPY | ETF | 133.34 | 133.37 | 133.25 | 133.34 | 171900.0 |
| 2008-03-28 08:25:00 | SPY | ETF | 133.34 | 133.39 | 133.29 | 133.37 | 164000.0 |
| 2008-03-28 08:30:00 | SPY | ETF | 133.37 | 133.61 | 133.19 | 133.24 | 1573000.0 |
| 2008-03-28 08:35:00 | SPY | ETF | 133.26 | 133.37 | 133.1 | 133.16 | 265500.0 |
| 2008-03-28 08:40:00 | SPY | ETF | 133.15 | 133.26 | 133.15 | 133.17 | 417800.0 |
| 2008-03-28 08:45:00 | SPY | ETF | 133.15 | 133.16 | 132.95 | 132.95 | 451900.0 |
| 2008-03-28 08:50:00 | SPY | ETF | 132.95 | 132.98 | 132.84 | 132.97 | 616800.0 |
| 2008-03-28 08:55:00 | SPY | ETF | 132.97 | 133.14 | 132.95 | 133.05 | 214000.0 |
| 2008-03-28 09:00:00 | SPY | ETF | 133.06 | 133.09 | 132.97 | 133.01 | 254900.0 |
| 2008-03-28 09:05:00 | SPY | ETF | 133.03 | 133.13 | 133.02 | 133.11 | 65800.0 |
| 2008-03-28 09:10:00 | SPY | ETF | 133.11 | 133.2 | 133.09 | 133.19 | 390100.0 |
| 2008-03-28 09:15:00 | SPY | ETF | 133.18 | 133.22 | 133.15 | 133.15 | 426800.0 |
| 2008-03-28 09:20:00 | SPY | ETF | 133.17 | 133.17 | 133.1 | 133.1 | 67300.0 |
| 2008-03-28 09:25:00 | SPY | ETF | 133.14 | 133.15 | 132.95 | 132.99 | 337100.0 |
| 2008-03-28 09:30:00 | SPY | ETF | 132.99 | 133.15 | 132.82 | 132.98 | 5346588.0 |
| 2008-03-28 09:35:00 | SPY | ETF | 132.98 | 133.0 | 132.78 | 132.9 | 3339255.0 |
| 2008-03-28 09:40:00 | SPY | ETF | 132.9 | 133.02 | 132.75 | 132.86 | 3836951.0 |
| 2008-03-28 09:45:00 | SPY | ETF | 132.86 | 132.86 | 132.59 | 132.71 | 2756063.0 |
| 2008-03-28 09:50:00 | SPY | ETF | 132.71 | 133.07 | 132.7 | 132.92 | 3157587.0 |
> showing 50 of 20,054 rows — these rows as CSV