PREVIEW / etf_30min / 2006-05-17
file: by_date/etf_30min/2006/2006-05-17.parquet size: 73 KB rows: 2,462
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-17 04:00:00 | SPY | ETF | 129.59 | 129.59 | 129.59 | 129.59 | 500.0 |
| 2006-05-17 07:00:00 | SPY | ETF | 129.47 | 129.57 | 129.46 | 129.54 | 66400.0 |
| 2006-05-17 07:30:00 | SPY | ETF | 129.48 | 129.63 | 129.48 | 129.6 | 53000.0 |
| 2006-05-17 08:00:00 | SPY | ETF | 129.4 | 129.7 | 129.4 | 129.55 | 1159900.0 |
| 2006-05-17 08:30:00 | SPY | ETF | 129.49 | 129.73 | 128.49 | 128.63 | 5689500.0 |
| 2006-05-17 09:00:00 | SPY | ETF | 128.63 | 128.71 | 128.43 | 128.67 | 1529700.0 |
| 2006-05-17 09:30:00 | SPY | ETF | 128.67 | 129.1 | 128.48 | 128.83 | 14313500.0 |
| 2006-05-17 10:00:00 | SPY | ETF | 128.82 | 128.92 | 128.35 | 128.66 | 12271700.0 |
| 2006-05-17 10:30:00 | SPY | ETF | 128.65 | 128.82 | 128.47 | 128.62 | 4623900.0 |
| 2006-05-17 11:00:00 | SPY | ETF | 128.63 | 128.65 | 127.52 | 127.53 | 13280000.0 |
| 2006-05-17 11:30:00 | SPY | ETF | 127.53 | 127.9 | 127.29 | 127.76 | 13706300.0 |
| 2006-05-17 12:00:00 | SPY | ETF | 127.75 | 128.81 | 127.74 | 127.86 | 6695300.0 |
| 2006-05-17 12:30:00 | SPY | ETF | 127.86 | 128.13 | 127.66 | 127.9 | 5360500.0 |
| 2006-05-17 13:00:00 | SPY | ETF | 127.91 | 128.08 | 127.46 | 127.53 | 5083500.0 |
| 2006-05-17 13:30:00 | SPY | ETF | 127.53 | 128.0 | 127.48 | 127.82 | 9207400.0 |
| 2006-05-17 14:00:00 | SPY | ETF | 127.81 | 127.84 | 127.35 | 127.61 | 7516900.0 |
| 2006-05-17 14:30:00 | SPY | ETF | 127.62 | 127.65 | 126.95 | 127.18 | 10348100.0 |
| 2006-05-17 15:00:00 | SPY | ETF | 127.18 | 127.68 | 127.16 | 127.59 | 8896800.0 |
| 2006-05-17 15:30:00 | SPY | ETF | 127.6 | 127.79 | 127.2 | 127.2 | 13267600.0 |
| 2006-05-17 16:00:00 | SPY | ETF | 127.19 | 127.69 | 126.76 | 126.82 | 2825500.0 |
| 2006-05-17 16:30:00 | SPY | ETF | 126.82 | 129.4 | 126.79 | 126.79 | 564100.0 |
| 2006-05-17 17:00:00 | SPY | ETF | 126.82 | 126.87 | 126.8 | 126.85 | 42500.0 |
| 2006-05-17 17:30:00 | SPY | ETF | 126.85 | 126.88 | 126.84 | 126.86 | 2000.0 |
| 2006-05-17 18:00:00 | SPY | ETF | 126.86 | 126.87 | 126.84 | 126.86 | 3400.0 |
| 2006-05-17 18:30:00 | SPY | ETF | 126.88 | 126.89 | 126.87 | 126.89 | 900.0 |
| 2006-05-17 19:00:00 | SPY | ETF | 126.9 | 127.0 | 126.9 | 127.0 | 2200.0 |
| 2006-05-17 19:30:00 | SPY | ETF | 127.01 | 127.05 | 127.0 | 127.05 | 6900.0 |
| 2006-05-17 09:30:00 | QQQ | ETF | 39.67 | 39.81 | 39.58 | 39.69 | 28708600.0 |
| 2006-05-17 10:00:00 | QQQ | ETF | 39.69 | 39.74 | 39.55 | 39.69 | 14087400.0 |
| 2006-05-17 10:30:00 | QQQ | ETF | 39.69 | 39.73 | 39.56 | 39.61 | 7691300.0 |
| 2006-05-17 11:00:00 | QQQ | ETF | 39.6 | 39.63 | 39.25 | 39.27 | 23499400.0 |
| 2006-05-17 11:30:00 | QQQ | ETF | 39.27 | 39.49 | 39.23 | 39.4 | 17810900.0 |
| 2006-05-17 12:00:00 | QQQ | ETF | 39.4 | 39.56 | 39.4 | 39.47 | 12086000.0 |
| 2006-05-17 12:30:00 | QQQ | ETF | 39.47 | 39.58 | 39.4 | 39.49 | 8500700.0 |
| 2006-05-17 13:00:00 | QQQ | ETF | 39.48 | 39.56 | 39.36 | 39.38 | 7195100.0 |
| 2006-05-17 13:30:00 | QQQ | ETF | 39.38 | 39.54 | 39.36 | 39.52 | 9227300.0 |
| 2006-05-17 14:00:00 | QQQ | ETF | 39.52 | 39.54 | 39.38 | 39.48 | 9000100.0 |
| 2006-05-17 14:30:00 | QQQ | ETF | 39.49 | 39.5 | 39.25 | 39.34 | 10955800.0 |
| 2006-05-17 15:00:00 | QQQ | ETF | 39.34 | 39.48 | 39.33 | 39.38 | 14839200.0 |
| 2006-05-17 15:30:00 | QQQ | ETF | 39.39 | 39.98 | 39.31 | 39.32 | 19422400.0 |
| 2006-05-17 08:00:00 | IWM | ETF | 73.48 | 73.48 | 73.42 | 73.42 | 1500.0 |
| 2006-05-17 08:30:00 | IWM | ETF | 73.37 | 73.4 | 72.62 | 72.65 | 1463100.0 |
| 2006-05-17 09:00:00 | IWM | ETF | 72.66 | 72.6678 | 72.4 | 72.47 | 1773400.0 |
| 2006-05-17 09:30:00 | IWM | ETF | 72.45 | 73.14 | 72.38 | 72.83 | 8602000.0 |
| 2006-05-17 10:00:00 | IWM | ETF | 72.82 | 72.89 | 72.44 | 72.66 | 6410000.0 |
| 2006-05-17 10:30:00 | IWM | ETF | 72.66 | 72.74 | 72.53 | 72.67 | 3254900.0 |
| 2006-05-17 11:00:00 | IWM | ETF | 72.66 | 72.69 | 71.97 | 71.99 | 7049900.0 |
| 2006-05-17 11:30:00 | IWM | ETF | 71.98 | 72.16 | 71.85 | 72.03 | 5520600.0 |
| 2006-05-17 12:00:00 | IWM | ETF | 72.03 | 72.48 | 72.03 | 72.38 | 3791900.0 |
| 2006-05-17 12:30:00 | IWM | ETF | 72.38 | 72.65 | 72.38 | 72.46 | 4064200.0 |
> showing 50 of 2,462 rows — these rows as CSV