PREVIEW / etf_5min / 2022-05-03
file: by_date/etf_5min/2022/2022-05-03.parquet size: 2.0 MB rows: 96,274
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-03 04:00:00 | SPY | ETF | 415.64 | 416.36 | 415.64 | 416.32 | 24745.0 |
| 2022-05-03 04:05:00 | SPY | ETF | 416.3 | 416.64 | 416.25 | 416.475 | 11197.0 |
| 2022-05-03 04:10:00 | SPY | ETF | 416.32 | 416.33 | 415.96 | 415.96 | 5300.0 |
| 2022-05-03 04:15:00 | SPY | ETF | 415.91 | 415.91 | 415.51 | 415.51 | 2377.0 |
| 2022-05-03 04:25:00 | SPY | ETF | 415.39 | 415.39 | 415.39 | 415.39 | 300.0 |
| 2022-05-03 04:30:00 | SPY | ETF | 415.22 | 415.25 | 415.0 | 415.0 | 3223.0 |
| 2022-05-03 04:35:00 | SPY | ETF | 415.08 | 415.1 | 415.0 | 415.1 | 10400.0 |
| 2022-05-03 04:40:00 | SPY | ETF | 415.02 | 415.1 | 414.76 | 414.95 | 1901.0 |
| 2022-05-03 04:45:00 | SPY | ETF | 414.73 | 414.97 | 414.73 | 414.97 | 2000.0 |
| 2022-05-03 04:55:00 | SPY | ETF | 414.84 | 415.0 | 414.84 | 414.86 | 1601.0 |
| 2022-05-03 05:05:00 | SPY | ETF | 414.48 | 414.48 | 414.27 | 414.28 | 1754.0 |
| 2022-05-03 05:10:00 | SPY | ETF | 414.6 | 414.66 | 414.44 | 414.44 | 3800.0 |
| 2022-05-03 05:15:00 | SPY | ETF | 414.82 | 414.82 | 414.8 | 414.8 | 4500.0 |
| 2022-05-03 05:20:00 | SPY | ETF | 414.72 | 414.72 | 414.6 | 414.6 | 5500.0 |
| 2022-05-03 05:25:00 | SPY | ETF | 414.61 | 414.72 | 414.21 | 414.39 | 3900.0 |
| 2022-05-03 05:35:00 | SPY | ETF | 414.49 | 414.49 | 414.49 | 414.49 | 100.0 |
| 2022-05-03 05:40:00 | SPY | ETF | 414.69 | 414.79 | 414.65 | 414.65 | 2356.0 |
| 2022-05-03 05:45:00 | SPY | ETF | 414.89 | 415.0 | 414.89 | 414.92 | 600.0 |
| 2022-05-03 05:50:00 | SPY | ETF | 414.86 | 414.87 | 414.66 | 414.77 | 13896.0 |
| 2022-05-03 05:55:00 | SPY | ETF | 414.94 | 414.95 | 414.62 | 414.7 | 10500.0 |
| 2022-05-03 06:00:00 | SPY | ETF | 414.78 | 414.78 | 414.73 | 414.73 | 300.0 |
| 2022-05-03 06:05:00 | SPY | ETF | 414.89 | 414.89 | 414.62 | 414.65 | 3800.0 |
| 2022-05-03 06:10:00 | SPY | ETF | 414.62 | 414.76 | 414.4 | 414.76 | 6500.0 |
| 2022-05-03 06:15:00 | SPY | ETF | 414.75 | 414.75 | 414.48 | 414.48 | 5402.0 |
| 2022-05-03 06:20:00 | SPY | ETF | 414.34 | 414.34 | 413.96 | 414.05 | 3823.0 |
| 2022-05-03 06:25:00 | SPY | ETF | 413.96 | 413.96 | 413.34 | 413.48 | 21440.0 |
| 2022-05-03 06:30:00 | SPY | ETF | 413.46 | 413.46 | 412.98 | 413.23 | 10243.0 |
| 2022-05-03 06:35:00 | SPY | ETF | 413.27 | 413.43 | 413.23 | 413.3 | 849.0 |
| 2022-05-03 06:40:00 | SPY | ETF | 413.11 | 413.11 | 412.67 | 412.67 | 7189.0 |
| 2022-05-03 06:45:00 | SPY | ETF | 412.61 | 412.64 | 412.42 | 412.64 | 4600.0 |
| 2022-05-03 06:50:00 | SPY | ETF | 412.53 | 412.76 | 412.42 | 412.72 | 5875.0 |
| 2022-05-03 06:55:00 | SPY | ETF | 412.83 | 412.92 | 412.77 | 412.84 | 7800.0 |
| 2022-05-03 07:00:00 | SPY | ETF | 412.84 | 412.94 | 412.65 | 412.8 | 42994.0 |
| 2022-05-03 07:05:00 | SPY | ETF | 412.82 | 412.9 | 412.6 | 412.73 | 33252.0 |
| 2022-05-03 07:10:00 | SPY | ETF | 412.73 | 412.85 | 412.59 | 412.78 | 2907.0 |
| 2022-05-03 07:15:00 | SPY | ETF | 412.84 | 412.88 | 412.66 | 412.66 | 12104.0 |
| 2022-05-03 07:20:00 | SPY | ETF | 412.69 | 412.9 | 412.5 | 412.9 | 6591.0 |
| 2022-05-03 07:25:00 | SPY | ETF | 412.89 | 413.4 | 412.78 | 413.32 | 14040.0 |
| 2022-05-03 07:30:00 | SPY | ETF | 413.35 | 413.65 | 413.17 | 413.21 | 26253.0 |
| 2022-05-03 07:35:00 | SPY | ETF | 413.3 | 413.34 | 413.15 | 413.19 | 21798.0 |
| 2022-05-03 07:40:00 | SPY | ETF | 413.17 | 413.59 | 413.17 | 413.36 | 20327.0 |
| 2022-05-03 07:45:00 | SPY | ETF | 413.34 | 413.64 | 413.29 | 413.58 | 32986.0 |
| 2022-05-03 07:50:00 | SPY | ETF | 413.67 | 413.85 | 413.58 | 413.83 | 19495.0 |
| 2022-05-03 07:55:00 | SPY | ETF | 413.84 | 414.08 | 413.79 | 413.89 | 51375.0 |
| 2022-05-03 08:00:00 | SPY | ETF | 412.8701 | 416.37 | 412.55 | 414.23 | 113759.0 |
| 2022-05-03 08:05:00 | SPY | ETF | 414.33 | 414.5 | 414.1 | 414.41 | 74718.0 |
| 2022-05-03 08:10:00 | SPY | ETF | 414.29 | 414.55 | 414.23 | 414.45 | 18375.0 |
| 2022-05-03 08:15:00 | SPY | ETF | 414.53 | 414.81 | 414.53 | 414.71 | 19764.0 |
| 2022-05-03 08:20:00 | SPY | ETF | 414.74 | 414.81 | 414.35 | 414.39 | 12634.0 |
| 2022-05-03 08:25:00 | SPY | ETF | 414.37 | 414.66 | 414.37 | 414.63 | 21409.0 |
> showing 50 of 96,274 rows — these rows as CSV