PREVIEW / etf_5min / 2009-04-08
file: by_date/etf_5min/2009/2009-04-08.parquet size: 651 KB rows: 27,974
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-04-08 04:15:00 | SPY | ETF | 80.95 | 80.95 | 80.92 | 80.95 | 3124.0 |
| 2009-04-08 04:20:00 | SPY | ETF | 80.95 | 80.95 | 80.92 | 80.92 | 700.0 |
| 2009-04-08 04:25:00 | SPY | ETF | 80.95 | 80.95 | 80.95 | 80.95 | 1330.0 |
| 2009-04-08 04:35:00 | SPY | ETF | 81.05 | 81.05 | 81.05 | 81.05 | 100.0 |
| 2009-04-08 04:45:00 | SPY | ETF | 81.15 | 81.15 | 81.15 | 81.15 | 500.0 |
| 2009-04-08 05:10:00 | SPY | ETF | 81.17 | 81.17 | 81.17 | 81.17 | 200.0 |
| 2009-04-08 05:15:00 | SPY | ETF | 81.2 | 81.22 | 81.2 | 81.22 | 2100.0 |
| 2009-04-08 05:20:00 | SPY | ETF | 81.2 | 81.2 | 81.2 | 81.2 | 100.0 |
| 2009-04-08 05:30:00 | SPY | ETF | 81.23 | 81.29 | 81.23 | 81.26 | 2500.0 |
| 2009-04-08 05:35:00 | SPY | ETF | 81.32 | 81.32 | 81.29 | 81.29 | 10170.0 |
| 2009-04-08 05:45:00 | SPY | ETF | 81.22 | 81.22 | 81.14 | 81.18 | 600.0 |
| 2009-04-08 05:50:00 | SPY | ETF | 81.11 | 81.11 | 81.09 | 81.09 | 300.0 |
| 2009-04-08 05:55:00 | SPY | ETF | 81.0 | 81.0 | 80.88 | 80.88 | 200.0 |
| 2009-04-08 06:00:00 | SPY | ETF | 80.84 | 80.84 | 80.8 | 80.8 | 397.0 |
| 2009-04-08 06:05:00 | SPY | ETF | 80.95 | 81.02 | 80.94 | 81.02 | 15150.0 |
| 2009-04-08 06:10:00 | SPY | ETF | 80.94 | 80.95 | 80.88 | 80.95 | 700.0 |
| 2009-04-08 06:15:00 | SPY | ETF | 80.96 | 81.03 | 80.95 | 81.03 | 2400.0 |
| 2009-04-08 06:20:00 | SPY | ETF | 81.04 | 81.04 | 81.04 | 81.04 | 500.0 |
| 2009-04-08 06:35:00 | SPY | ETF | 81.21 | 81.33 | 81.21 | 81.26 | 6000.0 |
| 2009-04-08 06:40:00 | SPY | ETF | 81.26 | 81.4 | 81.26 | 81.4 | 2100.0 |
| 2009-04-08 06:45:00 | SPY | ETF | 81.4 | 81.4 | 81.34 | 81.35 | 21900.0 |
| 2009-04-08 06:50:00 | SPY | ETF | 81.37 | 81.49 | 81.32 | 81.49 | 19300.0 |
| 2009-04-08 06:55:00 | SPY | ETF | 81.49 | 81.49 | 81.4 | 81.4 | 8600.0 |
| 2009-04-08 07:00:00 | SPY | ETF | 81.35 | 81.43 | 81.35 | 81.42 | 39600.0 |
| 2009-04-08 07:05:00 | SPY | ETF | 81.43 | 81.47 | 81.42 | 81.45 | 26600.0 |
| 2009-04-08 07:10:00 | SPY | ETF | 81.46 | 81.61 | 81.46 | 81.49 | 59921.0 |
| 2009-04-08 07:15:00 | SPY | ETF | 81.51 | 81.51 | 81.45 | 81.51 | 13650.0 |
| 2009-04-08 07:20:00 | SPY | ETF | 81.51 | 81.59 | 81.51 | 81.54 | 59400.0 |
| 2009-04-08 07:25:00 | SPY | ETF | 81.53 | 81.57 | 81.51 | 81.51 | 155809.0 |
| 2009-04-08 07:30:00 | SPY | ETF | 81.51 | 81.51 | 81.45 | 81.49 | 31608.0 |
| 2009-04-08 07:35:00 | SPY | ETF | 81.47 | 81.47 | 81.34 | 81.37 | 162606.0 |
| 2009-04-08 07:40:00 | SPY | ETF | 81.37 | 81.42 | 81.37 | 81.42 | 67600.0 |
| 2009-04-08 07:45:00 | SPY | ETF | 81.42 | 81.43 | 81.4 | 81.42 | 23550.0 |
| 2009-04-08 07:50:00 | SPY | ETF | 81.43 | 81.44 | 81.36 | 81.39 | 101600.0 |
| 2009-04-08 07:55:00 | SPY | ETF | 81.38 | 81.38 | 81.28 | 81.31 | 130736.0 |
| 2009-04-08 08:00:00 | SPY | ETF | 81.3 | 81.59 | 81.3 | 81.41 | 707918.0 |
| 2009-04-08 08:05:00 | SPY | ETF | 81.4 | 81.54 | 81.39 | 81.52 | 182485.0 |
| 2009-04-08 08:10:00 | SPY | ETF | 81.52 | 81.74 | 81.52 | 81.74 | 465388.0 |
| 2009-04-08 08:15:00 | SPY | ETF | 81.71 | 81.88 | 81.68 | 81.86 | 455940.0 |
| 2009-04-08 08:20:00 | SPY | ETF | 81.85 | 82.03 | 81.85 | 81.93 | 571217.0 |
| 2009-04-08 08:25:00 | SPY | ETF | 81.93 | 82.1 | 81.88 | 82.04 | 372906.0 |
| 2009-04-08 08:30:00 | SPY | ETF | 82.02 | 82.08 | 81.26 | 82.03 | 146397.0 |
| 2009-04-08 08:35:00 | SPY | ETF | 82.03 | 82.04 | 81.93 | 81.94 | 199031.0 |
| 2009-04-08 08:40:00 | SPY | ETF | 81.94 | 82.08 | 81.94 | 82.03 | 163371.0 |
| 2009-04-08 08:45:00 | SPY | ETF | 82.02 | 82.09 | 81.97 | 82.09 | 92794.0 |
| 2009-04-08 08:50:00 | SPY | ETF | 82.09 | 82.26 | 82.07 | 82.17 | 445136.0 |
| 2009-04-08 08:55:00 | SPY | ETF | 82.17 | 82.18 | 82.11 | 82.13 | 405840.0 |
| 2009-04-08 09:00:00 | SPY | ETF | 82.13 | 82.16 | 82.09 | 82.12 | 191934.0 |
| 2009-04-08 09:05:00 | SPY | ETF | 82.12 | 82.14 | 82.08 | 82.12 | 107760.0 |
| 2009-04-08 09:10:00 | SPY | ETF | 82.12 | 82.12 | 82.06 | 82.09 | 112777.0 |
> showing 50 of 27,974 rows — these rows as CSV