PREVIEW / etf_5min / 2010-05-20
file: by_date/etf_5min/2010/2010-05-20.parquet size: 1009 KB rows: 41,834
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-05-20 04:15:00 | SPY | ETF | 111.71 | 111.71 | 111.66 | 111.66 | 3000.0 |
| 2010-05-20 04:20:00 | SPY | ETF | 111.7 | 111.7 | 111.7 | 111.7 | 500.0 |
| 2010-05-20 05:05:00 | SPY | ETF | 111.51 | 111.51 | 111.51 | 111.51 | 200.0 |
| 2010-05-20 05:10:00 | SPY | ETF | 111.49 | 111.49 | 111.49 | 111.49 | 1200.0 |
| 2010-05-20 05:50:00 | SPY | ETF | 111.35 | 111.35 | 111.35 | 111.35 | 500.0 |
| 2010-05-20 06:00:00 | SPY | ETF | 111.32 | 111.32 | 111.21 | 111.21 | 1200.0 |
| 2010-05-20 06:05:00 | SPY | ETF | 111.24 | 111.31 | 111.24 | 111.31 | 300.0 |
| 2010-05-20 06:10:00 | SPY | ETF | 111.34 | 111.34 | 111.34 | 111.34 | 5000.0 |
| 2010-05-20 06:25:00 | SPY | ETF | 111.32 | 111.32 | 111.29 | 111.29 | 2000.0 |
| 2010-05-20 06:30:00 | SPY | ETF | 111.25 | 111.25 | 111.07 | 111.07 | 12200.0 |
| 2010-05-20 06:35:00 | SPY | ETF | 111.05 | 111.05 | 110.75 | 110.75 | 54500.0 |
| 2010-05-20 06:40:00 | SPY | ETF | 110.77 | 110.82 | 110.75 | 110.78 | 24650.0 |
| 2010-05-20 06:45:00 | SPY | ETF | 110.8 | 110.89 | 110.8 | 110.89 | 6300.0 |
| 2010-05-20 06:50:00 | SPY | ETF | 110.85 | 110.9 | 110.81 | 110.88 | 23200.0 |
| 2010-05-20 06:55:00 | SPY | ETF | 110.84 | 110.88 | 110.81 | 110.88 | 11100.0 |
| 2010-05-20 07:00:00 | SPY | ETF | 110.87 | 110.98 | 110.85 | 110.89 | 222845.0 |
| 2010-05-20 07:05:00 | SPY | ETF | 110.9 | 110.93 | 110.76 | 110.85 | 218300.0 |
| 2010-05-20 07:10:00 | SPY | ETF | 110.82 | 110.82 | 110.59 | 110.62 | 112534.0 |
| 2010-05-20 07:15:00 | SPY | ETF | 110.62 | 110.7 | 110.55 | 110.67 | 61320.0 |
| 2010-05-20 07:20:00 | SPY | ETF | 110.64 | 110.64 | 110.54 | 110.6 | 205700.0 |
| 2010-05-20 07:25:00 | SPY | ETF | 110.61 | 110.61 | 109.68 | 110.03 | 523630.0 |
| 2010-05-20 07:30:00 | SPY | ETF | 110.04 | 110.04 | 109.42 | 109.83 | 855844.0 |
| 2010-05-20 07:35:00 | SPY | ETF | 109.8 | 110.19 | 109.72 | 109.99 | 845047.0 |
| 2010-05-20 07:40:00 | SPY | ETF | 110.0 | 110.03 | 109.57 | 109.75 | 601728.0 |
| 2010-05-20 07:45:00 | SPY | ETF | 109.75 | 109.9 | 109.62 | 109.68 | 227369.0 |
| 2010-05-20 07:50:00 | SPY | ETF | 109.76 | 109.96 | 109.74 | 109.9 | 408091.0 |
| 2010-05-20 07:55:00 | SPY | ETF | 109.91 | 109.94 | 109.81 | 109.87 | 212711.0 |
| 2010-05-20 08:00:00 | SPY | ETF | 109.86 | 110.05 | 109.69 | 109.925 | 811891.0 |
| 2010-05-20 08:05:00 | SPY | ETF | 110.1 | 110.17 | 109.97 | 110.0 | 294622.0 |
| 2010-05-20 08:10:00 | SPY | ETF | 110.0 | 110.07 | 109.7 | 109.71 | 614094.0 |
| 2010-05-20 08:15:00 | SPY | ETF | 109.72 | 109.86 | 109.6 | 109.82 | 718837.0 |
| 2010-05-20 08:20:00 | SPY | ETF | 109.81 | 109.87 | 109.66 | 109.74 | 575474.0 |
| 2010-05-20 08:25:00 | SPY | ETF | 109.74 | 109.91 | 109.7 | 109.84 | 442421.0 |
| 2010-05-20 08:30:00 | SPY | ETF | 109.78 | 109.85 | 109.02 | 109.14 | 3467035.0 |
| 2010-05-20 08:35:00 | SPY | ETF | 109.15 | 109.44 | 109.09 | 109.34 | 734142.0 |
| 2010-05-20 08:40:00 | SPY | ETF | 109.34 | 109.47 | 109.23 | 109.37 | 648400.0 |
| 2010-05-20 08:45:00 | SPY | ETF | 109.36 | 109.42 | 109.17 | 109.2 | 557725.0 |
| 2010-05-20 08:50:00 | SPY | ETF | 109.19 | 109.56 | 109.18 | 109.54 | 620278.0 |
| 2010-05-20 08:55:00 | SPY | ETF | 109.53 | 112.08 | 109.34 | 109.38 | 616367.0 |
| 2010-05-20 09:00:00 | SPY | ETF | 109.37 | 111.6 | 109.33 | 109.53 | 517543.0 |
| 2010-05-20 09:05:00 | SPY | ETF | 109.53 | 109.65 | 109.37 | 109.62 | 683894.0 |
| 2010-05-20 09:10:00 | SPY | ETF | 109.62 | 109.76 | 109.45 | 109.69 | 752250.0 |
| 2010-05-20 09:15:00 | SPY | ETF | 109.68 | 109.79 | 109.47 | 109.52 | 430449.0 |
| 2010-05-20 09:20:00 | SPY | ETF | 109.51 | 109.65 | 109.45 | 109.53 | 537197.0 |
| 2010-05-20 09:25:00 | SPY | ETF | 109.53 | 109.65 | 109.37 | 109.39 | 988577.0 |
| 2010-05-20 09:30:00 | SPY | ETF | 109.38 | 109.71 | 109.16 | 109.49 | 15054985.0 |
| 2010-05-20 09:35:00 | SPY | ETF | 109.49 | 109.81 | 109.31 | 109.74 | 10457151.0 |
| 2010-05-20 09:40:00 | SPY | ETF | 109.73 | 109.74 | 109.15 | 109.23 | 9317680.0 |
| 2010-05-20 09:45:00 | SPY | ETF | 109.23 | 109.59 | 109.12 | 109.57 | 9973343.0 |
| 2010-05-20 09:50:00 | SPY | ETF | 109.56 | 109.89 | 109.535 | 109.71 | 6747791.0 |
> showing 50 of 41,834 rows — these rows as CSV