PREVIEW / etf_5min / 2007-01-29
file: by_date/etf_5min/2007/2007-01-29.parquet size: 277 KB rows: 13,151
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-29 07:00:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 700.0 |
| 2007-01-29 07:05:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 200.0 |
| 2007-01-29 07:10:00 | SPY | ETF | 142.05 | 142.05 | 142.05 | 142.05 | 9000.0 |
| 2007-01-29 07:15:00 | SPY | ETF | 142.1 | 142.11 | 142.1 | 142.11 | 12000.0 |
| 2007-01-29 07:20:00 | SPY | ETF | 142.13 | 142.13 | 142.13 | 142.13 | 100.0 |
| 2007-01-29 07:25:00 | SPY | ETF | 142.1 | 142.22 | 142.09 | 142.22 | 17300.0 |
| 2007-01-29 07:30:00 | SPY | ETF | 142.21 | 142.22 | 142.21 | 142.22 | 700.0 |
| 2007-01-29 07:35:00 | SPY | ETF | 142.2 | 142.24 | 142.19 | 142.22 | 188900.0 |
| 2007-01-29 07:40:00 | SPY | ETF | 142.18 | 142.18 | 142.17 | 142.17 | 18500.0 |
| 2007-01-29 07:45:00 | SPY | ETF | 142.22 | 142.24 | 142.17 | 142.17 | 22000.0 |
| 2007-01-29 07:50:00 | SPY | ETF | 142.15 | 142.15 | 142.15 | 142.15 | 6000.0 |
| 2007-01-29 08:00:00 | SPY | ETF | 142.17 | 142.25 | 142.1 | 142.1 | 281300.0 |
| 2007-01-29 08:10:00 | SPY | ETF | 142.16 | 142.16 | 142.16 | 142.16 | 11000.0 |
| 2007-01-29 08:15:00 | SPY | ETF | 142.16 | 142.17 | 142.16 | 142.16 | 191400.0 |
| 2007-01-29 08:20:00 | SPY | ETF | 142.14 | 142.15 | 142.12 | 142.14 | 50000.0 |
| 2007-01-29 08:25:00 | SPY | ETF | 142.15 | 142.15 | 142.08 | 142.09 | 202300.0 |
| 2007-01-29 08:30:00 | SPY | ETF | 142.06 | 142.09 | 142.05 | 142.08 | 211600.0 |
| 2007-01-29 08:35:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 5000.0 |
| 2007-01-29 08:40:00 | SPY | ETF | 142.1 | 142.1 | 142.1 | 142.1 | 500.0 |
| 2007-01-29 08:45:00 | SPY | ETF | 142.13 | 142.14 | 142.11 | 142.11 | 3300.0 |
| 2007-01-29 08:50:00 | SPY | ETF | 142.12 | 142.15 | 142.12 | 142.15 | 1400.0 |
| 2007-01-29 08:55:00 | SPY | ETF | 142.15 | 142.15 | 142.12 | 142.13 | 34900.0 |
| 2007-01-29 09:00:00 | SPY | ETF | 142.14 | 142.14 | 142.14 | 142.14 | 12600.0 |
| 2007-01-29 09:05:00 | SPY | ETF | 142.13 | 142.15 | 142.13 | 142.15 | 9800.0 |
| 2007-01-29 09:10:00 | SPY | ETF | 142.16 | 142.16 | 142.12 | 142.12 | 30600.0 |
| 2007-01-29 09:15:00 | SPY | ETF | 142.13 | 142.16 | 142.1 | 142.1 | 14300.0 |
| 2007-01-29 09:20:00 | SPY | ETF | 142.16 | 142.17 | 142.16 | 142.17 | 18900.0 |
| 2007-01-29 09:25:00 | SPY | ETF | 142.16 | 142.16 | 142.13 | 142.16 | 31900.0 |
| 2007-01-29 09:30:00 | SPY | ETF | 142.19 | 142.22 | 142.13 | 142.19 | 864800.0 |
| 2007-01-29 09:35:00 | SPY | ETF | 142.18 | 142.19 | 142.08 | 142.16 | 713700.0 |
| 2007-01-29 09:40:00 | SPY | ETF | 142.16 | 142.42 | 142.15 | 142.38 | 1483200.0 |
| 2007-01-29 09:45:00 | SPY | ETF | 142.38 | 142.49 | 142.29 | 142.46 | 979400.0 |
| 2007-01-29 09:50:00 | SPY | ETF | 142.46 | 142.49 | 142.38 | 142.42 | 952600.0 |
| 2007-01-29 09:55:00 | SPY | ETF | 142.44 | 142.44 | 142.31 | 142.37 | 763300.0 |
| 2007-01-29 10:00:00 | SPY | ETF | 142.37 | 142.48 | 142.37 | 142.4 | 1112400.0 |
| 2007-01-29 10:05:00 | SPY | ETF | 142.4 | 142.55 | 142.4 | 142.52 | 1332100.0 |
| 2007-01-29 10:10:00 | SPY | ETF | 142.52 | 142.52 | 142.42 | 142.43 | 371500.0 |
| 2007-01-29 10:15:00 | SPY | ETF | 142.43 | 142.43 | 142.3 | 142.33 | 753600.0 |
| 2007-01-29 10:20:00 | SPY | ETF | 142.34 | 142.36 | 142.21 | 142.25 | 1114700.0 |
| 2007-01-29 10:25:00 | SPY | ETF | 142.26 | 142.36 | 142.18 | 142.19 | 1253600.0 |
| 2007-01-29 10:30:00 | SPY | ETF | 142.19 | 142.22 | 142.12 | 142.13 | 1238600.0 |
| 2007-01-29 10:35:00 | SPY | ETF | 142.12 | 142.23 | 142.1 | 142.22 | 561700.0 |
| 2007-01-29 10:40:00 | SPY | ETF | 142.21 | 142.34 | 142.21 | 142.27 | 372700.0 |
| 2007-01-29 10:45:00 | SPY | ETF | 142.28 | 142.34 | 142.25 | 142.28 | 1053300.0 |
| 2007-01-29 10:50:00 | SPY | ETF | 142.28 | 142.31 | 142.22 | 142.26 | 1572800.0 |
| 2007-01-29 10:55:00 | SPY | ETF | 142.26 | 142.28 | 142.21 | 142.25 | 424500.0 |
| 2007-01-29 11:00:00 | SPY | ETF | 142.24 | 142.29 | 142.11 | 142.21 | 908300.0 |
| 2007-01-29 11:05:00 | SPY | ETF | 142.2 | 142.37 | 142.17 | 142.35 | 347300.0 |
| 2007-01-29 11:10:00 | SPY | ETF | 142.35 | 142.43 | 142.34 | 142.41 | 559000.0 |
| 2007-01-29 11:15:00 | SPY | ETF | 142.42 | 142.8 | 142.36 | 142.41 | 810600.0 |
> showing 50 of 13,151 rows — these rows as CSV