PREVIEW / etf_5min / 2010-10-14
file: by_date/etf_5min/2010/2010-10-14.parquet size: 845 KB rows: 35,930
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-14 04:00:00 | SPY | ETF | 118.01 | 118.01 | 118.01 | 118.01 | 500.0 |
| 2010-10-14 04:05:00 | SPY | ETF | 118.46 | 118.49 | 118.46 | 118.49 | 400.0 |
| 2010-10-14 04:15:00 | SPY | ETF | 118.39 | 118.39 | 118.39 | 118.39 | 2400.0 |
| 2010-10-14 05:00:00 | SPY | ETF | 118.28 | 118.28 | 118.28 | 118.28 | 300.0 |
| 2010-10-14 05:10:00 | SPY | ETF | 118.3 | 118.3 | 118.27 | 118.27 | 1000.0 |
| 2010-10-14 05:15:00 | SPY | ETF | 118.33 | 118.33 | 118.33 | 118.33 | 3700.0 |
| 2010-10-14 05:25:00 | SPY | ETF | 118.24 | 118.24 | 118.24 | 118.24 | 100.0 |
| 2010-10-14 05:50:00 | SPY | ETF | 118.1 | 118.1 | 118.1 | 118.1 | 2575.0 |
| 2010-10-14 06:00:00 | SPY | ETF | 118.18 | 118.18 | 118.07 | 118.07 | 2400.0 |
| 2010-10-14 06:05:00 | SPY | ETF | 118.0 | 118.0 | 118.0 | 118.0 | 100.0 |
| 2010-10-14 06:30:00 | SPY | ETF | 117.97 | 118.02 | 117.97 | 118.02 | 300.0 |
| 2010-10-14 06:35:00 | SPY | ETF | 118.0 | 118.0 | 117.95 | 117.99 | 700.0 |
| 2010-10-14 06:45:00 | SPY | ETF | 118.13 | 118.13 | 118.13 | 118.13 | 300.0 |
| 2010-10-14 06:50:00 | SPY | ETF | 118.19 | 118.19 | 118.14 | 118.15 | 95300.0 |
| 2010-10-14 06:55:00 | SPY | ETF | 118.15 | 118.18 | 118.13 | 118.13 | 18100.0 |
| 2010-10-14 07:00:00 | SPY | ETF | 118.14 | 118.16 | 118.13 | 118.13 | 29800.0 |
| 2010-10-14 07:05:00 | SPY | ETF | 118.06 | 118.06 | 118.04 | 118.04 | 1900.0 |
| 2010-10-14 07:10:00 | SPY | ETF | 118.02 | 118.04 | 118.01 | 118.01 | 8600.0 |
| 2010-10-14 07:15:00 | SPY | ETF | 118.04 | 118.06 | 118.04 | 118.05 | 8000.0 |
| 2010-10-14 07:20:00 | SPY | ETF | 118.06 | 118.11 | 118.03 | 118.11 | 27200.0 |
| 2010-10-14 07:25:00 | SPY | ETF | 118.11 | 118.11 | 118.09 | 118.11 | 118985.0 |
| 2010-10-14 07:30:00 | SPY | ETF | 118.15 | 118.2 | 118.13 | 118.13 | 17500.0 |
| 2010-10-14 07:35:00 | SPY | ETF | 118.14 | 118.18 | 118.13 | 118.16 | 13500.0 |
| 2010-10-14 07:40:00 | SPY | ETF | 118.19 | 118.21 | 118.16 | 118.18 | 17598.0 |
| 2010-10-14 07:45:00 | SPY | ETF | 118.18 | 118.2 | 118.18 | 118.19 | 4100.0 |
| 2010-10-14 07:50:00 | SPY | ETF | 118.19 | 118.19 | 118.13 | 118.16 | 51500.0 |
| 2010-10-14 07:55:00 | SPY | ETF | 118.13 | 118.19 | 118.08 | 118.09 | 15400.0 |
| 2010-10-14 08:00:00 | SPY | ETF | 118.08 | 118.22 | 118.03 | 118.03 | 89585.0 |
| 2010-10-14 08:05:00 | SPY | ETF | 118.06 | 118.19 | 118.05 | 118.1 | 44460.0 |
| 2010-10-14 08:10:00 | SPY | ETF | 118.09 | 118.14 | 118.04 | 118.12 | 179944.0 |
| 2010-10-14 08:15:00 | SPY | ETF | 118.13 | 118.24 | 118.13 | 118.22 | 256937.0 |
| 2010-10-14 08:20:00 | SPY | ETF | 118.23 | 118.28 | 118.22 | 118.25 | 151068.0 |
| 2010-10-14 08:25:00 | SPY | ETF | 118.25 | 118.34 | 118.21 | 118.33 | 359915.0 |
| 2010-10-14 08:30:00 | SPY | ETF | 118.29 | 118.29 | 117.93 | 118.04 | 1060686.0 |
| 2010-10-14 08:35:00 | SPY | ETF | 118.03 | 118.21 | 118.02 | 118.1 | 433631.0 |
| 2010-10-14 08:40:00 | SPY | ETF | 118.11 | 118.18 | 118.02 | 118.08 | 88669.0 |
| 2010-10-14 08:45:00 | SPY | ETF | 118.08 | 118.09 | 118.0 | 118.03 | 166300.0 |
| 2010-10-14 08:50:00 | SPY | ETF | 118.03 | 118.1 | 118.01 | 118.01 | 60800.0 |
| 2010-10-14 08:55:00 | SPY | ETF | 118.01 | 118.01 | 117.95 | 117.97 | 339073.0 |
| 2010-10-14 09:00:00 | SPY | ETF | 117.96 | 117.97 | 117.81 | 117.83 | 507043.0 |
| 2010-10-14 09:05:00 | SPY | ETF | 117.83 | 117.85 | 117.63 | 117.7 | 625541.0 |
| 2010-10-14 09:10:00 | SPY | ETF | 117.7 | 117.78 | 117.69 | 117.76 | 280103.0 |
| 2010-10-14 09:15:00 | SPY | ETF | 117.76 | 117.79 | 117.68 | 117.68 | 238972.0 |
| 2010-10-14 09:20:00 | SPY | ETF | 117.69 | 117.77 | 117.68 | 117.72 | 329456.0 |
| 2010-10-14 09:25:00 | SPY | ETF | 117.71 | 117.81 | 117.66 | 117.81 | 265152.0 |
| 2010-10-14 09:30:00 | SPY | ETF | 117.8099 | 117.84 | 117.68 | 117.68 | 5533806.0 |
| 2010-10-14 09:35:00 | SPY | ETF | 117.68 | 117.74 | 117.46 | 117.6438 | 6012611.0 |
| 2010-10-14 09:40:00 | SPY | ETF | 117.64 | 117.89 | 117.595 | 117.88 | 6075863.0 |
| 2010-10-14 09:45:00 | SPY | ETF | 117.8799 | 117.98 | 117.75 | 117.7625 | 4277870.0 |
| 2010-10-14 09:50:00 | SPY | ETF | 117.7618 | 117.85 | 117.68 | 117.8 | 2306609.0 |
> showing 50 of 35,930 rows — these rows as CSV