PREVIEW / etf_5min / 2018-11-26
file: by_date/etf_5min/2018/2018-11-26.parquet size: 1.4 MB rows: 61,265
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-26 04:00:00 | SPY | ETF | 266.35 | 266.45 | 266.21 | 266.42 | 13316.0 |
| 2018-11-26 04:05:00 | SPY | ETF | 266.42 | 266.47 | 266.24 | 266.27 | 9672.0 |
| 2018-11-26 04:10:00 | SPY | ETF | 266.3 | 266.39 | 266.29 | 266.29 | 3794.0 |
| 2018-11-26 04:15:00 | SPY | ETF | 266.45 | 266.5 | 266.43 | 266.43 | 1970.0 |
| 2018-11-26 04:20:00 | SPY | ETF | 266.39 | 266.62 | 266.39 | 266.62 | 12510.0 |
| 2018-11-26 04:25:00 | SPY | ETF | 266.5 | 266.5 | 266.42 | 266.42 | 260.0 |
| 2018-11-26 04:30:00 | SPY | ETF | 266.47 | 266.47 | 266.47 | 266.47 | 300.0 |
| 2018-11-26 04:35:00 | SPY | ETF | 266.41 | 266.41 | 266.41 | 266.41 | 190.0 |
| 2018-11-26 04:45:00 | SPY | ETF | 266.42 | 266.65 | 266.42 | 266.6 | 7005.0 |
| 2018-11-26 04:50:00 | SPY | ETF | 266.55 | 266.55 | 266.55 | 266.55 | 280.0 |
| 2018-11-26 04:55:00 | SPY | ETF | 266.54 | 266.54 | 266.4 | 266.4 | 300.0 |
| 2018-11-26 05:00:00 | SPY | ETF | 266.38 | 266.46 | 266.36 | 266.38 | 1420.0 |
| 2018-11-26 05:05:00 | SPY | ETF | 266.31 | 266.31 | 266.28 | 266.28 | 748.0 |
| 2018-11-26 05:10:00 | SPY | ETF | 266.28 | 266.33 | 266.28 | 266.33 | 300.0 |
| 2018-11-26 05:15:00 | SPY | ETF | 266.21 | 266.21 | 266.21 | 266.21 | 700.0 |
| 2018-11-26 05:20:00 | SPY | ETF | 266.14 | 266.2 | 266.14 | 266.19 | 1615.0 |
| 2018-11-26 05:25:00 | SPY | ETF | 266.12 | 266.2 | 266.1 | 266.1 | 19700.0 |
| 2018-11-26 05:30:00 | SPY | ETF | 266.03 | 266.18 | 266.02 | 266.05 | 10644.0 |
| 2018-11-26 05:35:00 | SPY | ETF | 266.1 | 266.1 | 266.03 | 266.05 | 2912.0 |
| 2018-11-26 05:40:00 | SPY | ETF | 266.1 | 266.15 | 266.1 | 266.15 | 5520.0 |
| 2018-11-26 05:45:00 | SPY | ETF | 266.03 | 266.17 | 266.03 | 266.17 | 904.0 |
| 2018-11-26 05:50:00 | SPY | ETF | 266.07 | 266.2 | 266.04 | 266.08 | 7295.0 |
| 2018-11-26 05:55:00 | SPY | ETF | 266.18 | 266.19 | 266.18 | 266.19 | 300.0 |
| 2018-11-26 06:00:00 | SPY | ETF | 266.19 | 266.19 | 266.13 | 266.19 | 5100.0 |
| 2018-11-26 06:05:00 | SPY | ETF | 266.25 | 266.37 | 266.0 | 266.0 | 5350.0 |
| 2018-11-26 06:10:00 | SPY | ETF | 266.02 | 266.13 | 266.0 | 266.02 | 9332.0 |
| 2018-11-26 06:15:00 | SPY | ETF | 266.0 | 266.09 | 265.98 | 266.09 | 8000.0 |
| 2018-11-26 06:20:00 | SPY | ETF | 266.16 | 266.27 | 266.1 | 266.1 | 2769.0 |
| 2018-11-26 06:25:00 | SPY | ETF | 266.12 | 266.2 | 266.12 | 266.12 | 1328.0 |
| 2018-11-26 06:30:00 | SPY | ETF | 266.11 | 266.2 | 266.1 | 266.12 | 10515.0 |
| 2018-11-26 06:35:00 | SPY | ETF | 266.12 | 266.12 | 266.01 | 266.01 | 2969.0 |
| 2018-11-26 06:40:00 | SPY | ETF | 266.11 | 266.16 | 266.06 | 266.16 | 2300.0 |
| 2018-11-26 06:45:00 | SPY | ETF | 266.14 | 266.16 | 266.08 | 266.16 | 3400.0 |
| 2018-11-26 06:50:00 | SPY | ETF | 266.1 | 266.19 | 266.1 | 266.19 | 14500.0 |
| 2018-11-26 06:55:00 | SPY | ETF | 266.17 | 266.17 | 266.06 | 266.06 | 3425.0 |
| 2018-11-26 07:00:00 | SPY | ETF | 266.06 | 266.22 | 266.05 | 266.09 | 43893.0 |
| 2018-11-26 07:05:00 | SPY | ETF | 266.09 | 266.12 | 265.86 | 265.91 | 24104.0 |
| 2018-11-26 07:10:00 | SPY | ETF | 265.91 | 266.08 | 265.9 | 266.08 | 67145.0 |
| 2018-11-26 07:15:00 | SPY | ETF | 266.12 | 266.12 | 265.92 | 266.07 | 8350.0 |
| 2018-11-26 07:20:00 | SPY | ETF | 266.03 | 266.37 | 265.85 | 266.2 | 45526.0 |
| 2018-11-26 07:25:00 | SPY | ETF | 266.1 | 266.21 | 266.0 | 266.0 | 34220.0 |
| 2018-11-26 07:30:00 | SPY | ETF | 266.0 | 266.0 | 265.92 | 265.96 | 57336.0 |
| 2018-11-26 07:35:00 | SPY | ETF | 265.95 | 266.08 | 265.95 | 266.07 | 103646.0 |
| 2018-11-26 07:40:00 | SPY | ETF | 266.03 | 266.16 | 266.02 | 266.05 | 158295.0 |
| 2018-11-26 07:45:00 | SPY | ETF | 266.06 | 266.09 | 265.9 | 266.09 | 125180.0 |
| 2018-11-26 07:50:00 | SPY | ETF | 266.09 | 266.09 | 265.94 | 266.0 | 27268.0 |
| 2018-11-26 07:55:00 | SPY | ETF | 266.0 | 266.01 | 265.85 | 265.85 | 38787.0 |
| 2018-11-26 08:00:00 | SPY | ETF | 265.85 | 266.27 | 264.76 | 266.01 | 55907.0 |
| 2018-11-26 08:05:00 | SPY | ETF | 266.01 | 266.01 | 265.85 | 265.85 | 10227.0 |
| 2018-11-26 08:10:00 | SPY | ETF | 265.86 | 265.93 | 265.85 | 265.87 | 27720.0 |
> showing 50 of 61,265 rows — these rows as CSV